Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got a Linked Server in my SQL Express install that is using SQL Server Authentication.

I've created a SQL Server login-mapping and it's using Impersonate.

I've confirmed that the account exists on both servers but I'm still getting the error.

Any suggestions?

share|improve this question

Just make certain I understand, in the linked server security you have specified a local login that is a SQL login that you wish to impersonate as the remote user?

share|improve this answer
Yes, and its credentials match on both servers. – Allain Lalonde Jan 7 '10 at 12:25
Could this be Kerberos related as in the servers (& service accounts) involved needing to be configured for Kerberos delegation? – jl. Jan 7 '10 at 20:34

Where are you attempting to login from ?

An application on a 3rd server, or an SSMS on the same (database) server, or a 3rd server ?

In the first and last case, you are going to run into the dreaded double-hop issue.

It is not Kerberos-related, since you say you're using SQL server authentication, which does not use AD in any way.

share|improve this answer

Did you provide your connection string as "Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.