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 |
|
riazjee
Starting Member
3 Posts |
 Posted - 2011-07-20 : 01:58:37
|
| Dear All,We have Clustered (Active/Passive) SQL Server 2008 Installation (Windows 2008 R2, 64-Bit). Once or twice in a day, we get the following error when trying to connect to SQL Server:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connectionsWe can ping both servers; if we loging to those servers using remote desktop and try conntecting to SQL Server using the Management Studio, it works fine as well. But we can not connect to SQL Server from outside of the servers. We are using domain user for SQL Server service.The only work around we found so far is to switch resources to the Passive node to make it active.Can you help to resolve this issue?Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
riazjee
Starting Member
3 Posts |
Posted - 2011-07-20 : 23:31:37
|
| Dear Tara,Could you please guide me how to do that? Do you mean adding entry in hosts file for server name? |
 |
|
|
|
|
|
A network-related or instance-specific error occur