This article will guide you through the steps you need to perform to allow the user running the Configuration Wizard to configure the existing database and the service account.
Connect an Existing Database
This article covers the following scenario: The database does not exist or User running the Configuration Wizard does not have the correct privileges to connect to it.
Error message which occurs in the Configuration Wizard: The database you have entered does not exist or DOMAIN\username running the Configuration Wizard does not have the correct priviledges to connect to it.
If the database does exist, you need to assign
db_owner role on the database to the user running the Configuration Wizard. To do so, please perform the following steps:
- Connect to the SQL server using Microsoft SQL Server Management Studio.
- Expand Databases folder and then expand the database which you are trying to configure.
- Expand the Security folder and then the Users folder.
- If the user running the Configuration Wizard is not on the list, right-click the Users folder, click New user and add a new user.
- Right-click on the user running the Configuration Wizard and select Properties.
- Select Membership page, give user
db_ownerrole and click OK.
- Return to the Configuration Wizard and continue with the SysKit Monitor configuration.
If you are using the SQL authentication to access the database, make sure to allow this user to login on the specified SQL Server, and depending on your scenario, you need to assign the following permissions:
- Create a new database – To allow the user using SQL authentication to create a new database, make sure the
dbcreatorrole is selected.
- Configure an existing database – To allow the user using SQL authentication to configure the existing database, make sure the
db_ownermembership is assigned.