"Lynn" wrote:

> Hi,
>
> I tried to rename and delete one old maintenance plan which is created by
> other DBA and before the machine was renamed.  But, I kept getting the
> following error.  I can rename and delete the maintenance plan I created.
>
> An error has occurred while establishing a connection to the server.  When
> connecting to SQL server 2005, this failure may be cuased by the fact that
> under the default settinfs SQL server does not allow remote connections
> (provider:  Named Pipes providers, error: 40 - could not open a connection to
> SQL server) (Microsoft SQL server, Error: 53)
>
> Shared Memory, TCP and Named Piples are all enabled.
>
> Please advise. 
> --
> Best Regards,
>
> Lynn

"Lynn" wrote:

> I think the problem is that the maintenance plan use the Local Server
> Connection which still point to the old machine name.  (I couldn't move this
> connection or modify the server name for this connection at all).  I add
> another connection, but I still couldn't delete this maintenance plan. 
>
> Please advise.
> --
> Best Regards,
>
> Lynn
>
>
> "Lynn" wrote:
>
> > Hi,
> >
> > I tried to rename and delete one old maintenance plan which is created by
> > other DBA and before the machine was renamed.  But, I kept getting the
> > following error.  I can rename and delete the maintenance plan I created.
> >
> > An error has occurred while establishing a connection to the server.  When
> > connecting to SQL server 2005, this failure may be cuased by the fact that
> > under the default settinfs SQL server does not allow remote connections
> > (provider:  Named Pipes providers, error: 40 - could not open a connection to
> > SQL server) (Microsoft SQL server, Error: 53)
> >
> > Shared Memory, TCP and Named Piples are all enabled.
> >
> > Please advise. 
> > --
> > Best Regards,
> >
> > Lynn