Trusted connection

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 youve been authenticated into windows and thus, into SQL Server.

-nerseus
 
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
 
"Data Source = <name of sqlserver>;Initial Catalog = <name of database>;Integrated Security=true"
or
"Data Source = <name of sqlserver>;Initial Catalog = <name of database>;Integrated Security=SSPI"
 
Back
Top