May 16, 2009 at 12:47 am
I have 3 PC (A,B,C)
in this A is the server for workgroup1 and B is the server for workgroup2, and C is a node in Workgroup2
Here i have Sql server 2000 in A and B and My application is running in C
i have 2 Databases one is in A and another is in B I need to access the tables in A by using linked queries from B. when i try to run my query in my application from Server B it running correctly but when i try to run my application from node C i got the error message is below
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
How to solve this problem?
i'm not using the service pack in my Sql Server,
My Sql Server is set to Mixed mode Authentication.
i'm also linked my server using the following stored procedures
exec sp_addlinkedserver @Remote_Server
exec sp_addlinkedsrvlogin @Remote_Server, 'false', 'sa', @Remote_User, @Remote_Pass
Plz give me a sugession to rectify the problem.
Regards
Srinivasa Moorthi V
May 16, 2009 at 1:42 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply