SQL Clone
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
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6695 Visits: 2032
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
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50987 Visits: 10844
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
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1716 Visits: 1452
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
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6695 Visits: 2032
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