Post reply

Error 1722 - (The RPC server is unavailable) occurred while...

  • July 13, 2006 at 9:57 am

    #60928

    I'm trying to see if it's possible to create an Alias for a named instance in order to avoid the naming convention of ServerName\InstanceName.  I'm able to register the server in EM and also connect to the instance using the Alias name, however when I try to stop the SQL Server service from within EM I receive the following error.

    An error 1722 - (The RPC server is unavailable) occurred while performing this service operation on the MSSQLServer service.

    Any idea on what is causing this error?

    Thanks,   Dave

  • July 17, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • January 1, 2008 at 9:55 pm

    #763910

    I get the same error

    I don't have any idea; but I can tell you my situation.

    Firstly, all my instances are named in the way you said; servername\instancename.

    I can create an alias and have made more than one alias to the same instance - reasons follow.

    I found a few days ago, I could not register the instance, after its removal from the server group it had been under; so far I have only been able to reconnect via an alias. This was after removal of an un-needed instance, using the install program, and running servicepak 4 (sql server 2000) again.

    Now this is what is strange; my named pipes alias doesn't get the problem (you described), but my alias that uses local host DOES. That is; an alias using TCP, 127.0.0.1\instancename registers, but after running servicepak 4 get the error you discuss.

    Sorry if this just muddies it all,

    David

    Strangely, only 7 of 13 usual scripts run on the instance I'm trying to re-register when I run servicepak 4.

  • January 2, 2008 at 8:14 am

    #764057

    I don't recall how or if I resolved the problem. Here are two links someone passed along to me that may be of some use.

    http://support.microsoft.com/kb/306985/

    http://support.microsoft.com/default.aspx?scid=kb;en-us;q323790

    If the server was registered before you created the alias, try deleting the server registration in EM and then re-register the server. I have a feeling this will not solve your problem.

    Good luck,

    Dave

  • August 20, 2008 at 3:58 pm

    #860921

    I just re-registered my server in SSMS and this issue went away.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply