In order for GFI EventsManager to create, update and modify the database which is used to store the GFI EventsManager data, the user being used to connect to the database must have a db_owner role on the database. The rest of the article explains how to create a new SQL user and assign the db_owner role to the user:
- Open 'SQL Server Management Studio'
- Login with a SQL Administrator account.
- Expand the 'Security' folder.
- Right click on the 'Logins' folder and select 'New Login...'
- Enter the Login name for the SQL user. You can also select a Windows user at this stage, and continue with Windows Authentication.
- If you want to use SQL Server Authentication, select 'SQL Server authentication' and enter the password for the new user.
- Remove the option 'Enforce password expiration'
If you have already created the GFI EventsManager Database, perform the following:
- Click on the User Mapping Node
- Tick Map for the GFI EventsManager database
- Tick db_owner for the Database Role Membership
- Click Ok to save changes
If you still haven t created the GFI EventsManager Database and wish to create it with the GFI EventsManager SQL user perform the following:
- Click on the Server Roles Tab and tick the 'dbcreator' server role. Any databases created by the user are automatically assigned the db_owner database role membership
- Click 'Ok' to save changes
The following procedure explains how to change the user being used to connect to the SQL Server by GFI EventsManager.
Open the GFI EventsManager Management Console
Click on the Configuration tab and select Options
Right Click on the Database Backend node and select Change Database Backend
Under the Change Database tab, select the user created previously, and click the Apply button to perform the change or create the database.
Click Ok to save changes.
- EventsManager 2011 and older