May 6, 2011 at 3:51 am
Hello,
I get an error (Msg 7416): "Access to the remote server is denied because no login-mapping exists"
when executing a query with login 'reader'.
This query gets data from 2 different db's (dbA,dbB) and in those 2 db's is a user created 'reader'.
The login 'reader' is mapper with users 'reader' (from dbA) and 'reader' (from dbB).
Both db's are in the same instance (on the same server).
I don't know why I get this error, because the login-mappings seems ok...
Can someone help me with this problem?
Thx!
May 6, 2011 at 4:10 am
Think I've found the problem.
It was my query itself... after moving the databases, the query called the old instance-name... 🙁
Pfft lost so much time in security-checks...
May 6, 2011 at 4:54 am
you should use local server to remote server login mapping in linked server properties as shown in the figure
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply