This article describes how to configure BiG EVAL after installation, without using the Configuration Wizard. This could be needed depending on your installation scenario.
BiG EVAL was installed on the BiG EVAL server following the instructions in the first and the second chapter.
The configuration wizard has opened, but was not run. You may close the wizard at this point, as you don’t need it anymore.
- Create a new, empty database dedicated to BiG EVAL on your SQL Server or Azure SQL.
- Setup database permissions by adding a user to your database. Give that user db_owner permissions, so it is able to create all kind of objects within that database.
- Ensure that the BiG EVAL server is able to connect to the database through firewalls and other network infrastructure.
- Open BiG EVAL’s configuration file appsettings.json by following these instructions.
- Locate the connection string to the database in the section “Database” -> “Connection”.
- Setup the connection string correctly. Usually you need to set the server-name and the database-name as well as the username and password. You may use connectionstrings.com as a reference to build the right OLEDB connection string.
- You may configure SSL and/or the URL of the BiG EVAL frontend at this point by changing the section “server” -> “urls” in the configuration file. But please follow instructions in this and this.
If you decide to use the default URL http://localhost:1703 , you don’t need to do anything.
- Save the configuration file and close it.
- Restart the BiG EVAL windows service.
As the service is starting, it tries to connect to your database. If that’s possible, it creates all database objects and initial data except of the administrator-user. Creating this user manually is described in the next chapter.
If BiG EVAL is not able to connect to the database, the service doesn’t start within a couple of minutes or an error message appears. Please analyze the log-files to see the respective error messages.
Manually creating the Administrator-User
BiG EVAL creates all database objects and initial data except of the administrator user. So, this chapter describes how to create the admin-user manually.
- This is important! Ensure that your BiG EVAL database is completely new. It should be created using the steps above. But it musn’t already contain any users in the user-table.
- Connect to your database with a SQL editor (e.g. SQL Server Management Studio or similar).
- Run the following SQL statement to create a default admin-user and assign the administrator-role.
INSERT INTO dbo.Users ( [UserId] ,[AccessFailedCount] ,[ConcurrencyStamp] ,[Email] ,[EmailConfirmed] ,[Firstname] ,[Lastname] ,[LockoutEnabled] ,[LockoutEnd] ,[NormalizedEmail] ,[NormalizedUserName] ,[PasswordHash] ,[PhoneNumber] ,[PhoneNumberConfirmed] ,[SecurityStamp] ,[TwoFactorEnabled] ,[UserName] ,[IsEnabled] ,[ImportId] ,[ImportSource] ) VALUES ( 'd5fa7e59-970c-4ade-9bbb-18436785c00f' ,0 ,'8a626352-8d3b-4dc7-a764-4852f1181b37' ,NULL ,0 ,NULL ,'admin' ,1 ,NULL ,NULL ,'ADMIN' ,'AQAAAAEAACcQAAAAEHu1TEWKiA7y1A/qvvZQRoS+9OZDsPKOx1WKLpkmkpAWmH59xanKrsX/IQtFTQSl+w==' ,NULL ,0 ,'7ea31171-3f61-469b-92ad-6151d183cd0f' ,0 ,'admin' ,1 ,NULL ,NULL ) INSERT INTO dbo.UserRoles (UserId, RoleId) VALUES ('d5fa7e59-970c-4ade-9bbb-18436785c00f', 'f0e3e2d4-71c2-4ae0-bb63-d2ba7955efc5')
- Access the BiG EVAL frontend login screen (usually on http://localhost:1703).
- Login to BiG EVAL using the username “admin” and the password “BiG@dqm1” (without the quotation marks).
- Change the initial password immediately.