May 8, 2013 at 4:39 am
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....
May 8, 2013 at 7:19 am
SQL Addict (5/8/2013)
This login has created in linked server or this login has been "impersonated" ?
May 9, 2013 at 6:32 am
This is sql server login .
I have used it for configuring linked server.
May 9, 2013 at 7:56 am
Can you connect to the linked server using the userid and password.
i hope that is password issue.
Regards
Durai Nagarajan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply