Installation and Configuration of SQL Server Express

<< Click to Display Table of Contents >>

Navigation:  Help > Troubleshooting > Previous Manuals > 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

 

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