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 Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
|||"Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> --
> 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 Crdenas
> 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 Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> rights.
>