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 |
|
acesover
Starting Member
15 Posts |
 Posted - 2014-08-18 : 13:04:24
|
| We host multiple instances of sql server 2005 on a single server. Each instance is assigned it's own IP address so that all instances can run on port 1433.Last week all client database connections stopped working. Further investigation found that the client conection string that had previously used the SERVER\INSTANCE name, no longer worked. The only fix was to change the connection to use the instance IP address. This applied to ODBC connections as well.As far as I know, nothing was changed in the infrastructure for the network or protocols, etc. Has anyone seen this before and know what caused it? Thanks.dan |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-18 : 13:51:30
|
| Check the SQL Browser service. I would restart it and then test again.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Connections using instance names started failing