Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
User login failed while accessing data from another server.

Answered User login failed while accessing data from another server.

  • Wednesday, February 13, 2013 2:40 AM
     
     
    Sign In to Vote
    0

    Hi Folks,

    I have a requirement to join a table from one server to an external server. I have access to both the servers individually. But am unable to query to access data from external server by its instance, Its giving an error as "login failed for user SEP\BIadmin"

    But I have access to both the servers "SEP\BIadminNew"

     I am trying to query something like this.

    ------------------------------------------------------------------------------------

    INSERT INTO [Reporting_DW].DBO.FACTCOPA 
    select Empno,EmpName from [ExtServer].ABC.DBO.CE15001

    Result:

    login failed for user SEP\BIadmin

    ------------------------------------------------------------------------------------

    Can you please tell me why its giving login failed with someother user "BIadmin" where my username is "BIadminNew".

    Please help me with a solution.

    Thanks in advance,

    Kranthi kumar.

     

All Replies

  • Wednesday, February 13, 2013 3:06 AM
     
     Answered
    Sign In to Vote
    1
    when you are querying the data from other server, it depends on the linked server connection set up between the servers. check "security" tab on your linked server(you can find it under Server Objects node, in object explorer) on how it is impersonating you.

    Hope it Helps!!


     
  • Wednesday, February 13, 2013 3:56 AM
     
     
    Sign In to Vote
    0

    Hi Stan,

    Thanks, it helped.

    Regards!!