January 29, 2007 at 3:43 pm
I have a windows 2003 server acting as the front end application sever looking at a MSSQL 2K box with 4 instances runing on it.
The application server can see all the instances running on the database server except it doubles up on one of the instances
this can be seen using the command osql -L and via EM when adding a new server.
The out put from isql -L command looks like
server/instance1
server/instance2
server/instance3
server/instance3
server/instance4
has anyone come across this before and how do you fix it
Kevin
January 29, 2007 at 5:44 pm
Check "SQL server Client Network Utility" alias tab...if you have entry in that you get more than one names retrurned for the same instance...
MohammedU
Microsoft SQL Server MVP
January 29, 2007 at 8:43 pm
Thanks for that,
Hopfully this will fix the network errors we are getting now and again.
Kevin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply