SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005

While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error.

TITLE: Maintenance Plan Wizard Progress
Saving maintenance plan failed.
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.

I was not very sure what changes in made to SQL Server which was causing this error. I search on the internet and found many reasons of the error. Here is the solution of my error.


In my server, I found that named pipes were disabled. Here are the steps to check.

  1. Open SQL Server Configuration manager
  2. Go under SQL Native Client 11.0 Configuration (32 bit)
  3. Click Client protocols
  4. On right side pane, we have three protocols.
  5. Check if “Named pipes” is enabled.

If its not enabled then right click and enable it as shown in below image.

SQL SERVER - The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005 maint-plan-con-01-800x376

This is very rare error but honestly, I have seen it enough time to create a blog post about it. If you find some other solution of the same error, please share via comments. I will publish on the blog with due credit.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Computer Network, Maintenance Plan, SQL Error Messages, SQL Server
Previous Post
SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task
Next Post
SQL SERVER – Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It

Related Posts

3 Comments. Leave new

Leave a Reply