cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

SPSqlLatencyMonitor.PingServers: exception encountered: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Nintex_Test" requested by the login.

We are using db version 3.0.2.0

 

I recently removed a Nintex Content Database from our farm as it was for a site we were no longer using. I removed the site through central administration, waited about 5 minutes to let any timer jobs run then dismounted the SP ContentDB, removed it from SQL and updated entries in the [Storage], [ContentDbMapping], and [Databases] tables where needed.

 

Now I am getting this entry every few seconds:

 

SPSqlLatencyMonitor.PingServers: exception encountered: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Nintex_Test" requested by the login.

 

Have I missed a table entry somewhere? This is the first time I've had this issue come up and, while this doesn't make me an expert, I've removed many instances in this way from our QA and Production environments.

 

How can I get this to stop? It appears that something in SharePoint thinks that DB is still in use. But there are no sites in CA and no DBS, mounted or dismounted, that point to this Nintex_Test database.

 

Troubleshooting ideas?

Labels: (1)
Reply
2 Replies
Workflow Hero

Re: SPSqlLatencyMonitor.PingServers: exception encountered: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Nintex_Test" requested by the login.

Have you solved it?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: SPSqlLatencyMonitor.PingServers: exception encountered: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Nintex_Test" requested by the login.

It sounds like you removed it correctly. Could you post the full ULS error using the correlation ID...if it is still happening. It could be that enough time hadn't passed to complete the process, which can be quickened by running iisreset /noforce on your server.

0 Kudos
Accept as Solution Reply