Create or modify SQL credential object

To enable mapping between the SQL Server and the Operating System, create or modify the SQL credential object.

  • Create a new credential when defining DMSA for the first time (workflow 1 and 2).

  • Modify the credential when existing systems with DMSA are changing the user name and password of the database and Management Service Account(s) (workflow 3).

  • In remote SQL configurations, the SQL credential object requires permission in the registry to run scripts. See Configure remote SQL Server.

Procedure

  1. From the SQL Server Management Studio, connect to the relevant SQL Server instance and select Security > Credentials.

  2. Right-click Credentials, select New Credential and create the new credential or modify an existing credential. Enter the details as follows:

Property

Description

Credential name

I360DBCredential

Identity

<DOMAIN\USER>

If you selected not to use the DMSA option, then enter the Management Service Account details when prompted for Domain and User to create the credential for the Management Service account.

Password

<PASSWORD>

Confirm password

<PASSWORD>

The credential is created or modified for the Database Management Account.

You can also use the TSQL Command to create the required credential:

CREATE CREDENTIAL [I360DBCredential] WITH IDENTITY = N'<DOMAIN\USER>', SECRET = N'<PASSWORD>'