Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login Failed error (Linked server) Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 4:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 5:44 AM
Points: 580, Visits: 564
I am trying to access data through linked server by following query

select * from [Servername].dbname.schema.view_name

and my schema is not dbo.

When I tried this with sa login it is giving me correct output,

but when I tried to access data through login from which linked server is configured it is giving me login failed for user error.

I have already maped database to login with it default schema.

please help me out....
Post #1450488
Posted Wednesday, May 8, 2013 7:19 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
[quote]SQL Addict (5/8/2013)

but when I tried to access data through login from which linked server is configured it is giving me login failed for user error.[quote]

This login has created in linked server or this login has been "impersonated" ?
Post #1450548
Posted Thursday, May 9, 2013 6:32 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 5:44 AM
Points: 580, Visits: 564
This is sql server login .
I have used it for configuring linked server.
Post #1451073
Posted Thursday, May 9, 2013 7:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Can you connect to the linked server using the userid and password.

i hope that is password issue.


Regards
Durai Nagarajan
Post #1451120
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse