Author |
Topic |
b11091019
Starting Member
15 Posts |
Posted - 2012-01-26 : 14:29:14
|
I have SQL permissions (windows authentication in this case) on two servers, s1 and s2in SSMS, I can connect to either one and runselect * from foo.dbo.barI'd like to be able to log into s1, e.g. and runselect * from s2.foo.dbo.barinto foo.dbo.barwhere <some condition that I need>however, when do that, I only get default permissions in my reference to s2. In this case, the defaults are NO permissions at all.Is there a way to do this and say, "hey, please use my current credentials for my reference to s2" |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
b11091019
Starting Member
15 Posts |
Posted - 2012-01-26 : 14:52:07
|
quote: Originally posted by tkizer How is the linked server configured? What account it uses is specified in its config.
Where can I see that? |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
b11091019
Starting Member
15 Posts |
Posted - 2012-01-26 : 16:56:04
|
There is nothing in the list. So, since nothing is pre-defined, (how) can I supply credentials at run-time? |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
b11091019
Starting Member
15 Posts |
Posted - 2012-01-26 : 17:07:18
|
I'm not doing that query, but I want to...from s1. I suppose I phrased the question badly. When I try I get:Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'But I don't want to login anonymously, since I can login to s2 directly. I want to issue that query to s2 while logged into s1 and tell s2 to use the same credentials that got me into s1 in the first place. |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
b11091019
Starting Member
15 Posts |
Posted - 2012-01-27 : 09:35:10
|
Hmmm... so how do you "connect with SQL authentication when I want to query a remote server"? Do you have any examples? e.g. a query that accesses databases on more than one server.fwiw I tried using OPENQUERY but got the same error message |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
b11091019
Starting Member
15 Posts |
Posted - 2012-01-27 : 13:23:05
|
OK -- I'll try the first approach. I'm not a dba so I can't do the second. |
 |
|
b11091019
Starting Member
15 Posts |
Posted - 2012-01-27 : 15:21:49
|
OK -- seems I'm out of luck, since we don't use SQL authentication at my shop |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
b11091019
Starting Member
15 Posts |
Posted - 2012-01-27 : 15:59:29
|
That would be nice, but I don't have access to the domain account properties window or I can't find it. I can't find Administrative Tools for my box either. I suppose my access is limited. |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|