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