Attempting to run a DB Stored Procedure job on DBaaS SQL server in Azure. Server uses Windows authentication to login and below is the JDBC URL which I used and I got the below error. DB URL : jdbc:jtds:sqlserver://azsqldb01.database.windows.net:1433;DatabaseName=db_DEV;domain=CAZDB;USENTLMV2=true
We receive the following error and job does not run:
LStatus : Windows logins are not supported in this version of SQL Server. Could you help with the right DB URL.
Try defining a local DB ID and rerun your job using that ID.