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

Hello Shafi,

Have you tried specifying testuser@abc.database.windows.net for user name in adapter connection and test?
Please check this https://social.msdn.microsoft.com/Forums/vstudio/en-US/79919cbf-f7c7-4658-8037-13580e0ee2ec/cannot-connect-to-sql-azure-server-data-using-management-studio-or-odbc?forum=ssdsgetstarted for more details