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
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply