What does Trusted = yes/no mean in Sql connection string?

Question

What does Trusted = yes/no mean in Sql connection string?

I am creating a connection string as below :

            string con= string.Format(
                "user id=admin;password=admin;server={0};Trusted_Connection=yes;database=dbtest;connection timeout=600",
                _sqlServer);

Please Help

Answer 1

Integrated Security -or- Trusted_Connection

When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.

Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.

Answer 2

Check out connectionstring,com for detailed description of all the various SQL Server connecion string properties. Specifically, this article: