Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2010-10-13 : 09:18:50
|
| Hi Guys - Hoping someone can help on this one.I'm trying to setup a linked server between to servers and having problems with setting up the logins to use a domain account.I have a login Domain\MigrationUserNow because this is working with a CRM database it requires this specific login to be use in order to view Filtered Views no the database as these have there own security checking incorporated.I've need to be able to use the Domain\MigrationUser login but by typing this into the remote user details by selecting "be made using this security context" option it just returns an error despite the username and password being correct and having all the require rights on the other serverCan anyone help-----------------------------------------------Learning something new on SQL Server everyday. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-13 : 10:35:02
|
| Can just use "Current Security Context" if Domain\MigrationUser is logging onto server you're linking from.Make sure SPNs are registered on both SQL Servers and Service account is trusted for delegation in AD |
 |
|
|
|
|
|
Linked server via a domain account