Account credentials required when installing SQL Monitor

When installing and setting up SQL Monitor you need to provide credentials for the following:

creating a SQL Server database to use as the SQL Monitor Data Repository
connecting the Base Monitor service to the Data Repository (if you use a Windows account, this account will also run the Base Monitor service)
connecting to the machine (the physical or virtual server) hosting the SQL Server you want to monitor
connecting to each SQL Server instance you want to monitor

Creating the Data Repository database account

To create the Data Repository, you need an account with Create Database permissions on the specified SQL Server. This account is used ONLY to create the database that SQL Monitor uses as its Data Repository. Once the Data Repository has been created, the credentials you enter here are not used by SQL Monitor.

CreateDatabaseRepository

If you specify a different Windows account, and this account fails, SQL Monitor will then automatically attempt to create the database using your current credentials.
The database is created as soon as you click Create Now. If you cancel the installation, the database will not be automatically deleted.

If you don't have a login for the SQL Server with the correct permissions, use the sp_addsrvrolemember stored procedure to assign a login to the dbcreator role. More information about sp_addsrvrolmember.

If an error message is displayed, see Error messages: creating a Data Repository database.

Connect to Data Repository account

Once you have created the Data Repository database, you need to supply an account that can be used by the SQL Monitor Base Monitor service to access the database. This account must have permissions to access the database you created on the SQL Server.

The database name and SQL Server instance for the Data Repository are indicated in the upper part of the dialog. To change the database used for the Data Repository, click Set up Data Repository.

ConnecttoDRUsing

If you choose Windows authentication, the account you enter will also be used to run the Base Monitor service.
The domain defaults to the domain of your current log-in; if you don't type the domain, the current domain will be assumed.
If this account does not have Log on as Service permissions, SQL Monitor will automatically attempt to grant them to the account.
If you select SQL Server authentication, the Base Monitor service will run as Local Service.

For more information, see Account permissions required by SQL Monitor.

Was this article helpful?

Search support