FIX: SQL Server 2000 SP1 Setup Fails on Execution of sp1_serv_uni.sql Script (308753)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions) SP1
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 "d:\Program Files\Microsoft SQL Server\
MSSQL\install\sp1_serv_uni.out" -i "d:\Program Files\Microsoft SQL Server\MSSQL\install\sp1_serv_uni.sql" -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.
RESOLUTIONTo 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 "Moving the Master Database" section in the following article in the Microsoft Knowledge Base:
224071 INF: Moving SQL Server Databases to a New Location
STATUSMicrosoft 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.
| Modification Type: | Major | Last Reviewed: | 1/10/2002 |
|---|
| Keywords: | kbbug kbSQLServ2000SP2Fix KB308753 |
|---|
|