Microsoft SQL Server Connection Parameters

Server name

Enter the server name.

If there are multiple instances of Microsoft SQL Server, specify server_name\instance_name.

Database Name

Enter the database name.

Application Name

Enter the application name.

Collation Sequence

Enter the collation sequence to be included in the database connection string.

Collation sequences are required only in rare cases where there may be sorting discrepancies between IBM® Cognos® software and a database. We recommend that you contact customer support before using a collation sequence.

MARS Connection

Select the Multiple Active Results Set (MARS) connection. This parameter is used only by Microsoft SQL Server (SQL 2005 Native Client or higher).

Click Yes to allow applications to have more than one pending request per connection and more than one active default result set per connection.

Signon

For more information on signon, see Securing Data Sources.

If no authentication is required, select No authentication.

For more information on IBM Cognos BI, see Authentication Using IBM Cognos Service Credentials.

If you use a Microsoft Active Directory namespace and you want to support single signon, select An external namespace, and select the Active Directory namespace. For more information, see Authentication Using an External Namespace.

If authentication is required, select Signons.

If a user ID and password is required in the connection string, select the User ID check box.

If a password is required, select the Password check box and enter the password in the Password and Confirm password boxes.