465789psw
Hall of Fame
Points: 3314
More actions
August 25, 2009 at 8:51 am
#134400
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?
Alan. T.
Points: 3221
August 25, 2009 at 8:59 am
#1044246
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
CrazyMan
SSChampion
Points: 12560
August 25, 2009 at 9:14 am
#1044257
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 🙂
August 25, 2009 at 9:15 am
#1044262
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