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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-14 : 10:47:32
|
| Jonathan writes "Can an OPENDATASOURCE or OPENROWSET query can be called via NT authentication, rather than with a SQL Login? If so, what would be the correct syntax to use?" |
|
|
naclerio75
Starting Member
1 Post |
Posted - 2007-11-27 : 04:38:59
|
| The solution is OPENDATASOURCE('SQLOLEDB','Data Source=localhost;Integrated Security=SSPI') |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-27 : 04:58:58
|
wow!he got an answer after 5+ years! now that's what i call a thirst to answer. well done!  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-27 : 07:59:37
|
quote:
Originally posted by AskSQLTeam
Jonathan writes "Can an OPENDATASOURCE or OPENROWSET query can be called via NT authentication, rather than with a SQL Login? If so, what would be the correct syntax to use?"
Do you want to access them from front end or back end?Example for the latter which works in both the modeshttp://sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-27 : 08:20:25
|
quote:
Originally posted by spirit1
wow!he got an answer after 5+ years! now that's what i call a thirst to answer. well done! _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
I was wondering why it appeared on the first page?!? |
|
|
|
|
|
|
OPENDATASOURCE / OPENROWSET using a trusted connection