Access Database from Non trusted Domains!!

hello

i have 2 domains non trusted , want users domain a  access db from domain b via sql server instance or vice versa. please note there no trust between domain , domain b.

i using windows server 2008 r2  , sql server 2012

in sql server configuration manager protocols mssqlserver ,  tcp/ip  , share memory enabled , named pipes disabled.

i tried on my  lab by doing following steps , works fine

1. create same username on both domains , on sql instances

2. register spn username

3. set delegation  " trust user delegation services(kerberos only)

4 login user name a  on server dc - domain a

5. connect sql instance of domain via sql server management studio

6.create link server of domain b

7. while creating link server i  choose  in security section " made using login's current security context"

8.validate connection , connection successful

i wonder way connect non trusted domain? or are there other method connect without trust ?

appreciate guidance :)

hello

i have 2 domains non trusted , want users domain a  access db of domain b via sql server instance or vice versa. please note there no trust between domain , domain b.

i using windows server 2008 r2  , sql server 2012

in sql server configuration manager protocols mssqlserver ,  tcp/ip  , share memory enabled , named pipes disabled.

i tried on my  lab by doing following steps , works fine

1. create same username on both domains , on sql instances

2. register spn username

3. set delegation  " trust user delegation services(kerberos only)

4 login user name a  on server dc - domain a

5. connect sql instance of domain via sql server management studio

6.create link server of domain b

7. while creating link server i  choose  in security section " made using login's current security context"

8.validate connection , connection successful

i wonder way connect non trusted domain via sql? or are there other methods connect without trust ?

appreciate guidance :)

Windows Server  >  Directory Services