Release notes - IBM® Tivoli® Identity Manager SQL Server Adapter
5.1.6
IBM Tivoli Identity Manager SQL Server Adapter 5.1.6 is available. Compatibility, installation, and other getting-started issues are addressed.
Contents
Welcome to the IBM Tivoli Identity Manager SQL Server Adapter.
These Release Notes contain information for the following products that was not available when the IBM Tivoli Identity Manager manuals were printed:
The SQL Server Adapter is designed to create and manage accounts on Microsoft SQL Server. The adapter runs in “agentless” mode and communicates using ActiveX Data Objects (ADO) and Microsoft SQL Server APIs to the systems being managed.
IBM recommends the installation of this adapter in “agentless” mode. A single copy of the adapter can handle multiple IBM Tivoli Identity Manager Services. The deployment configuration is based, in part, on the topology of your network domain, but the primary factor is the planned structure of your IBM Tivoli Identity Manager Provisioning Policies and Approval Workflow process. Please refer to the Identity Manager Information Center for a discussion of these topics.
The IBM Tivoli Identity Manager adapters are powerful tools that require Administrator Level authority. Adapters operate much like a human system administrator, creating accounts, permissions and home directories. Operations requested from the IBM Tivoli Identity Manager server will fail if the adapter is not given sufficient authority to perform the requested task. IBM recommends that this adapter run with administrative (root) permissions.
The ability to manage service groups is a new feature introduced in TIM 5.1. By service groups, TIM is referring to any logical entity that can group accounts together on the managed resource.
Managing service groups implies the following:
Create service groups on the managed resource.
Modify attribute of a service group.
Delete a service group.
Note: Service group name change is not supported in the TIM5.1 release.
The SQL Server adapter does not support management of service groups.
Adapter Version
Component |
Version |
Build Date |
2014 August 22 00.54.19 |
Adapter Version |
5.1.6 |
Component Versions |
Adapter Build 5.1.6 Profile 5.1.6 ADK 5.20 |
Documentation |
SQL Server Adapter Installation
and Configuration Guide |
Enhancement ID |
Description |
|
Items included in this release |
51004 (28603) |
SQL2014 support |
|
Items included in 5.1.5 release |
RFE31296 |
SQL Server adapter needs to support MS SQL 2012 |
RFE34303 |
TIM 5.1 Microsoft SQL Server Adapter for SQL 2012 |
INT85301 |
Support for the Microsoft 2012 Server operating system platform (see Known Issues - Installation on the Microsoft Windows 2012 Server platform) |
Removed support for Microsoft SQL Server 2005 |
|
|
Items included in 5.1.4 release |
|
None |
|
Items included in 5.1.3 release |
N/A |
Support for Windows 2008 R2 64 bit and Windows 7 64/32 bit |
MR0326106750 |
PMR 02850,001,666 - Unlock account at password change |
|
Items included in 5.1.2 release |
MR0824095956 |
Need secure connection for SQL adapter to SQL server. Please refer to your SQL Server product documentation to setup secure communication (SSL) between SQL Client and SQL Server. |
MR1202085222 |
Support all admin login options for SQL Server adapter |
|
Items included in 5.1.1 release |
|
Initial release for Tivoli Identity Manager v5.1 |
Issue ID |
PMR# / Description |
|
Items closed in this release |
|
None |
|
Items closed in 5.1.5 release |
|
None |
|
Items closed in 5.1.4 release |
IZ78139 |
02876,001,666 Warning returned by SQL adapter if default DB and DBUser for default database are both defined with the same value. Functionality change! Please see Configuration Notes for more information. |
IZ78158 |
02923,001,666 Transaction failure returned when using PreExec with SQL Adapter if no other attributes are passed in the request. |
IZ80899 |
02940,001,666 MSSQL Adapter 5.0.5 Password change broken |
|
Items closed in 5.1.3 release |
IZ58983 |
(FIX in ADK) CertTool unable to list certificate of Verisign Class 3 Secure Server CA - GA. |
36607 |
(FIX in ADK) ADK incorrect return status for multivalued attribute with special characters. |
|
Items closed in 5.1.2 release |
|
None |
|
Items closed in 5.1.2 release |
|
None. Initial release for Tivoli Identity Manager v5.1. |
CMVC# |
APAR# |
PMR# / Description |
N/A |
N/A |
Class 3 Certificates Class 3 secure server CA-G2 certs are not written properly to “DamlCACerts.pem” file through CertTool.exe Utility. The certificate data is written twice between BEGIN CERTIFICATE and END CERTIFICATE.
Work around: To correct this issue, please follow the below steps and edit “DamlCACerts.pem” file present in “<Adapter installation path>\data” folder.
Step 1. Start the CertTool utility
Step 2. Import the class 3 CA certificate by using “F” option from the main menu of CertTool Utility.
Step 3. Once the class 3 CA certificate is successfully installed, open “DamlCACerts.pem” file stored in the “<Adapter installed path>\data” folder using text editor.
Step 4. Delete the class 3 CA certificate data (i.e. content between BEGIN CERTIFICATE and END CERTIFICATE) from “DamlCACerts.pem”.
Step 5. Open class 3 CA certificate file using text editor and copy the certificate data (between the BEGIN CERTIFICATE and END CERTIFICATE)
Step 6. Paste the certificate data to “DamlCACerts.pem” file between the BEGIN CERTIFICATE and END CERTIFICATE lines of same class 3 CA Certificate. If more than one class 3 certificates are installed then you can identify the certificate using issuer and subject data.
Step 7. Save “DamlCACerts.pem” file.
Step 8. To verify the “DamlCACerts.pem” file is edited properly, display certificate information by using option “E” from the main menu of CertTool Utility.
Please note that this issue is seen after installing class 3 CA certificate. If you correct the DamlCACerts.pem and then install another class 3 CA certificate, the newly installed class 3 CA certificate will show same issue.
This issue is also seen when you delete any certificate using option "G" from the main menu of CertTool utility. The delete option will affect all remaining class 3 CA certificate and you have to follow step 1 to 8 to correct the DamlCACerts.pem file. |
N/A |
N/A |
Installation
on the Microsoft Windows 2012 Server platform |
Known Limitations
Internal# |
APAR# |
PMR# / Description |
|
|
01644,69G,760 / SQL Server adapter fails to change password if password contains single quote Current SQL Adapter does not support single quote character in ‘Password’ attribute value. Unbalanced quote causes the password attribute set operation to fail. |
See the IBM Tivoli Identity Manager SQL Server Adapter Installation and Configuration Guide for detailed instructions.
Corrections to Installation Guide
The following corrections to the Installation Guide apply to this release:
The following configuration notes apply to this release:
None
The IBM Tivoli Identity Manager adapters can be customized and/or extended. The type and method of this customization may vary from adapter to adapter.
Customizing and extending adapters requires a number of additional skills. The developer must be familiar with the following concepts and skills prior to beginning the modifications:
Note: This adapter supports customization only through the use of pre-Exec and post-Exec scripting.
Tivoli Identity Manager Resources:
Check the “Learn” section of the Tivoli Identity Manager Support web site for links to training, publications, and demos.
Support for Customized Adapters
The integration to the IBM Tivoli Identity Manager server – the adapter framework – is supported. However, IBM does not support the customizations, scripts, or other modifications. If you experience a problem with a customized adapter, IBM Support may require the problem to be demonstrated on the GA version of the adapter before a PMR is opened.
The IBM Tivoli Identity Manager Adapter was built and tested on the following product versions.
Adapter Installation Platform:
Microsoft Windows 2008 Server
Microsoft Windows 2008 R2 Server
Microsoft Windows 2012 Server
Managed Resource:
Microsoft SQL Server 2012
Microsoft SQL Server 2014
-- with -- respective Microsoft SQL Server Client software versions 2012 and 2014
Identity Manager V5.1
This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.
IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:
IBM Director of Licensing
IBM Corporation
North Castle Drive
Armonk, NY 10504-1785 U.S.A.
For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:
Intellectual Property Licensing
Legal and Intellectual Property Law
IBM Japan, Ltd.
1623-14, Shimotsuruma, Yamato-shi
Kanagawa 242-8502 Japan
The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law:
INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement might not apply to you.
This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.
Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.
IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.
Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:
IBM Corporation
2Z4A/101
11400 Burnet Road
Austin, TX 78758 U.S.A.
Such information may be available, subject to appropriate terms and conditions, including in some cases payment of a fee.
The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement or any equivalent agreement between us.
Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurement may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.
Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.
All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. All IBM prices shown are IBM's suggested retail prices, are current and are subject to change without notice. Dealer prices may vary.
This information is for planning purposes only. The information herein is subject to change before the products described become available.
This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.
COPYRIGHT LICENSE:
This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written.
These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. You may copy, modify, and distribute these sample programs in any form without payment to IBM for the purposes of developing, using, marketing, or distributing application programs conforming to IBM's application programming interfaces.
Each copy or any portion of these sample programs or any derivative work, must include a copyright notice as follows:
© (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. © Copyright IBM Corp. _enter the year or years_. All rights reserved.
If you are viewing this information in softcopy form, the photographs and color illustrations might not be displayed.
IBM, the IBM logo, and ibm.com® are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Adobe, Acrobat, PostScript and all Adobe-based trademarks are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, other countries, or both.
IT Infrastructure Library is a registered trademark of the Central Computer and Telecommunications Agency which is now part of the Office of Government Commerce.
Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
Linux is a trademark of Linus Torvalds in the United States, other countries, or both.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.
ITIL is a registered trademark, and a registered community trademark of the Office of Government Commerce, and is registered in the U.S. Patent and Trademark Office.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates
Cell Broadband Engine is a trademark of Sony Computer Entertainment, Inc. in the United States, other countries, or both and is used under license therefrom.
Linear Tape-Open, LTO, the LTO Logo, Ultrium, and the Ultrium logo are trademarks of HP, IBM Corp. and Quantum in the U.S. and other countries.
Other company, product, and service names may be trademarks or service marks of others.
End of Release Notes