I have a server that have a default instance and several named instance.
Below are the Instances: SERVER -- <DEFAULT_INSTANCE> -- PORT 1434 SERVER -- INSTANCE1 -- PORT 1433 SERVER -- INSTANCE2 -- PORT 1435 SERVER -- INSTANCE3 -- PORT 1436
When I am connecting remotely to <DEFAULT_INSTANCE>, it instead connect to INSTANCE1. Its either using OSQL or SSMS.
To be able to connect to the default instance, its either I create an alias or specify the port after the server(SERVER,1434).
What is the rationale behind this? Is there a way to connect without specifying the port or creating an alias?
1433 is the IANA SQL socket number. If you run a "nestat -an" from the command line - you'll see something the LISTENING ports , one of them will be 1433. As webfred said , default instance always listens on static port. Do you have SQL Server Browser Service on ?
Default and Named Instance
Posted - 03/08/2012 : 05:03:58
