Hello All,
I'm trying to install SP4 on a multiple instance SQL Server 2000 server and I'm getting the following error:
Error running script: replsys.sql(1)
When I check the replsys.out file, here's what I see:
[DBNETLIB]General network error. Check your network documentation.[DBNETLIB]ConnectionRead (recv()).
Has anybody seen this error before?
I successfully install SP4 on another SQL instance running on that same server without any problems. Whatever the problem I'm having with the first instance is isolated to that instance.
Thanks in advance for any help!! It's really appreciated.
Ronnie
Thanks for getting back to me on this.
The update is failing right after it trys to run the replsys.sql
Here are the last few lines of the sqlsp.log file:
16:46:52 Begin ServPriv (EPA)16:46:52 End ServPriv()16:46:53 Upgrading databases16:46:54 Upgrading databases on instance 'EPA'16:46:54 C:\DOCUME~1\RONNIE~1.ISO\LOCALS~1\Temp\2\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQL$EPA 16:46:54 Process Exit Code: (0) 16:46:54 C:\DOCUME~1\RONNIE~1.ISO\LOCALS~1\Temp\2\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQL$EPA 16:46:54 Process Exit Code: (0) 16:46:54 C:\DOCUME~1\RONNIE~1.ISO\LOCALS~1\Temp\2\SqlSetup\Bin\scm.exe -Silent 1 -Action 1 -Service MSSQL$EPA -StartupOptions \-T4022 \-T4010 \-m16:47:05 Process Exit Code: (0) 16:47:05 D:\SQL2KSP4\x86\BINN\osql.exe -Slpc:SQLSVRDEV\EPA -b -n -d master -o "C:\Program Files\Microsoft SQL Server\MSSQL$EPA\install\replsys.out" -i "C:\Program Files\Microsoft SQL Server\MSSQL$EPA\install\replsys.sql" -E16:47:05 Process Exit Code: (1) 16:47:10 Error running script: replsys.sql (1)16:47:10 C:\DOCUME~1\RONNIE~1.ISO\LOCALS~1\Temp\2\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQL$EPA 16:47:25 Process Exit Code: (0) 16:47:25 Action CleanUpInstall:16:47:25 Installation Failed.
Thanks again.
IMPORTANT OR it will bomb here
Prior to pressing Yes here at the replsys.sql, you must stop the MSSQL$Service if it is running and set the –m parameter in the startup parameters. Then start the MSSQL$Service (in single user mode as specified by –m parameter). As soon as it starts, delay 1-2 secs ONLY, and no more to allow the database to come up, and then press YES to run the REPLSYS.sql script
Press Yes to run all the scripts up to and including 80sp4-tools.sql as the last one,
Then when you are running the SP_vupgrade_replication script.sql script, stop and do the same below
Prior to pressing Yes before the SP_vupgrade_replication script, you must stop the MSSQL$Service if it is running and set the –m parameter.
In the startup parameters. Then start the MSSQL$Service (in single user mode as specified by –m parameter). As soon as it starts, delay 1-2 secs ONLY, and no more to allow the database to come up, and then press YES to run the SP_vupgrade_replication script
You can then continue, and the setup will complete normally.
You can now run the SQL Server 2162 patch since it does not require single user mode without any intervention or special DBA fixes above.
Pete DeShan
Oracle/SQL Server DBA, System Architect
petedeshan@bellsouth.net
Pete - You are my hero!!
Thank you very much. Your instructions worked perfectly. One thing I relized I had to do for some reason is stop the default SQL instance from running. I'm running multiple instances on my SQL server and for some reason when I tried to start the instance in single user mode, I received several errors complaining about the ERRORLOG under the default server instance. Once I stopped that instance and followed your instructions, Everything worked like a charm.
I agree with you that MS should address this and either put out a new version of the SP4 and/or document how to resolve this problem. Finding a resolution is like finding buried treasure. Geezz!
Thanks again!
