Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.