OLE DB Provider for DB2 1.0 has been updated to support the KERBEROS and KRB_SERVER_ENCRYPT authentication types (909612)

MORE INFORMATION

OLE DB Provider for DB2 1.0 has been updated to support the KERBEROS and KRB_SERVER_ENCRYPT authentication types. After you apply this update, OLE DB Provider for DB2 1.0 can use the Kerberos security method when it connects to IBM DB2 databases that are configured for KERBEROS or KRB_SERVER_ENCRYPT authentication.

To configure OLE DB Provider for DB2 1.0 to use Kerberos authentication, follow these steps:

1. Click Start, click All Programs, click Microsoft OLE DB Provider for DB2, and then click Data Access Tool.
2. Create a new data source, or modify an existing data source.
3. Click Next until you reach the Security dialog box.
4. Click Kerberos in the Security method menu.
5. Enter a valid principle name in the Principle name box.

Connection String

The following properties must be added to the connection string for OLE DB Provider for DB2 1.0 to enable Kerberos authentication:

• Integrated Security=SSPI
• Principle Name=principle name

The following is an example of a connection that is configured for Kerberos authentication.

Provider=DB2OLEDB;Initial Catalog=IBMDB2;Network Transport Library=TCP;Host CCSID=1252;PC Code Page=1252;Network Address=IBMDB2DB;Network Port=446;Package Collection=NULLID;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/6000;Defer Prepare=False;Principle Name=sqluser/test.domain.com@domain.com;Integrated Security=SSPI;Persist Security Info=False;Data Source=IBMDB2;Connection Pooling=True;Derive Parameters=False;

Update information

A supported feature that modifies the product's default behavior is now available from Microsoft, but it is only intended to modify the behavior that this article describes. Apply it only to systems that specifically require it. This feature may receive additional testing. Therefore, if the system is not severely affected by the lack of this feature, we recommend that you wait for the next OLE DB Provider for DB2 1.0 service pack that contains this feature.

To obtain this feature immediately, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.x86-based version

File name	File version	File size	Date	Time	Platform
Db2oledb.dll	7.0.2485.0	507,392	25-Feb-2006	01:38	x86
Microsoft.hostintegration.dataaccesslibrary.dll	7.0.2485.0	2,554,640	27-Feb-2006	23:33	x86
Microsoft.hostintegration.dataaccesstool.exe	7.0.2485.0	617,224	27-Feb-2006	23:33	x86
Mseidrda.dll	7.0.2485.0	765,440	25-Feb-2006	01:39	x86

x64-based version

File name	File version	File size	Date	Time	Platform	Service branch
Db2oledb.dll	7.0.2485.0	747,008	25-Feb-2006	02:29	x64	Not Applicable
Microsoft.hostintegration.dataaccesslibrary.dll	7.0.2485.0	2,550,544	27-Feb-2006	23:04	x64	Not Applicable
Microsoft.hostintegration.dataaccesstool.exe	7.0.2485.0	613,128	27-Feb-2006	23:04	x64	Not Applicable
Mseidrda.dll	7.0.2485.0	1,332,736	25-Feb-2006	02:29	x64	Not Applicable
Db2oledb.dll	7.0.2485.0	507,392	25-Feb-2006	01:38	x86	SYSWOW
Mseidrda.dll	7.0.2485.0	765,440	25-Feb-2006	01:39	x86	SYSWOW

Note Because of file dependencies, the most recent hotfix may also contain additional files.