ISSUE WHILE CONNECTING TO JDBC RECEIVER

[Former Member]

Hi Experts

Iam facing a issue while connecting to receiver JDBC adapter.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: Cannot open database "CAPILLARY_AS" requested by the login. The login failed.. : com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CAPILLARY_AS" requested by the login. The login failed.

we have other scenarios running on SQL server .Please let me know how to solve this

Regards

Nagur

[Dimitri]

check the user used in your communication channel. Does it has enough authorizations on the database? Does the database exist? ....

[Former Member]

Hi Dimitri

we checked with database team they are able to login in to database with the same user.

regards

Nagur

[Dimitri]

can you share the configuration of the communication channel?

[Former Member]

Hi Dimitri

Please find the configuration

Regards

Nagur

[Dimitri]

What is the CRMDB3 about? Just remove that. Also, remove 1433.

And remove the ; after the database name

[Former Member]

Hi Dimitri

CRMDB3 is the instance we removed it and tried still same error.1433 is the port and with the same syntax we are connected to multiple databases all are working fine except for this particular database.

Regards

Nagur

[Former Member]

Hi,

did you try / instead of \ before CRMDB3? Also, did you remove the ; after the connection string? And: The database is Microsoft SQL-Server?

Regards, Moritz