January 21, 2011 at 3:39 am
Hi Sql Guru's,
How to configure the sqlserver to remote access with server name.Now I"m access with IP address ***.***.*.** is my sqlserver ip address and sql server name DC01, Now I need remote access with server name(DC01) instead of IP address
Thank you ,
Suresh Mediboyina
January 23, 2011 at 6:39 pm
I'd recommend checking with your DNS team to see if they can get your server's name into DNS to allow you to connect via the name instead of the IP.
You should be able to do "nslookup ipaddress" to see if there is a name associated with your server's IP.
Presumably, doing "nslookup servername" should return nothing since you currently can't route to the server from the host initializing the connection.
Hope that helps,
Steve
January 24, 2011 at 8:21 am
Sounds like your Network Admin needs to get involved.
nslookup is one clue as to what might be setup.
Instead of just DC01, you might want to try the Fully Qualified Domain name.
Greg E
January 28, 2011 at 11:37 pm
Open a command prompt, and pint the server name do you get a reply? If so does it match the ip address you expect? Try nslookup too as already suggested. Make sure you dont have any funky local host file entries for that server name too. I've seen people enter that to test at some point and forget to remove them.
Run select @@servername on the SQL server does that return the name you expect too?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply