CIC error - Login failed for user cicuser

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

Content Import Download is in error in CA\SC\CIC\logs\CIC.log there are these lines :

2023-10-31 09:52:11,640 ERROR c.c.s.CCException [CCMain] Exception caught.  Stack Trace:
2023-10-31 09:52:11,640 ERROR c.c.s.CCException [CCMain] com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'cicuser'. ClientConnectionId:
2023-10-31 09:52:11,640 ERROR c.c.s.CCException [CCMain] com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
2023-10-31 09:52:11,640 ERROR c.c.s.CCException [CCMain] com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)

Environment

Client Automation - All Versions

Resolution

1- Go on SQL Server and open Microsoft SQL Server Management Studio

Go under Security/Logins and open the properties of cicuser login and check under status that it is not disabled and not locked :

 

 

 

 

2- In General set a new password for cicuser :

 

 

and click OK to validate the change.

 

 

3- On Domain Manager open a cmd with administrative privileges and execute these commands :

 

cd /D "C:\Program Files (x86)\CA\SC\CIC\bin"

util -D <Domain Name> "password_set_in_step_2"

 

 

Remarks :

- Adapt the path C:\Program Files (x86)\CA\SC\CIC\bin with correct path for CIC installation

 

- <Domain Name> should be replaced by the name of DOMAIN. Name of DOMAIN could be found in file CIC\conf\config.xml

 

Example :

<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
  <log_properties>
...
    <domain>
      <domainName>DOMAINTEST1</domainName>

 

Example :