Prev: Error when trying to schedule job in SQL 2008
Next: User id executed stored procedure
From: jdias on 20 May 2010 11:57
Hello,

adding a target server into a master I do the following steps:
1) On Target server:
Right click on agent -> Multi Server Administration -> Make this a Target...
2) Next
3) Pick Server
4) Type in the master server and put in [B]SQL Server Authentication[/B] (sa,
which even has same password on both servers)
5) Next
6) And here I get the error:
[B][I]Login failed for user "DOMAIN\MyDomainAccount"[/I]![/B]

The login from the remote (Target) server to the master server and with sa
works through sqlcmd or even on Mgmnt Studio by e.g. registering the master
server.
And vis-versa it works to login with "sa" and SQL Server Authentication
through the master into the target for enlisting the target then.

The error seems to lye really in the Studio Management application and
definitely this wizard steps.

Can you try it out and give feedback please if same error or just working.

Thx!

 | 
Pages: 1
Prev: Error when trying to schedule job in SQL 2008
Next: User id executed stored procedure