"Simon Hayes" <sq*@hayes.ch> wrote in message news:<40**********@news.bluewin.ch>...
"Vincento Harris" <wu*****@yahoo.com> wrote in message
news:2f**************************@posting.google.c om... Sql Server 7 Standard Edition
My Server was renamed and the normal steps of reinstalling
and running sp_dropserver and sp_addserver were followed.
Everything seems to work fine but jobs from the master server.
I did defect the server as a target server since it appeared as offline
anyway.
On trying to re establish the status of the server as a target server
Failed to make "serverName" a target server
Enlist into Master Server "MasterServerName" Failed(Error 14262)
Your insight is appreciated
Vincento
Is @@SERVERNAME returning the correct (new) name? Error 14262 should be "The
specified %s ('%s') does not exist" - what is the full error message you
see? Are there any name resolution issues, ie. can both servers see each
other (ping.exe or NET VIEW) on the network?
Simon
Thanks for your response.
@@servername returns the right value.
I did forget to mention that the master server is sql server 2000 and
target server, sql server 7.
When the master server is pinged from the client it returns packets
with no error.
When originating_server is selected from sysjobs it returns 'local'
I did notice that the target server name has been added as an alias
when you open
the client network utilities.Not sure if that will make any difference
This is the exact error message
Failed to make "serverName" a target server
Enlist into Master Server "MasterServerName" Failed(Error 14262)
Vincento