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

SQL
2 Comments

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.
——————————
ADDITIONAL INFORMATION:
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.

WORKAROUND/SOLUTION

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)

, , ,
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

2 Comments. Leave new

Leave a Reply

Menu