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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-01-23 : 14:59:01
|
| Set up linked server for windows user.please explain step by step |
|
|
hey001us
Posting Yak Master
185 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-23 : 15:56:16
|
| i need for SQL server 2005 |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-23 : 16:01:55
|
| Trying to link to other SQL server box in 2000.What should i do for Windows login. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-23 : 22:30:13
|
| You can map it to sql login on linked server. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-23 : 23:57:06
|
| NO rmiao,How can i map it Windows login? user has window login |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 00:43:11
|
| set it to use the logins current security context.also, check the topic on linked servers in BOL. this info is covered there.-ec |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-24 : 10:41:36
|
| I tried with SQL login , still it didn't work. I want to make only one windows user able view the linked server. I couldn't figure it out. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-24 : 22:49:56
|
| What did you do? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-25 : 09:53:30
|
| Depending on what you need to do , there are alternatives , such as OPENROWSET, DTS etcJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
setting up linked server