Discussion:
Transfer Logins Task
(too old to reply)
Kelly
2008-12-31 20:04:01 UTC
Permalink
When I execute the Transfer Logins Task I get the following error: "[Transfer
Logins Task] Error: Execution failed with the following error: "Windows NT
user or group '<server>\SQLServer2005SQLAgentUser$<server>$MSSQLSERVER' not
found. Check the name again.". "

Is there a way to tell this task to not attempt to bring over certain
logins? I saw the option to select the logins wanted, but I would like to not
have to get in each time and select all the logins. Or is there a way to trap
the error, examine it and then allow the task to continue? Thanks.
Paul Ibison
2009-01-08 15:20:13 UTC
Permalink
In the "Logins List" you can select the individual logins to transfer.
Alternatively you could roll your own, as it is essentially just a wrapper
for thr sp_help_revlogin procedure: http://support.microsoft.com/kb/918992/
HTH,
Paul Ibison, www.replicationanswers.com
Kelly
2009-01-08 15:41:02 UTC
Permalink
That does help, thanks. I guess I should write my own wrapper and then I can
allow whatever options I want.

Continue reading on narkive:
Loading...