DevTest 10.7.2 IAM Database -SQLServerException: Login failed for user
search cancel

DevTest 10.7.2 IAM Database -SQLServerException: Login failed for user

book

Article ID: 259365

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

Upgraded to DEVTEST 10.7.2,  iam.properties  was updated with the Database properties.  Upon starting the Database, we see the below error: 

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SVDEVTEST-01'. ClientConnectionId:58c7503f-fcf3-4fcf-a978-068a70ef802f
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:283)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:129)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:5173)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3810)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:94)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3754)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServ

Environment

Release : 10.7

Cause

 DevTest does not like the following special characters in DB passwords: /, \, %

Resolution

Please recreate the Database Password  without /, \, %   as special characters 

Update the iam.properties once changes are made.  And restart IAM.