We have a SharePoint 2010 production server (A) linked to a SQL server production server (B).
We also have a SharePoint 2010 test server (X) linked to a SQL server Test server (Y).
When we stop the SQL service on the SQL server Test server (Y), we are getting errors on the SharePoint 2010 production server (A).
Exemple, if I go Central Administration -> Timer Job Status, we get an error page and the event viewer is filler with error like :
Unknown SQL Exception 2 occurred. Additional error information from SQL Server is included below. 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 connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
We also got some errors with the search at some point but those error don't appear every time.
We verified Central Administration -> Manage Databases Upgrade Status and every database is on the SQL server production server (B) and nothing is set in the "Failover Database Server" of the WSS_Content and SharePoint_AdminContent database.
We tried many tings like "Clearing the SharePoint Configuration Cache" and so on, but no luck yet.
What are we missing?
We just noticed that there is a copy of the production Configuration Database
SharePoint_Config on both the B and Y server.
- In SQL server Management studio's Activity monitor on the B server, we notice that the A server in connected to all database except the
- In SQL server Management studio's Activity monitor on the Y server, we notice that the X server in connected to all database plus the A server connection to the
Meanwhile, everything indicate it should connect on the B server. Example, if we go in Central Administration : Servers in Farm* on the A server.
Configuration database version: 14.0.7149.5000 Configuration database server: (Name of server B) Configuration database name: SharePoint_Config
Same thing in Central Administration : Manage Databases Upgrade Status, we see the
SharePoint_Config database, but it say (Name of server B) for the SQL Instance.