September 06, 2010     |
Network Toaster
SQL Security Forums
Note: SQLSecurity.com does not allow nor require registration due to privacy concerns for users. SQLSecurity.com is open and anonymous for all. Please report any abuse or profanity.
Subject: Integrated Security with Openrowset
Prev Next

Author Messages
tjb

05/31/2002 1:23 PM Quote Reply Alert 
Is there any way to use replace the string specified login and password in Openrowset() with windows NT authentication?
Chip Andrews

06/01/2002 11:11 AM Quote Reply Alert 
Try 'Trusted_Connection=Yes' instead of your username/password paramters like so: SELECT * FROM OPENROWSET('SQLOLEDB','Trusted_Connection=Yes;Data Source=yourserver','select @@version')

Forums > Discussions > SQL Server Security > Integrated Security with Openrowset

Quick Reply
Username:  
Subject:  
Body:
 



ActiveForums 3.6
Copyright 1999 by Chip Andrews   |  Privacy Statement  |  Terms Of Use