Hiya Jess
What version? If 6/6.5:
"If you have changed the Windows NT Server computer name, but not the SQL Server name, and the @@SERVERNAME variable is neither NULL nor matches the Windows NT Server computer name, you must run the sp_drop server and sp_addserver
, LOCAL commands to alter the SQL Server name. For additional information, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q140683
TITLE : INF: Run Task May Cause 1722 Error"
>When starting SQL Server, it gives me an error 1722 - (The RPC Server is unavailable) occured while performing this service operation on the MSSQLServer service.
>
>Please help.
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05