Posted by Erland Sommarskog on 06/29/05 00:04

(cerilocke@ev1.net) writes:
> I tried using SQL authentication, and received the identical error,
> "Login failed for user '???'. Reason: Not associated with a trusted SQL
> Server connection."

So the target server, does either
1) permit SQL authentication
2) does not trust the source SQL Server.

You never said whether you have a domain, or just a workgroup. Trusts
in workgroups is a tricky business.

If the target server permits SQL authentication, you could use
sp_addlinksrvlogin, to configure a login to use when logging into the
linked server.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]