linked server

[Bell1991]

I am attempting to use a linked server but i am getting the error "invalid mapping".. Any suggestions how to fix this?

 

[2ni]

the sql user who query your linked server have no rights.

So you msut map this user to an user who have rights on your linked server.

To do it, go in sql server entreprise manager / security
right click on your linked server and choose security.

Here u can do ur mapping.

 

[Bell1991]

Thank you.

I have the linked server running under an account with sysadmin rights.

Here is what i am trying to do. I am not sure it is possible - since i have been working on it on and off for a week and still can't get it to work.

I have an application that uses an approle - up until now, i never had to access a different database - so i am now.. So, i created a linked server and set it up to run under an account with sysadmin rights and selected impersonate under the security tab... I am still getting an error saying i don't have rights to access this new db.. I think the problem is using the approle.. Any suggestions?

Thanks

 

[SQLSister]

Did you try setting up that same approle onthe other server?

Questions about posting. See faq183-874
Click here to help with Hurricane Relief