Discovering SQL Servers

To allow network/IP scans to be able to discover SQL Server and databases:

1. Open SQL Server Management Studio (SSMS). Connect to your SQL Server instance and establish a login for the Asset Discovery Tool (ADT) user.

2. Navigate to the Security > Logins directory and add the user who will be operating the ADT.

3. Configure the Server Roles for this user. Remember, the Public role is essential, but you have the option to assign other roles based on your needs.

4. 

5. Launch your ADT and create a new discovery profile.

6. In the Advanced Settings of this profile, check the options for Software, Database Management System, and Database. Click Next.

   

7. Provide the Domain user credentials. Make sure that the user has the necessary privileges to perform an in-depth scan of the SQL server you aim to scan. Click Next.

   

8. Specify the IP address range, ensuring to include the IP address of the SQL server you want to discover. Click Next.

   

9. Fill out the rest of the profile information according to your setup.

10. Save the configured settings and initiate the Discovery process.

11. After the discovery process finishes, check that the results include all databases on the SQL server. You can verify this in the ADT User Interface and the Profile\resources_xxx.xml file.

    

Note: Optional - Consider importing the Discovered Configuration Items (CIs) into your ChangeGear server for additional analysis or record-keeping.