SQL Server Migration Assistant for DB2 - Unable to connect using connection String Option

Amy Johns 0

Trying to connect my Db2 server to the newly installed SSMA (V9.2). I have MS OLEDB installed (v6) and can connect successfully with the client however I can't run a samply query in MS OLEDB. In both tools, I'm getting the following error message:

Connection to DB2 failed.

An internal network library error has occurred. A network level conversational protocol error has occurred.

I have trace turned on but really can't understand in the logs where the problem is. Any suggestions? I need this to convert my Db2 Database (V11.1) to Azure SQL.

Seeya Xi-MSFT 16,436 Reputation points

2023-02-16T01:33:10.29+00:00

Hi ,

Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya

2 answers

Seeya Xi-MSFT 16,436

Hi Amy Johns,

Please check the Prerequisites: Installing SSMA for DB2 client (DB2ToSQL)

Before you install SSMA, make sure that the computer meets the following requirements:

Windows 7 or later versions, or Windows Server 2008 or later versions.
Microsoft Windows Installer 3.1 or later versions.
The Microsoft .NET Framework version 4.7.2 or a later version. You can obtain it from the .NET Framework Developer Center.
Microsoft OLE DB Provider for DB2 version 5 or a later version, and connectivity to the DB2 databases that you want to migrate.
Access to and sufficient permissions on the computer that hosts the target instance of SQL Server or Azure SQL Database where you will be migrating database objects and data. For more information, see Connecting to SQL Server (DB2ToSQL).
4 GB RAM recommended.

From the error message, it seems that there is something wrong with your network. Can your DB2 database connect properly? Are there any error codes? Also, please see this documentation.

https://learn.microsoft.com/zh-cn/host-integration-server/db2oledbv/data-provider-error-codes

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Amy Johns 0 Reputation points

2023-01-30T19:34:25.6733333+00:00

Thank you for the update. All of the necessary pre-reqs have been installed. I can connect to DB2 successfully outside of the SSMA tool. There isn't a specific error code listed so the link to check them other that stating that it is an internal network library level error. I have the trace files as I indicated before however I can't make out what the issue is based on reading them.
Seeya Xi-MSFT 16,436 Reputation points

2023-01-31T05:38:41.7366667+00:00

Hi,

Please check the SSMA log. You can find it at "%APPDATA%\Microsoft SQL Server Migration Assistant\Access\log\ssma.log"
Amy Johns 0 Reputation points

2023-01-31T19:20:06.4+00:00

Got it. My server is set to 'Server_Enrypt'. Attached the log file. NOTE: I 'xxxxxx'd out anything specific to my server.
Seeya Xi-MSFT 16,436 Reputation points

2023-02-01T08:01:43.25+00:00

Hi,

I don't see the file you attached. Maybe you can check the log for the content of the error message and paste the most important part of it here.

Amy Johns 0

[Mandatory: Generic] [29884/3] [2023-01-31 13:35:31]: DB2 connection provider: oledb provider.
[Mandatory: Generic] [29884/3] [2023-01-31 13:35:31]: DB2 connection mode: ConnectionString.
[Debug: Generic] [29884/3] [2023-01-31 13:35:31]: Getting list of OLE DB providers...
[Debug: Generic] [29884/3] [2023-01-31 13:35:32]: Accepting provider DB2OLEDB.1...
[Info: Collector] [29884/3] [2023-01-31 13:35:32]: Using source connection string: provider=DB2OLEDB;user id=XXXXXX;password=XXXXX;initial catalog=XXXXX;network transport library=TCPIP;host ccsid=37;pc code page=1252;network address=XXXXX;network port=XXXXX;default schema=XXXXX;units of work=RUW;dbms platform=DB2/MVS;use early metadata=False;defer prepare=False;datetime as char=False;rowset cache size=0;binary codepage=0;datetime as date=False;autocommit=True;authentication=Server_Encrypt_UsrPwd;certificate common name="DigiCert Global Root CA";decimal as numeric=False;allow null chars=False;loadbalancing=False;persist security info=False;cache authentication=False;connection pooling=False;literal replacement=False
[Debug: Collector] [29884/3] [2023-01-31 13:38:32]: Data collecting time: 00:03:01.2043724
[Error: Generic] [29884/3] [2023-01-31 13:38:32]: Failed to collect metabase data.
[Error: Generic] [29884/3] [2023-01-31 13:38:32]: Exception: Connection to DB2 failed.
No error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).
 site: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection Connect(Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionParameters, System.Security.SecureString)
 source: Microsoft.SSMA.Framework.Db2Mf.Base
   at Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionFactory.Connect(Db2MfConnectionParameters connectionParameters, SecureString password)
   at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.ConnectToDb2Mf(IProjectPreferencesProvider projectPreferences, String xmlConnectionParameters, SecureString password, IDbConnection implicitConnection, IUIProgressBarProvider progressBarProvider)
   at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
   at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
   at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
[Error: Generic] [29884/3] [2023-01-31 13:38:32]: Inner Exception #1: No error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).
 site: Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
 source: System.Data
 error code: -2147217900
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection.Open()
   at Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionFactory.Connect(Db2MfConnectionParameters connectionParameters, SecureString password)
[Info: Gui] [29884/1] [2023-01-31 13:38:33]:  Connection to DB2 failed.
No error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).


[Error: Gui] [29884/3] [2023-01-31 13:50:45]: LowLevelAdapter.ReadSource : Read Source error: Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.EstablishingDb2MfConnectionException: Connection to DB2 failed.
No error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14). ---> System.Data.OleDb.OleDbException: No error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection.Open()
   at Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionFactory.Connect(Db2MfConnectionParameters connectionParameters, SecureString password)
   --- End of inner exception stack trace ---
   at Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionFactory.Connect(Db2MfConnectionParameters connectionParameters, SecureString password)
   at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.ConnectToDb2Mf(IProjectPreferencesProvider projectPreferences, String xmlConnectionParameters, SecureString password, IDbConnection implicitConnection, IUIProgressBarProvider progressBarProvider)
   at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
   at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
   at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
   at Microsoft.SSMA.GUI.Product.Db2MfToMsSql.LowLevel.AppConnectToSourceDb2Mf.ConnectToSourceStart(Object guiContext)
[Error: Gui] [29884/3] [2023-01-31 13:50:45]: Exception: Connection to DB2 failed.
No error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).
 site: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection Connect(Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionParameters, System.Security.SecureString)
 source: Microsoft.SSMA.Framework.Db2Mf.Base
   at Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionFactory.Connect(Db2MfConnectionParameters connectionParameters, SecureString password)
   at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.ConnectToDb2Mf(IProjectPreferencesProvider projectPreferences, String xmlConnectionParameters, SecureString password, IDbConnection implicitConnection, IUIProgressBarProvider progressBarProvider)
   at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
   at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
   at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
   at Microsoft.SSMA.GUI.Product.Db2MfToMsSql.LowLevel.AppConnectToSourceDb2Mf.ConnectToSourceStart(Object guiContext)
[Error: Gui] [29884/3] [2023-01-31 13:50:45]: Inner Exception #1: No error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).
 site: Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
 source: System.Data
 error code: -2147217900
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection.Open()
   at Microsoft.SSMA.Framework.Db2Mf.Base.Db2MfConnection.Db2MfConnectionFactory.Connect(Db2MfConnectionParameters connectionParameters, SecureString password)

Amy Johns 0 Reputation points

2023-02-13T16:31:14.7933333+00:00

Any update on the log contents above?
Amy Johns 0 Reputation points

2023-02-15T15:32:41.4566667+00:00

Yes, that is the connection string that gives me the network library error.

Seeya Xi-MSFT 16,436 Reputation points

2023-02-16T01:32:17.29+00:00

Hi,

Have you checked your connection string?

Like this:

Provider=DB2OLEDB;User ID=useName;Password=password;Initial Catalog=dbName;Network Transport Library=TCPIP;Host CCSID=37;PC Code Page=1252;Network Address=serverName;Network Port=portNbr;Default Schema=schemaName;Units of Work=RUW;DBMS Platform=DB2/MVS;Use Early Metadata=False;Defer Prepare=False;DateTime As Char=False;Rowset Cache Size=0;Binary CodePage=0;Datetime As Date=False;AutoCommit=True;Authentication=Server_Encrypt_UsrPwd;Decimal As Numeric=False;Allow Null Chars=False;LoadBalancing=False;Persist Security Info=False;Cache Authentication=False;Connection Pooling=False;Literal Replacement=False;

https://stackoverflow.com/questions/47659773/can-i-configure-ssma-to-use-db2-server-encrypt-authentication
Please sign in to rate this answer.

0 comments No comments
Sign in to comment