SQL Data Catalog

SQL Server Authentication credentials update

In the current version of the tool, the UI does not support changing the authentication mode or updating the userId or password.

To update the userId or password, or change the authentication mode from Windows Authentication to SQL Server Authentication or vice-versa, you need to use the REST API (e.g. with Swagger) or the PowerShell cmdlet.

PowerShell cmdlet

To learn how to start with PowerShell read Automation with PowerShell.

You need to use the Set-ClassificationInstanceCredential cmdlet.

REST API with Swagger

To learn how to start using REST API with Swagger read Exploring the REST API.

You need to find the POST "/api/instances/{instanceId}/update" endpoint in the "Instances" section and press the "Try it out" button:

Then set your userId and password. For Windows Authentication, leave both fields blank.

You also need to provide the "instanceId", that you can obtain using the GET "/api/instances" endpoint or find in the url of the tool when performing classification on that instance.

Then press the "Execute" button.


Didn't find what you were looking for?