Re: SP4 error running replsys.sql
- From: "Ray Yan" <RayYan@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 3 Sep 2005 23:25:18 -0700
Curt, thank you very for posting these info here, I've been looked around for
days for the answer!
Even I couldn't delete the 'LPC' key, but after I changed the logins for
both server and agent from local user to local system, then stop/start them
via services mmc, sp4 installation worked. I didn't bother change the logins
back because this is a test/dev box.
Thanks once again!
"curt.mader@xxxxxxxxx" wrote:
> I will reply to my own message and tell you how my issue was resolved
> (with the help of a Microsoft Phone Support person in India and to the
> detriment of my wallet to the tune of $245). Hopefully this will help
> any other who are having this same problem...
>
> Here's the short version:
>
> I had switched the account that SQL Server uses to start and I did this
> through the Services MMC. This caused the SQL Server to not listen
> properly on LPC(shared memory). Apparently replsys.sql uses this
> protocol to communicate with the SQL Server.
>
> 1) In the registry, made a backup copy of the LPC key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLserver\SuperSocketNetLib
>
> 2) Then delete the LPC key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLserver\SuperSocketNetLib
> (Disclaimer: I make no guarantees to anyone who messes with the
> registry)
>
> 3) Using the Services MMC I set the SQL Server startup account back to
> the Local System account and restarted the SQL Server instance.
>
> 4) Changed the SQL start up account to domain account using the SQL
> Enterprise Manager and again restarted that instance of SQL Server.
>
> Ta-da! The SP4 installation worked!
>
> Here are some other MS KB links that the tech support guy sent to me:
>
> Potential causes of the "SQL Server does not exist or access denied"
> error message http://support.microsoft.com/?id=328306
>
> How to troubleshoot the "Cannot generate SSPI context" error message
> http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
>
> How to troubleshoot connectivity issues in SQL Server 2000
> http://support.microsoft.com/default.aspx?scid=kb;en-us;827422
>
> HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
>
> -Curt Mader (I got by with a little help from my friends (at Microsoft
> tech Support))...
>
>
.
- Follow-Ups:
- Re: SP4 error running replsys.sql
- From: jupitervast
- Re: SP4 error running replsys.sql
- Prev by Date: Software Vendor Recommended hardware
- Next by Date: SQL Cluster
- Previous by thread: Software Vendor Recommended hardware
- Next by thread: Re: SP4 error running replsys.sql
- Index(es):
Relevant Pages
|
