Validating Database Account

To validate the Database Account:

1. Setup a database on a machine and get the user credential to connect that database (for example, we used IP address as 10.00.00.000).

2. Install MSSQL Server and connect using an sa user.

3. Create a database named TestDB.

4. Add a System in PAS and then add the sa user to it.

   

5. Add checkout permission to the sa user.

   • Go to the System > Choose a System > Select Account.
   • Add a user to be used for checkout.
   • Edit and provide Checkout permission.

6. Go to the ServiceNow instance.

7. Go to the Discovery > Credentials > New.

8. Select JDBC Credential.

9. Enter the details and select External Credential Store.

10. Provide Username in Credential ID.

11. Checkout permission is given to the user which attempts to validate the database on a machine in the steps above (for example, sa).

    

12. Select Test Credential.

13. Provide the IP address of the system where the database is located.

14. Enter the database name in the Name field and select OK.

15. A background validation starts and the credential is validated.