Adding Microsoft SQL data source

Comments Off on Adding Microsoft SQL data source

Adding Microsoft SQL to vScope unlocks information from Microsoft SQL servers in your IT environment. The data source includes asset types such as Database Systems, Databases, User Accounts, and Jobs.

vScope can inventory a Microsoft SQL database server in two ways:

  1. Using the same credential for every instance on the Microsoft SQL Server.
  2. Using different credentials for different instances on the Microsoft SQL Server.

Regardless of what method you use, adding Microsoft SQL Server as a data source requires:

1. A credential with sufficient permission.

2. The target (IP address or hostname) of the Microsoft SQL Server

Using the same credential on every instance (Recommended)

This is the default and recommended option for inventorying Microsoft SQL Databases. This is often the case when using Windows authentication mode. vScope will try to find the SQL Service Browser on the given port configured under “Advanced Settings” (default: 1434).

How to use

Under Advanced Settings, please review the toggles:

  1. If “Only Scan Instances On This Port” is disabled, vScope can use the credential to automatically inventory more instances discovered.
    This is the default option.

Using different credentials for different instances (advanced)

If you want to inventory multiple instances from one Microsoft SQL server, you should add them as separate credentials with different port configurations. This is relevant if you are using SQL Server Authentication mode.

How to use

  1. Enabled “Only Scan Instances On This Port“. vScope will only scan the instance on the specified “Port” with this credential.

Tip: we recommend you add a description to each credential to highlight which credential relates to what instance.

Using Smart Targets

To help you improve coverage of your Microsoft SQL scanning, vScope offers automatic detection of potential Microsoft SQL data sources on your network. This is called “Smart Targets”.

To assign your Microsoft SQL credential to targets found in other data sources, use the “All Microsoft SQL” option in targets.

To allow the Microsoft SQL credential to produce targets, enable the “Use SQL Server Browser to Find Other Instances”-option.