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 |
|
CanadaDBA
583 Posts |
 Posted - 2012-01-05 : 11:06:41
|
| I have a SQL Server 2008 instance say MyServer\Prod1. And SQL Server is listening on a port# say 7000.I can register the server in SSMS as MyServer,7000\Prod1. The weird thing is that I can register as much as instances I want although they really don't exist. For example I could register:MyServer,7000\Prod2MyServer,7000\Prod3MyServer,7000\Prod4All of the above server registerations seem to be a copy of MyServer,7000\Prod1. Although I am not able to register the instances without port#; i.e. MyServer\Prod2 or MyServer\Prod3.Is this a bug in SQL Server 2008?Thanks!Canada DBA |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-01-05 : 12:43:46
|
| I'm a little thrown off by the syntax you are using. I thought that the syntax was <Server>\<Instance>:port#. If this is true, I assume it is interpreting your server name to be "MyServer,7000".Also, I'm not quite getting the same results as you in that I can register a bogus instance with or without a port specified.=================================================Men shout to avoid listening to one another. -Miguel de Unamuno |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-05 : 13:00:57
|
quote:
Originally posted by CanadaDBA
......Although I am not able to register the instances without port#; i.e. MyServer\Prod2 or MyServer\Prod3.Is this a bug in SQL Server 2008?Thanks!Canada DBA
No its not a bug.Is the SQL browser running on the server ?If its not then you have to explicitly mention the port number for the named instances.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
CanadaDBA
583 Posts |
Posted - 2012-01-06 : 12:04:54
|
| Thanks All for the responses. Bustaz Kool, I tried your suggestion as MyServer\Prod1:7000 but got an error Cannot connect...Sachin.Nand, I am running the SQL browser on my local to connect to the server.Tara, You are correct! I tried MyServer,7000 and it connected tp Prod1 instance. This resovled my issue. Thanks again.Cheers! Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Registering a Not existing instance
Tara Kizer