TrustedConnection

Description

Specifies whether the current Windows account credentials can be used for authentication.

When to specify TrustedConnection

You must specify the TrustedConnection parameter before connecting to the database.

Applies to

ADO.NET

SNC SQL Native Client for Microsoft SQL Server

MSOLEDBSQL Microsoft OLE DB Driver for SQL Server

Syntax

TrustedConnection=value

Parameter

Description

value

Specifies whether the current Windows account credentials can be used for authentication. Values are:

  • 0

    (Default) The User ID and Password are specified in the connection.

  • 1

    The current Windows account credentials are used for authentication. The User ID and Password supplied in the connection are ignored.


Default value

TrustedConnection=0

Examples

To specify that PowerBuilder should trust the connection:

  • Database profile

    Select the Trusted Connection check box on the General page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="TrustedConnection=1"