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 |
|
sant12345
Starting Member
2 Posts |
 Posted - 2012-01-12 : 06:47:14
|
| I have two SQL servers say 'A' and 'B'.I need to create a linked server in server 'A' which will fetch Data from server 'B' using windows Authentication of server 'B'.Also i should be able to Run that openquery using linked server in server 'A' query analyzer using 'sa' login.I can do this in server 'A' using Windows Authentication but not using 'sa' login.Plz help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-12 : 06:54:21
|
| you need to create a mapped login in server B if you're using a different credential in A------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sant12345
Starting Member
2 Posts |
Posted - 2012-01-12 : 08:35:16
|
How can i do that.i need to map the Local server 'A'(with 'sa' login) to remote server 'B' with windows authentication login.quote:
Originally posted by visakh16
you need to create a mapped login in server B if you're using a different credential in A------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
linked server authentication...