Originally published on 07-21-2011 11:53 AM.
Windows authentication may be used when connecting to a Microsoft SQL Server database. When configuring the Database Connection artifact, simply select the Use windows authentication check box instead of supplying user name and password credentials.
Alternatively, you may use a Database Connection that relies on an ODBC Data Source Name configured to use the Kerberos authentication method.
To create the ODBC DSN, use the Start > All Programs > expressor > expressor3 > system tools > Data Sources (ODBC) menu item. This will insure that the correct ODBC Administrator for your operating system is launched. When specifying the driver, choose the expressor-3-mssql entry. In the ODBC SQL Server Native Wire Protocol Driver Setup window, complete the entries on the General tab then open the Security tab. In the Authentication grouping, choose 4 - Kerberos as the Authentication Method and click Apply and OK.
Then working in Expressor Studio, create a Database Connection.
- In the first wizard window, select the Create a connection for an existing DSN radio button, then click Next.
- In the second wizard window, highlight the entry corresponding to your ODBC DSN and click Next. There is no need to enter Credentials as the ODBC DSN will employe Windows authentication.
- In the last wizard window, confirm the storage location for the connection artifact and enter a meaningful name.
- Click Finish to create the connection artifact
To test your Database Connection, open the connection by either double-clicking on the connection's entry in the Explorer panel or selecting the entry, right-clicking, and selecting Open from the popup menu. In the DSN Connection > Edit tab of the ribbon bar, click the Test Connection button. There is no need to enter Credentials as Windows authentication is being employed.