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 |
|
shiyam198
Yak Posting Veteran
94 Posts |
 Posted - 2013-10-02 : 10:06:26
|
| Hi,When I look at a Linked server (I have admin role on the instance) I can see that the linked server (Linked server - properties - security), is set to "Be made using this security context" with a username and password. Another person in my company, when he check the same thing, he sees "not be made". If we look at the "create" script of the linked server, I see the login username and he doesn't. Obviously it is the security setting, but how can I permission him on a linked server?Thanks for your reply. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-10-02 : 10:40:42
|
| Are you sure that you and your co-worker are both connected to (looking at) the same server? Because that doesn't make sense, you should both see the same thing.Be One with the OptimizerTG |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
|
|
|
|
|
Linked Server permissions