Error-14262

I did rename my server and followed the steps.
sp_dropserver sp_addserver etc
But cannot make this server a target server
Error-14262 The specified msx does not exist 'any ideas
great people?.The other servers see the master server Ok
Thanks Michael>
> I did rename my server and followed the steps.
> sp_dropserver sp_addserver etc
> But cannot make this server a target server
> Error-14262 The specified msx does not exist 'any ideas
> great people?.The other servers see the master server Ok
>
> Thanks Michael
--
This could be a permissions problem. Start the SQL Server service on the
target server using a domain administrator account and see how you go.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Eric Cárdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> >
> > I did rename my server and followed the steps.
> > sp_dropserver sp_addserver etc
> >
> > But cannot make this server a target server
> >
> > Error-14262 The specified msx does not exist 'any ideas
> > great people?.The other servers see the master server Ok
> >
> >
> > Thanks Michael
> --
> This could be a permissions problem. Start the SQL Server service on the
> target server using a domain administrator account and see how you go.
> Hope this helps,
> --
> Eric Cárdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||seen this issue before . Its because the originating_server field in the
msdb..sysjobs table stores the computername / instance of the server. So
when you renamed then it is now wrong
I would just update the column to reflect the new computername (After
backing up msdb)
cheers,
Andy Ball
"dimitris" <dantoniades@.mshf.com.au> wrote in message
news:OT9x3zFTEHA.2944@.tk2msftngp13.phx.gbl...
> "Eric Cárdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> > >
> > > I did rename my server and followed the steps.
> > > sp_dropserver sp_addserver etc
> > >
> > > But cannot make this server a target server
> > >
> > > Error-14262 The specified msx does not exist 'any ideas
> > > great people?.The other servers see the master server Ok
> > >
> > >
> > > Thanks Michael
> > --
> > This could be a permissions problem. Start the SQL Server service on the
> > target server using a domain administrator account and see how you go.
> >
> > Hope this helps,
> >
> > --
> > Eric Cárdenas
> > Senior support professional
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
>