smartsid Posted February 2, 2003 Posted February 2, 2003 What exactly is a trusted connection? What is it used for? Quote
*Experts* Nerseus Posted February 2, 2003 *Experts* Posted February 2, 2003 A trusted connection is used on databases that support NT Authentication (or similar) as a way of allowing a user access t oa database without explicitly specifying a username/password in the connection string. If you set up the security on SQL Server by telling it you want to allow trusted connections, then it "trusts" that you've been authenticated into windows and thus, into SQL Server. -nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
anand Posted June 27, 2003 Posted June 27, 2003 Can u pls tell me how to write a Connection string for truested connectionn.bcz i am getting the errror login failed for the user sa...not asscociated with truested connection....pls let me know how to write a connection string for truested connection... Thanks Anand Quote Satya
Administrators PlausiblyDamp Posted June 27, 2003 Administrators Posted June 27, 2003 "Data Source = ;Initial Catalog = ;Integrated Security=true" or "Data Source = ;Initial Catalog = ;Integrated Security=SSPI" Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.