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)
I ran into the same issue today and it was resolved by enabling the Shared Memory not the Named Pipes
Hope this helps
Thanks for sharing this solution Kal. It would definitely help others.
for my case, my domain account was not authorized to login