Install issue with SQL Server 2005 Enterprise

I am having a really hard time installing SQL Server 2005 Enterprise
Edition. My server definitely meets the hardware requirements of the
server. The server OS is Windows 2003 Enterprise R2. The problem
occurs during setup. After checking my system configuration, it goes
to the window that generates a list of items it is going to install (I
believe). Here, as soon as it starts generating the list, it freezes
the whole server and then shuts down. It does this every single time.
Any thoughts or suggestions?
First thing, check the setup log files in C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
error info.
Linchi
"CarlosSanchezJr@.gmail.com" wrote:

> I am having a really hard time installing SQL Server 2005 Enterprise
> Edition. My server definitely meets the hardware requirements of the
> server. The server OS is Windows 2003 Enterprise R2. The problem
> occurs during setup. After checking my system configuration, it goes
> to the window that generates a list of items it is going to install (I
> believe). Here, as soon as it starts generating the list, it freezes
> the whole server and then shuts down. It does this every single time.
> Any thoughts or suggestions?
>
|||In addition , if your computer is connected to the network , try unplug
the cable and start an installation
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...[vbcol=seagreen]
> First thing, check the setup log files in C:\Program Files\Microsoft SQL
> Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> error info.
> Linchi
> "CarlosSanchezJr@.gmail.com" wrote:
|||I have checked the log files and did not see anything there that caused
an issue. I also tried the disabling of my network connection and that
also did not work.
I am at a complete loss here. Everything is great until it does the
System Configuration Check. Then it just suddenly freezes the whole
server and I have to do a hard reboot.
Uri Dimant wrote:[vbcol=seagreen]
> In addition , if your computer is connected to the network , try unplug
> the cable and start an installation
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
|||Never did get this working on 2003 Enterprise R2, however, I tried it
on 2003 Standard R2 and it installed without any problems. Very odd.
CarlosSanchezJr@.gmail.com wrote:[vbcol=seagreen]
> I have checked the log files and did not see anything there that caused
> an issue. I also tried the disabling of my network connection and that
> also did not work.
> I am at a complete loss here. Everything is great until it does the
> System Configuration Check. Then it just suddenly freezes the whole
> server and I have to do a hard reboot.
> Uri Dimant wrote:

Install issue with SQL Server 2005 Enterprise

I am having a really hard time installing SQL Server 2005 Enterprise
Edition. My server definitely meets the hardware requirements of the
server. The server OS is Windows 2003 Enterprise R2. The problem
occurs during setup. After checking my system configuration, it goes
to the window that generates a list of items it is going to install (I
believe). Here, as soon as it starts generating the list, it freezes
the whole server and then shuts down. It does this every single time.
Any thoughts or suggestions?First thing, check the setup log files in C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
error info.
Linchi
"CarlosSanchezJr@.gmail.com" wrote:
> I am having a really hard time installing SQL Server 2005 Enterprise
> Edition. My server definitely meets the hardware requirements of the
> server. The server OS is Windows 2003 Enterprise R2. The problem
> occurs during setup. After checking my system configuration, it goes
> to the window that generates a list of items it is going to install (I
> believe). Here, as soon as it starts generating the list, it freezes
> the whole server and then shuts down. It does this every single time.
> Any thoughts or suggestions?
>|||In addition , if your computer is connected to the network , try unplug
the cable and start an installation
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> First thing, check the setup log files in C:\Program Files\Microsoft SQL
> Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> error info.
> Linchi
> "CarlosSanchezJr@.gmail.com" wrote:
>> I am having a really hard time installing SQL Server 2005 Enterprise
>> Edition. My server definitely meets the hardware requirements of the
>> server. The server OS is Windows 2003 Enterprise R2. The problem
>> occurs during setup. After checking my system configuration, it goes
>> to the window that generates a list of items it is going to install (I
>> believe). Here, as soon as it starts generating the list, it freezes
>> the whole server and then shuts down. It does this every single time.
>> Any thoughts or suggestions?
>>|||I have checked the log files and did not see anything there that caused
an issue. I also tried the disabling of my network connection and that
also did not work.
I am at a complete loss here. Everything is great until it does the
System Configuration Check. Then it just suddenly freezes the whole
server and I have to do a hard reboot.
Uri Dimant wrote:
> In addition , if your computer is connected to the network , try unplug
> the cable and start an installation
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> > First thing, check the setup log files in C:\Program Files\Microsoft SQL
> > Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> > error info.
> >
> > Linchi
> >
> > "CarlosSanchezJr@.gmail.com" wrote:
> >
> >> I am having a really hard time installing SQL Server 2005 Enterprise
> >> Edition. My server definitely meets the hardware requirements of the
> >> server. The server OS is Windows 2003 Enterprise R2. The problem
> >> occurs during setup. After checking my system configuration, it goes
> >> to the window that generates a list of items it is going to install (I
> >> believe). Here, as soon as it starts generating the list, it freezes
> >> the whole server and then shuts down. It does this every single time.
> >>
> >> Any thoughts or suggestions?
> >>
> >>|||Never did get this working on 2003 Enterprise R2, however, I tried it
on 2003 Standard R2 and it installed without any problems. Very odd.
CarlosSanchezJr@.gmail.com wrote:
> I have checked the log files and did not see anything there that caused
> an issue. I also tried the disabling of my network connection and that
> also did not work.
> I am at a complete loss here. Everything is great until it does the
> System Configuration Check. Then it just suddenly freezes the whole
> server and I have to do a hard reboot.
> Uri Dimant wrote:
> > In addition , if your computer is connected to the network , try unplug
> > the cable and start an installation
> >
> >
> > "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> > news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> > > First thing, check the setup log files in C:\Program Files\Microsoft SQL
> > > Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> > > error info.
> > >
> > > Linchi
> > >
> > > "CarlosSanchezJr@.gmail.com" wrote:
> > >
> > >> I am having a really hard time installing SQL Server 2005 Enterprise
> > >> Edition. My server definitely meets the hardware requirements of the
> > >> server. The server OS is Windows 2003 Enterprise R2. The problem
> > >> occurs during setup. After checking my system configuration, it goes
> > >> to the window that generates a list of items it is going to install (I
> > >> believe). Here, as soon as it starts generating the list, it freezes
> > >> the whole server and then shuts down. It does this every single time.
> > >>
> > >> Any thoughts or suggestions?
> > >>
> > >>

Install issue with SQL Server 2005 Enterprise

I am having a really hard time installing SQL Server 2005 Enterprise
Edition. My server definitely meets the hardware requirements of the
server. The server OS is Windows 2003 Enterprise R2. The problem
occurs during setup. After checking my system configuration, it goes
to the window that generates a list of items it is going to install (I
believe). Here, as soon as it starts generating the list, it freezes
the whole server and then shuts down. It does this every single time.
Any thoughts or suggestions?First thing, check the setup log files in C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
error info.
Linchi
"CarlosSanchezJr@.gmail.com" wrote:

> I am having a really hard time installing SQL Server 2005 Enterprise
> Edition. My server definitely meets the hardware requirements of the
> server. The server OS is Windows 2003 Enterprise R2. The problem
> occurs during setup. After checking my system configuration, it goes
> to the window that generates a list of items it is going to install (I
> believe). Here, as soon as it starts generating the list, it freezes
> the whole server and then shuts down. It does this every single time.
> Any thoughts or suggestions?
>|||In addition , if your computer is connected to the network , try unplug
the cable and start an installation
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...[vbcol=seagreen]
> First thing, check the setup log files in C:\Program Files\Microsoft SQL
> Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> error info.
> Linchi
> "CarlosSanchezJr@.gmail.com" wrote:
>|||I have checked the log files and did not see anything there that caused
an issue. I also tried the disabling of my network connection and that
also did not work.
I am at a complete loss here. Everything is great until it does the
System Configuration Check. Then it just suddenly freezes the whole
server and I have to do a hard reboot.
Uri Dimant wrote:[vbcol=seagreen]
> In addition , if your computer is connected to the network , try unplug
> the cable and start an installation
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...|||Never did get this working on 2003 Enterprise R2, however, I tried it
on 2003 Standard R2 and it installed without any problems. Very odd.
CarlosSanchezJr@.gmail.com wrote:[vbcol=seagreen]
> I have checked the log files and did not see anything there that caused
> an issue. I also tried the disabling of my network connection and that
> also did not work.
> I am at a complete loss here. Everything is great until it does the
> System Configuration Check. Then it just suddenly freezes the whole
> server and I have to do a hard reboot.
> Uri Dimant wrote:sql

Inserts per Second

SQL Server 2005;
What rank of inserts per second could be archived
on a modern desktop (1CPU/3GHz/1GB) hardware?
How this compare to a dedicated server hardware?
And most important question;
In a scenario when an applications writes received data to a database.
Which insert method would give the fastest results?
And which method do you recommended for actual use?
(bulk insert, asynchronous inserts, packaged inserts, or something else)
Thanks,
Mitja SemolicYour question is impossible to answer. There are too many variables.
Your "on a modern desktop" question --
Do you mean that you would have SQL Server installed on this "modern
desktop" and you would be inserting data locally?
Or do you mean that a client application would be running on this desktop
and inserting data to a SQL Server ON THE NETWORK?
How is your application written? How are your stored procedures or insert
statements? Do you SET NOCOUNT ON or do you receive the "n rows affected"
from your insert statement?
Did you drop the non-clustered indexes on your tables before running the
inserts?
If you want a super fast "just get the data in there" routine, BULK INSERT
is probably your fastest bet. If you want to be able to create an error
file you will need to use BCP. If you want to insert your data one row at a
time, read the file and call an insert stored procedure or build the T-SQL
within your application to perform the insert.
Keith Kratochvil
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:yTDcg.3320$oj5.1032258@.news.siol.net...
> SQL Server 2005;
> What rank of inserts per second could be archived
> on a modern desktop (1CPU/3GHz/1GB) hardware?
> How this compare to a dedicated server hardware?
> And most important question;
> In a scenario when an applications writes received data to a database.
> Which insert method would give the fastest results?
> And which method do you recommended for actual use?
> (bulk insert, asynchronous inserts, packaged inserts, or something else)
> Thanks,
> Mitja Semolic
>|||I was expecting an obsolete answer,
so I wondered if it was worth posting?
I don't want to confuse you with a simple question.
But are there any concrete benchmark result
that could showcase the SQL server performance
in different scenarios and different hardware?
Let me ask you a similar question:s
How fast a car can go, what is its track time?
How many frames per second can draw a graphics card for a specific game?
Are this questions also impossible to answer?
Some thinks should be left simple.
Mitja Semolic