July 15, 2005 at 8:19 am
I can connect to the remote server (Server R) from the local server (Server L) and can run a query in Server R's query analyser. When I try to retrieve data from Server R, by running a query on Server L, I get the error message "Login failed for user sa. Reason: Not associated with a trusted SQL Server connection."
Also, if I try to view Server R's tables through the Linked Server on Server L, I also get the above error.
July 15, 2005 at 9:15 am
Is the remote server running in 'mixed' mode, or using Windows authentication only?
(Right click the server in Enterprise Manager, properties, Security, Authentication.)
Regards
July 19, 2005 at 1:16 am
Yes it is running in SQL Server and Windows Authentication mode.
The Startup service account is marked "This Account".
When I try to type in "sa" and password "", I get error 15405 - "cannot use the reserved user or role name.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply