August 30, 2011 at 10:06 am
Trying to copy databases from server A to server B using the SMO method to leave the databases online.
Error:
-Failed to connect to server A. Login failed for user 'mydomain\Server-B$' ??
Server A logins:
1. ServerA\SQLServer2005SQLAgentUser$ServerA$MSSQLSERVER
2. Builtin\Admins
Server A Cedentials:
1. CDWcredentialsServerA - Identity is mapped to mydomain\myuseraccount my password
Server A Proxies:
1.CDWproxyServerA - credential = CDWcredentialsServerA, Subsystem = SSIS, Principles = Builtin\Admins, ServerA\SQLServer2005SQLAgentUser$...
Server B logins:
1. ServerB\SQLServer2005SQLAgentUser$ServerB$MSSQLSERVER
2. Builtin\Admins
Server B Cedentials:
1. CDWcredentialsServerB - Identity is mapped to mydomain\myuseraccount my password
Server B Proxies:
1.CDWproxyServerB - credential = CDWcredentialsServerB, Subsystem = SSIS, Principles = Builtin\Admins, ServerB\SQLServer2005SQLAgentUser$...
Server A and Server B Local Groups:
Administrators (Group) >> has members = mydomain\serveradmins (my domain account is a member of serveradmins)
Why is the error trying to use mydomain\the SQL Server Agent account 'ServerB$'?
Also, I noticed that neither serverA or serverB proxy account principles are listed after I add them. They disappear after I hit ok. Could this be why the copy is failing?
August 30, 2011 at 10:43 am
Vertigo44 (8/30/2011)
Trying to copy databases from server A to server B using the SMO method to leave the databases online.Why is the error trying to use mydomain\the SQL Server Agent account 'ServerB$'?
Also, I noticed that neither serverA or serverB proxy account principles are listed after I add them. They disappear after I hit ok. Could this be why the copy is failing?
Copy Database wizard uses SQL Server Agent account.
SQL Agent is failing to connect to Server B. Does server B have the same SQL Agent account as in Server A?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply