While I was accessing my SharePoint site, suddenly, it threw the following error:
A few times, I also got the following error:
I opened SQL Server Management Studio and got to know that the Content Database was in "Suspect" mode. So, how do we bring this up to Normal mode.?! I did a quick googling and I got this article which shows step by step method to bring the database back to Normal mode. Of course, my content database is back to Normal!
A note: As per MSDN, the command sp_resetstatus will be removed in a future version of SQL Server. So, you may have to use ALTER DATABASE statement to achieve the same.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
A few times, I also got the following error:
Cannot open database "MyDb" requested by the login. The login failed.
Login failed for user 'Domain\Username'.
I opened SQL Server Management Studio and got to know that the Content Database was in "Suspect" mode. So, how do we bring this up to Normal mode.?! I did a quick googling and I got this article which shows step by step method to bring the database back to Normal mode. Of course, my content database is back to Normal!
A note: As per MSDN, the command sp_resetstatus will be removed in a future version of SQL Server. So, you may have to use ALTER DATABASE statement to achieve the same.
Comments
Post a Comment