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

book

Article ID: 157290

calendar_today

Updated On:

Products

Control Compliance Suite Vulnerability Manager

Issue/Introduction

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

'Authetication failed due to in valid credentials'

Cause

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.

Resolution

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.