November 1, 2005 at 5:35 am
When installing SQL Server Service Pack 4, the install may fail in script replsys.sql.
Cause:
Installation of replsys.sql requires SQL Server to be listening using the local named pipes protocol. When the SQL Server Service account has been changed thru the Service Management Console, SQL Server will not listen properly.
WorkAround:
Change the service account thru SQL Enterprise Manager, restart SQL Server and then re-run the install.
Pre-Installation Check:
Insure that all protocols are enabled by looking in the errorlog for the startup listening message which will look like:
server SQL server listening on TCP, Shared Memory, Named Pipes.
SQL = Scarcely Qualifies as a Language
November 1, 2005 at 6:03 am
Under what account is the MSSQLSERVER service running? Use "services.msc" (start->run->services.msc) to find out.
Run svrnetcn.exe and see if "Named Pipes" is listed under enabled protocols. If not, move it from enabled to disabled.
If not of this has helped then...
If you have "SQL Server Enterprise Manager", right click on your server, goto "properties", goto "Security" tab, set it to "Local system" and try again. This should change the user account you see listed in "services.msc" from above and may help fix your problem.
Cheers
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply