Error while connecting to database

[Sivateja]

Hi Team,

I am trying to establish the connection between Saviynt and one of the DB application which is on SQL Server.

Upon the test connection I am getting the below error:

Error While Test connection: Login failed for user 'XXXXXX'. ClientConnectionId:837721eb-ae1e-479f-82d3-8bd7654ddfe5

Here are my connection details

URL: jdbc:sqlserver://IP address :Port;database=xxx

Username: Username

Password: Password

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

I have done the telnet to the server/Ip and connection is established.

Can someone help me in building the connection?

Thanks in advance.

[Manu269]

Can you check if you are running different version of Java or db which is not compatible with jdbc driver?

[Sivateja]

We are using Ojdbc8.jar file

[Sivateja]

I have uploaded the mssql 7.2 jar file. Post that I am getting the below error.

[Sivateja]

After restart, I am getting the same error:

Error While Test connection: Login failed for user 'XXXXXX'. ClientConnectionId:837721eb-ae1e-479f-82d3-8bd7654ddfe5

[rushikeshvartak · Accepted solution]

• Password provided on connection is incorrect