Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Connect to sever by name rather than IP address


Connect to sever by name rather than IP address

Author
Message
Joie Andrew
Joie Andrew
SSC Eights!
SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)

Group: General Forum Members
Points: 968 Visits: 1899
If you can ping the server by name, then DNS is resolving the name, but SQL Server might be configured to allow connections only on a specific port. If so, you'll need to include it when connecting via SSMS. If you don't have this, the DBA should be able to provide you with the information.


I totally agree with this except for the fact that the OP said he was able to connect via IP fine and did not mention anything about specifying port numbers when he connected with IP. If he was able to connect by IP and not specify a port then name should be fine as well, unless the name cannot be resolved or the server name changed and he did not update SQL appropriately.

Joie Andrew
"Since 1982"
Ed Wagner
Ed Wagner
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10236 Visits: 9560
Joie Andrew (7/31/2013)
If you can ping the server by name, then DNS is resolving the name, but SQL Server might be configured to allow connections only on a specific port. If so, you'll need to include it when connecting via SSMS. If you don't have this, the DBA should be able to provide you with the information.


I totally agree with this except for the fact that the OP said he was able to connect via IP fine and did not mention anything about specifying port numbers when he connected with IP. If he was able to connect by IP and not specify a port then name should be fine as well, unless the name cannot be resolved or the server name changed and he did not update SQL appropriately.

Oops...good catch. Thanks.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
PearlJammer1
PearlJammer1
Old Hand
Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)

Group: General Forum Members
Points: 322 Visits: 1425
So you can successfully ping by server name, or you can't? If you can ping by server name now try connecting by name again in ssms.



I can ping by name. I cannot still connect via ssms using the fqdn (like i used in the ping command)
Joie Andrew
Joie Andrew
SSC Eights!
SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)

Group: General Forum Members
Points: 968 Visits: 1899
Is the IP address that reponds to the ping the same IP that you use to successfully connect?

Curious, if you connect to one of these instances by IP name what do you get when you run the following query:

SELECT @@servername

One last thing: on an instance that you can connect to by IP what ports/protocols/names does the SQL Error log say it is listening on?

Joie Andrew
"Since 1982"
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search