webMethods Knowlegebase : Reference to database and/or server name in 'master.dbo.sysdatabases' is not supported (1786398)

Problem

Moved some of our databases to Azure.

Able to connect to these databases when we set up the JDBC Adapter connections. when we specify the table in SELECT, gets below error:

"2017-06-22 17:10:46 CDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.

[ADA.1.318] Cannot get the list of catalogs. "

(S0001/40515) Reference to database and/or server name in 'master.dbo.sysdatabases' is not supported in this version of SQL Server."

Reference to database and/or server name in 'master.dbo.sysdatabases' is not supported in this version of SQL Server.

2017-06-22 17:10:51 CDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.322] Cannot get the list of tables. "

(S0004/1038) An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name."

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

2017-06-22 17:10:51 CDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.

[ADA.1.322] Cannot get the list of tables. "

(S0004/1038) An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name."

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name."