sql server connection string integrated security

The following table shows the Windows Authentication syntax used with the.

The syntax employed in the connection string varies by provider. We recommend using Windows Authentication (sometimes referred to as integrated security) to connect to data sources that support it. For more information, see Connection String Builders. The connection string builders allow you to construct syntactically valid connection strings at run time, so you do not have to manually concatenate connection string values in your code. For more information on connection string syntax, see ConnectionString.ĪDO.NET 2.0 introduced the following connection string builders for the. Provides data access for Oracle version 8.1.7 or later. For more information on connection string syntax, see ConnectionString. Provides data access for data sources exposed using ODBC. Provides data access for data sources exposed using OLE DB. Provides data access for Microsoft SQL Server. NET Framework.NET Framework data provider The following table lists the four data providers that are included in the. The specific connection string syntax for each provider is documented in its ConnectionString property.

NET Framework data provider has a Connection object that inherits from DbConnection as well as a provider-specific ConnectionString property.

Sql server connection string integrated security