Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JazzieG1316
Starting Member
3 Posts |
 Posted - 2012-03-08 : 05:03:58
|
| I have a server that have a default instance and several named instance. Below are the Instances:SERVER -- <DEFAULT_INSTANCE> -- PORT 1434SERVER -- INSTANCE1 -- PORT 1433SERVER -- INSTANCE2 -- PORT 1435SERVER -- INSTANCE3 -- PORT 1436When 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?Any explanation would be greatly appreciated |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-03-08 : 05:20:22
|
By default, the default instance of SQL Server listens for requests from SQL Server clients on static port 1433.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-03-08 : 15:05:38
|
| 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 ?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Default and Named Instance