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:56
|
| 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 |
|
|
|
|
|
Default and Named Instance