Microsoft SQL Server Express 2014 Database and User Setup Guide for KeyLAB 2

 

The following guide covers the setup of a KeyLAB database and User Account in Microsoft SQL Server Express 2014. This guide assumes that Microsoft SQL Server Express 2014 has already been installed and configured.

Setting up the KeyLAB database and User

 

1. Firstly, you will need to open Microsoft SQL Management 2014. Navigate to where the program is saved from the Start Menu

 

 

 

2. Log into the SQL Server Management Studio with either the Windows Login credentials or the SQLServer Management Studio credentials. Select Connect.

 

                                    

3. Once logged in, right click on the Databases folder and select the option for "New Database".

This is where the KeyLAB database will be created and stored. Enter the name for the new KeyLAB database. It is recommended that the database is saved as 'KeyLAB' to help avoid any future confusion. 

 

4. Check that you are happy with the locations and then click the OK button. 

5. A new user now needs to be added to the system, and then to the KeyLAB database. This ensures that the KeyLAB program can access the KeyLAB database but no other parts of the SQL Server database structure. Expand the Security folder and right click on the Logins folder and then select New Login.

6. Enter a Login name of KeyLABUser and enter a strong password. Take a note of this password as it will be required later on in the installation process.

                        

7. The new KeyLABUser will now need to be added to the KeyLAB Database. Browse through to Databases - KeyLAB - Security. Right click on Users and select New User.

8. Leave User Type as default "SQL user with login ", and add KeyLAB as the User name and then select the browse button next to Login Name (…).

 

 

 

9. Select the browse button on the next screen, select the KeyLABUser and select OK and then OK on the next screen.

 

10. The user will then need to have the required access given to them. Click on the Membership tab on the left of the screen.

Ensure that all of the following role memberships are checked:

 

• db_accessadmin
• db_backupoperator
• db_datareader
• db_datawriter
• db_ddladmin
• db_owner
• db_securityadmin

 

You can leave all the roles in the Owned Schemas tab above the Membership tab unchecked.

11. Select OK to continue.

The Database and User Account are now setup for use in KeyLAB2.