Maintenance Task Error SQL Server 2K8 R2
Posted on 2011-05-06
My SQL Server Instance was renamed, and now getting the following error when tried to open or delete the maintenance task. Now, unabel to modify, delete, script the mainteance task.
Exception has been thrown by the target of an invocation. (mscorlib)
A network-related or instance specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL
Server is configured to allow remote connection. (provide: Named Pipes Provider, error: 40-
Could not open a connection to SQL Server) (Microsoft SQL Server, Error:53)
I have checked the named pipes, it's enable.