Can not connet to server after renameing it

  • Hi folks,

    I had someone on my team use sp_dropserver and sp_addserver, now they can not connect to the instance.

    Any quick ideas?

  • Use the IP address.

    10.1.1.1/Servername for names instance

    or

    10.1.1.1

    This is an example IP address ping to find the real one

  • you can also log into the server and then open SSMS and use local host or ' .' to connect to the local server, then you can use Select @@servername to find out the server name

    Make sure you find out who renamed the serer 🙂

  • that did it .

    thanks folks

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

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