Integrated Security vs. Trusted Connection

[traceytr]

VB.NET 2003, SQL Server 2000
Can someone explain to me in a nutshell what is integrated security and what is a trusted connection? When would I choose one over the other? Thanks.

 

[chrissie1]

this is what they say on

http://www.connectionstrings.com

Trusted Connection

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Trusted Connection alternative syntax

This connection string produce the same result as the previous one. The reason to include it is to point out that some connection string keywords have many equivalents.

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

And I believe them.

Christiaan Baes
Belgium

"My old site" - Me

 

[ThatRickGuy]

They result in the same thing, namely, the credentials of the user account that is making the request are passed to the database. This removes the requirement to create yet another log in screen and username/password for the user to remember.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[traceytr]

Thank you for the information. I'm analyzing/modifying an existing application VB.NET 2003 application, and one of its features is that the data connection type is passed into the application using a command line argument. I just wanted to understand one vs. the other a little better. Again, thanks.


Tracey