Adding shared credentials for SQL Databases fails when you test the credential in Control Compliance Suite Vulnerability Manger - CCS VM.


Article ID: 157290


Updated On:


Control Compliance Suite Vulnerability Manager


When setting up a shared credential for Microsoft SQL Databases in CCSVM, the test credentials fails.

'Authetication failed due to in valid credentials'


Microsoft SQL server service runs on a randomly generated port in 2005 and above. As a consequence CCSVM does not know which port the service is running on. CCSVM works this out during asset discovery part of a scan. This is not avaliable during the adding of credentials.


When using the test credentials function, make sure you know what port the MSSQL service is running on, on the system you wish to test the credentials against, and add it into the field.