SQL Server Performance Forum – Threads Archive

Connect sql server with instance name

How to connect sql server with instance name, if we don’t know the port number.
E.G:-
If on one NT box we have 3 instance and i want to connect to 3rd instance, how can I connect if I don’t have port number.
Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–

<server_name><instance_name> should do the trick.

quote:Originally posted by Adriaan <server_name><instance_name> should do the trick.

I belong to some other network in that case your trick "<server_name><instance_name>" will not work….. I know that by providing full machine name or IP we can connect to default instance. But in my case I have to connect to some other instance which is not default instance. Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–

In that case either the FQDN, or the IP address for the server, plus the instance name, should work – by the way, this would also work within the domain: <fully_qualified_domain_name><instance_name> <999>.<999>.<999>.<999><instance_name> Problem with an IP address is that it is not necessarily static, whereas a FQDN should be.

quote:Originally posted by Adriaan In that case either the FQDN, or the IP address for the server, plus the instance name, should work – by the way, this would also work within the domain: <fully_qualified_domain_name><instance_name> <999>.<999>.<999>.<999><instance_name> Problem with an IP address is that it is not necessarily static, whereas a FQDN should be.

Already tested but this does not work,that is why I ask is not possible to connect sql without post number. Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–

May check KBAhttp://support.microsoft.com/kb/265808/en-us &http://support.microsoft.com/?kbid=839269 andhttp://www.aspfaq.com/sql2005/show.asp?id=3 link for relevancy.
Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

The use of the instance name will depend on whether udp port 1434 is open between the ‘client’ and the ‘server’ if that port is not open OR the sql instance has been set to hide itself from the network, then there is no way to connect without knowing the port number the only reason that you can connect to the default instance without a port number is that the default port is 1433 which ODBC will automatically try if no port number or instance are given. Cheers
Twan

Hi, may suggest you to read following link : http://www.databasejournal.com/features/mssql/article.php/3460491</a> <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

]]>