-
37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated wit
I have sql6.5 push replication to many remote subscribers.
Need add one subscriber sql6.5 "XYZ"(all are in the same domain), got error of <<37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection>>.
I apply the same settings for "XYZ" sql executive like other subscribers with domainuserABC and assign it as the target server "XYZ" admin group. There is no problem in stop and restart the "XYZ" sql executive service. But at the time from the publisher to subscribe the XYZ, the task list show above error.
MSSQLServer service logon with System Account option.
This is a production issue, and I have spent around 2 days already.
Thanks for help
David
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|