Skip to content

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
installation and configuration of sql server express 1
Step 2 Select "New SQL installation"
installation and configuration of sql server express 2
Step 3 Configuration of the features
installation and configuration of sql server express 3
Step 4 If the server is not yet running .NET-FW V3.5, it must be installed later (see Figure 11 and Figure 12).
1. If .NET Framework V3.5 is not yet installed, an error is reported
installation and configuration of sql server express 4
2. Installation of .NET-FW V3.5 in Server Manager
installation and configuration of sql server express 5
Step 5 Configuration of the instance
installation and configuration of sql server express 6
Step 6 Configuration of the server
installation and configuration of sql server express 7
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.
installation and configuration of sql server express 8
Step 8 When installation has been completed, you must launch SQL Server Management Studio. The password defined earlier is needed to log in.
Example: Screenshot with SQL Server Authentication and user name "sa", password is the one defined in the previous step
installation and configuration of sql server express 9