Hi All,
I am not able to enable the JDBC connection for SQL Server hosted in Microsoft AZURE cloud. Getting below error
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Package.connections:testAdapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.sqlserver.jdbc.SQLServerDataSource”.
Cannot open server “XYZ” requested by the login. The login failed.
I have placed the sql jars in proper path as well. And please refer below parameters i used to connect. Please help me here to resolve this issue
Parameters
| Transaction Type |
NO_TRANSACTION |
| DataSource Class |
com.microsoft.sqlserver.jdbc.SQLServerDataSource |
| Server Name |
abc.database.windows.net |
| User |
testuser |
| Password |
****** |
| Database Name |
databseName |
| Port Number |
1433 |
| Network Protocol |
tcp |
| Other Properties |
|
| Connection Management Properties |
|
| Enable Connection Pooling |
true |
| Minimum Pool Size |
1 |
| Maximum Pool Size |
10 |
| Pool Increment Size |
1 |
| Block Timeout (msec) |
1000 |
| Expire Timeout (msec) |
1000 |
| Startup Retry Count |
0 |
| Startup Backoff Timeout (sec) |
10 |
Shafi
#Adapters-and-E-Standards#Integration-Server-and-ESB#webMethods