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.
- Open SQL Server Configuration manager
- Go under SQL Native Client 11.0 Configuration (32 bit)
- Click Client protocols
- On right side pane, we have three protocols.
- Check if “Named pipes” is enabled.
If its not enabled then right click and enable it as shown in below image.
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)