Link to home
Start Free TrialLog in
Avatar of Favorable
FavorableFlag for United States of America

asked on

Maintenance Task Error SQL Server 2K8 R2

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.

 Error:
  Exception has been thrown by the target of an invocation. (mscorlib)
 
  Additional information:
  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.

Please help.
SOLUTION
Avatar of dba2dba
dba2dba

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Favorable

ASKER

Having to completely uninstall the instance and reinstall.