Unable to browse website: Microsoft OLE DB Provider for SQL Server error 80004005

Created:

2016-11-16 12:39:17 UTC

Modified:

2017-08-08 13:41:55 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Unable to browse website: Microsoft OLE DB Provider for SQL Server error 80004005

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

Unable to browse website. The following is shown instead of content:

Microsoft OLE DB Provider for SQL Server error '80004005'
Warning: Fatal error 9001 occurred at Jun 18 2016 12:50PM. Note the error and time, and contact your system administrator.
/Default.asp, line 67

In Event viewer following error can be found:

The log for database 'dbname' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

Unable to add database user for dbname via Plesk GUI:

Error: Connection to the database server has failed: The log for database 'dbname' is not available. Check the event log for related error messages. Resolve any errors and restart the database. (Error code 1)

Unable to create database backup via Plesk GUI:

Source: System.Data

Message: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

Stack trace: at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at mla_gui.NewQuery.btnSubmit_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Target site: System.Data.SqlClient.SqlInternalConnection GetOpenConnection(System.String)

Cause

Corrupted log file C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MSSQL\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\dbname.LDF

Resolution

  1. Stop MSSQL service:

    net stop MSSQLSERVER
  2. Rename log file C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MSSQL\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\dbname.LDF

  3. Start MSSQL:

    net start MSSQLSERVER
Have more questions? Submit a request
Please sign in to leave a comment.