Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    24

    Unanswered: 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???

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    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


    Quote Originally Posted by m.inckle
    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???
    Have you hugged your backup today?

  3. #3
    Join Date
    Feb 2004
    Posts
    24

    Probelms with SQL Server

    thanks it ok now i've cracked it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •