July 13, 2006 at 3:16 pm
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
July 17, 2006 at 8:00 am
This was removed by the editor as SPAM
July 17, 2006 at 8:31 am
Sounds like the service pack installer is having problems connecting to the instance via shared memory. The service pack attempts to connect via shared memory and places the sql server in single user mode, after it checks for connectivity problems (i.e. osql.exe -Slpc:InstanceName, where InstanceName is your SQL Server instance name). If it cannot connect via shared memory because of a Windows resource problem, a reboot is in order.
At what point in your sqlsp.log are you noticing the issues? Immediately, or after the initial checks have been performed? If it is after the the initial connectivity check, there may be something else going on that we have experienced in the past, but I would rather not type our problem/resolution if it is not relevant to what you are experiencing.
July 17, 2006 at 1:43 pm
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 databases
16: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 \-m
16: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" -E
16: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.
Ronnie
July 17, 2006 at 3:51 pm
No problem.
Thanks for the log post. I am not sure if this will help or not, but there maybe another process that is logging onto your SQL Server prior to the service pack updating it. I would recommend stopping your instance and restarting it in single user mode, just like the script shows (or from the command-line sqlservr ... i.e. MSSQL\Binn\sqlservr -c -m -T4022 -T4010), and from another command line session logon to your instance as the script does i.e. osql -Slpc:SQLSVRDEV\EPA -d master (you can omit the -n and - b if you like). If this is the same problem that plagued us on a few systems, you should get something like the database is in use or only one connection is allowed while in single user mode.
For us, we had a Webservice running on the SQL Server (WSUS) that ran as the NT Authority/SYSTEM account, and reconnected to the database as soon as it became available. That was locking out the service pack from connecting and running the replsys.sql file. If something else is blocking you, I would recommend that if you have IIS or a Webserver running on your SQL Server machine, temporarily stop it or just the Web application that is running on it, until your update is complete. Otherwise, you may have hunt down and temporarily stop whatever application is connecting to your database while you update the system.
Hope that this helps ....
July 24, 2006 at 4:06 pm
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
IMPORTANT OR it will bomb here
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.
July 26, 2006 at 3:10 pm
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!
Ronnie
June 19, 2010 at 1:17 am
1. Check if distribution database exist though the Replication is dropped
2. If so drop the distribution database
3. To drop the distribution database by over - restoring of some user database
4. Perform the patching / SQL SP again.
It has worked fine for me 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply