Azure Sql server connection issue

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 “”.
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


Transaction Type NO_TRANSACTION
DataSource Class
Server Name
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


Hello Shafi,

Have you tried specifying for user name in adapter connection and test?
Please check this for more details