Installation and Configuration of SQL Server Express

<< Click to Display Table of Contents >>

Navigation:  Help > Troubleshooting > Previous Manuals > E-IM-RMS-WEB > Installation >

Installation and Configuration of SQL Server Express

Proceed as follows to configure the SQL database:

Step 1

Extract the EXE file to the desired directory

E-IM-RMS-WEB-V1.3.1_installation 3

 

Step 2

Select new SQL installation

E-IM-RMS-WEB-V1.3.1_installation 4

 

Step 3

Configuration of the features

E-IM-RMS-WEB-V1.3.1_installation 5

 

Step 4

If the server is not yet running .NET-FW V3.5, it must be installed later.

 

E-IM-RMS-WEB-V1.3.1_installation 6

Figure a: If .NET Framework V3.5 is not yet installed, an error is reported

 

E-IM-RMS-WEB-V1.3.1_installation 7

Figure b: Installation of .NET-FW V3.5 in Server Manager

 

Step 5

Configuration of the instance

E-IM-RMS-WEB-V1.3.1_installation 8

 

Step 6

Configuration of the server

E-IM-RMS-WEB-V1.3.1_installation 9

 

Step 7

To finish the installation of SQL, you must still specify the user (system administrator) and a password. This user must be an administrator. This user later has all rights to the database.

 

E-IM-RMS-WEB-V1.3.1_installation 10

 

Step 8

When installation has been completed, you must launch SQL Server Management Studio. The password defined earlier is needed to log in.

E-IM-RMS-WEB-V1.3.1_installation 11

Figure: Screenshot with SQL Server Authentication and user name "sa", password is the one defined in the previous step