none
Description of integrated security RRS feed

  • Question

  • Hello World!,

      Can anybody help out with this question: What is integrated secuity for when using a string conection for a sql server 2005 database?

    Thanks a lot
    Saturday, March 14, 2009 1:37 AM

Answers

  • Hi Fernando, there're many .Net Framework providers to have connection string property for offering integraded security as option.
    For System.Data.SqlClient.SqlConnection.ConnectionString property, integrated security keyword is part of option to specify in the connection string. The value you can choose for this keyword is true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.  When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
    Please refer the msdn web site for more info: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx.


    Regards,
    Jou
    Saturday, March 14, 2009 10:12 PM
    Answerer
  • If you set integrated security=true, then what this means is the current thread of execution's Windows domain security context will be used for authentication when connecting to SQL Server. 
    Monday, March 16, 2009 5:12 AM
    Moderator

All replies

  • Hi Fernando, there're many .Net Framework providers to have connection string property for offering integraded security as option.
    For System.Data.SqlClient.SqlConnection.ConnectionString property, integrated security keyword is part of option to specify in the connection string. The value you can choose for this keyword is true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.  When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
    Please refer the msdn web site for more info: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx.


    Regards,
    Jou
    Saturday, March 14, 2009 10:12 PM
    Answerer
  • If you set integrated security=true, then what this means is the current thread of execution's Windows domain security context will be used for authentication when connecting to SQL Server. 
    Monday, March 16, 2009 5:12 AM
    Moderator