Problems installing SQL Server 2000

i have recently formated my laptop, and ever since i can't get SQL Server 2000 running correcly

The install seems to go ok, but when i open Enterprise Manager, and select databases, theres nothing there and i get an error saying the connection has stopped

When i try to install Service Pack 3 i get the following error:

Error running script: sp3_serv_uni.sql(1)

does any 1 know what this means

i've uninstalled many times but i still get the same errors

What am i doing wrong?What OS are you running on your laptop?

What service pack?

What version SQL are you running (Developer? MSDE?)?

You can go to your %SYSTEMROOT% directory and look for sqlstp.log and sqlsp.log. These are the installation log files. Any errors that SQL encounters during install will be documented there. One of the two files increments by 1 each time you attempt the install (but I can't remember which one it is).

The one time that I had trouble installing SQL Server was in a clustered environment, trying to install SQL on a virtual server. It turned out that I had to update the MDAC before trying to install SQL; you may consider updating your MDAC (but that's only a wild guess).

Regards,

hmscott

i have recently formated my laptop, and ever since i can't get SQL Server 2000 running correcly

The install seems to go ok, but when i open Enterprise Manager, and select databases, theres nothing there and i get an error saying the connection has stopped

When i try to install Service Pack 3 i get the following error:

Error running script: sp3_serv_uni.sql(1)

does any 1 know what this means

i've uninstalled many times but i still get the same errors

What am i doing wrong?|||thanks it ok now i've cracked it

Problems installing MSDE Desktop SP3a SQL server

Hi,
I'm trying to install MSDE Desktop SP3a SQL server on my Windows 2000 Professional Laptop.
Every time I try it nearly finishes the installation and then just rollsback.
Can anyone help? Is this a known issue?
Thanks in advance,
JockyHave you tried using the verbose logging switch when you install? You need to add something like this to the setup.exe you are running fromthe commandline:

/L*v c:\msde_install.log

|||The following article might help you setup MSDE from command line.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q324998|||

That Microsoft article did the trick. Thanks y'all!

Jocky.

Problems (re)installing SQL Server 2005 in WinXP pro

I am attempting to install the Standard edition on a WinXP pro laptop that apparently had this installed before I got it. I Removed, thru Add/Remove, everything related to SQL Server. When I tried to do a fresh install of DB Services, Integration Services and Client tools, Setup Support and the Native Client seems to install ok, the directories get created and some files are put there. The installer stops and sez that the Databases Services and the Workstation Components are already installed, the Details button tells me that the only available option are thru the Add/Remove Programs. There are no entries for the Server or Client Tools on Add/Remove's list.

When I try to start the server it fails with "can't find the Path" reported in an Error Event, likewise I can't start the Management Studio because it can't find a file.

I think that I need to clean everything out to reinstall. I think that the Services are left over from the previous owner. Any suggestions?

joe elsaesser

documentation on manual uninstall process for sql 2005: http://support.microsoft.com/?kbid=909967&SD=tech|||

thank you, Derek. It went very well...

j

|||

if you are satisfied would you please mark an answer.

thanks,

Derek