Microsoft KB Archive/308753

= FIX: SQL Server 2000 SP1 Setup Fails on Execution of sp1_serv_uni.sql Script =

Article ID: 308753

Article Last Modified on 1/10/2002

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 1

-



This article was previously published under Q308753



BUG #: 354632 (SHILOH_BUGS)



SYMPTOMS
The SQL Server Service Pack 1 (SP1) setup may fail if the master database files have been moved from the original installation location. The following error message may occur:

Error running script: sp1_serv_uni.sql (1)

If you open and view the SQL Server 2000 SP1 setup log, C:\Winnt\Sqlsp.log, you may find error messages similar to the following at the end of the log:

14:05:50 C:\DOCUME~1\Administrator\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m

14:08:56 Process Exit Code: (0)

14:08:56 C:\SQL2000\SP1\800038~1.01\SP1_FO~1\x86\BINN\osql.exe -S SERVER1 -b -n -d master -o &quot;d:\Program Files\Microsoft SQL Server\ MSSQL\install\sp1_serv_uni.out&quot; -i &quot;d:\Program Files\Microsoft SQL Server\MSSQL\install\sp1_serv_uni.sql&quot; -E

14:09:06 Process Exit Code: (1)

14:20:01 Error running script: sp1_serv_uni.sql (1)

If you try to start SQL Server after you encounter this error, the server may fail to start.



CAUSE
The setup program makes some registry entries that change the location of the master database to the original location. That is why you cannot start SQL Server after you run the setup.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
To work around the problem, copy or move the master database files, master.mdf and mastlog.ldf to their original location and then re-run the SQL Server 2000 SP1 setup. After the setup completes successfully, you can follow the standard procedure to relocate the files to the desired location.

For more information about how to move the master database to a new location, refer to the &quot;Moving the Master Database&quot; section in the following article in the Microsoft Knowledge Base:

224071 INF: Moving SQL Server Databases to a New Location



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000 Service Pack 1. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

Additional query words: msde

Keywords: kbbug kbfix KB308753

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.