December 17, 2004 at 9:20 am
I am having some difficulties adding a target server to a multi server admin setup. Basically, I have had no recent issues setting up servers as target servers, but recently had to resetup a server into a multi server setup because of some technical issues. So, I had to defect the server and then re-enlist it. When I attempted to do this I got the below errors. Can anybody help out? I checked most of the system tables I don't see anything. Also, there is nothing being logged to the SQL Agent, SQL Server or NT event logs.
NOTE: "VODKA" is the master server.
Thanks
...................
From master server:
Enlistment failed (reason: Error 14262: The specified @msx_server_name ('VODKA') does not exist.)
From target server:
- using Enterprise Manager get the following error messages:
In a Message box window with a caption of "Make TSX Wizard" I get the message of: Failed to make '(local)' a Target Server.
When I double clikc on the Task Details I see the following error message: Error 14262: The specified @msx_server_name ('VODKA') does not exist.
- using Query Analyzer to run the following script:
exec msdb..sp_msx_enlist N'VODKA', N'(null)'
...I get the error message:
Server: Msg 14262, Level 16, State 1, Line 5
The specified @msx_server_name ('VODKA') does not exist.
December 17, 2004 at 2:50 pm
I had the same problem. The fact is that master server send NT command "NET VIEW" to target candidate when you add target server. If you have 137 port blocked on you firewall - you have this error. Ask your system administrators to open this port for 5 minutes (when you add target servers). Later you don't need this port, this is just for adding new target servers.
Good luck.
December 21, 2004 at 7:07 am
Interesting, thanks for the reply.
It ended up being that after yet another reboot it automagically fixed itself up! However, I think you may be onto something regarding the NET VIEW since I did notice this call while looking into this issue.
Thanks again!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply