About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
When I try to create a new Microsoft SQL Server stored IBM i2 iBase database or upsize an existing one, a warning appears stating that i2 iBase was 'Unable to test the SQL Server connection, because SQLDMO is not installed on this machine' and asks if I want to proceed. How do I get i2 iBase to test the SQL Server connection first?
Cause
From Microsoft SQL Server 2008 onwards, SQL-DMO is no longer an included feature by default. As i2 iBase was desgined to make use of this to test the connection to the database, it must be installed again to resolve the issue.
Answer
Installing the Microsoft SQL Server 2005 Backwards Compatibility Components (specifically SQL-DMO) on the machine displaying the message will resolve this issue.
This is available from Microsoft's website here https://www.microsoft.com/en-us/download/details.aspx?id=6375
- Expand the Installation Instructions section, then select the appropriate version for your installations architecture to download the components.
2. Follow through with the installation wizard, and select the following feature to install when prompted.
3. Install the feature, then attempt to upsize the i2 iBase database again. The error message should not be displayed.
[{"Product":{"code":"SSXW43","label":"i2 iBase"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.9.5;8.9.1;8.9;8.9.11","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
More support for:
i2 iBase
Software version:
8.9.5, 8.9.1, 8.9, 8.9.11
Operating system(s):
Windows
Document number:
281893
Modified date:
16 June 2018
UID
swg21985106