Install, set up, and test SQL Server 2017

On the Windows application server, download SQL Server installation media.

1. Download SQL Server Express Edition

2. Run the installer, SQLServer2017-SSEI-Expr.exe

3. Click Download Media

4. In Language, select English

5. In Package to download, select Express Core

6. Click Download

When the download is successful, close the installer.

1. Move the downloaded file to C:\Zylinc install\SQLEXPR_x64_ENU.exe

2. Run the installer, SQLEXPR_x64_ENU.exe

3. Click Ok to extract the installation files

4. Click New SQL Server stand-alone installation or add features to an existing installation.

5. Accept license terms, and click Next.

6. Select Use Microsoft Update to check for updated, and click Next,

7. In Feature Selection, keep the default feature selections, and click Next

8. In Instance Configuration, select Default instance, and click Next

9. In Server Configuration, go to the Collation tab. Collation should generally not be changed. Keep the default value that has been inherited from the Windows regional settings.

   For Danish environments, use Danish_Norwegian_CI_AS.

10. In Database Engine Configuration, select Mixed Mode (SQL Server authentication and Windows authentication).

11. Enter the password for MS SQL SA user (built-in administrator)

12. If corporate IT policy allows it, add the local group administrators to Specify SQL Server administrators.

    If you don't carry out this step, only the current user (who made the installation) can manage the SQL server in the future.

13. Depending on corporate IT policy, you can change Data Directories to a data disk, or you can keep them on the C: drive.

    There is no need to change anything on the other tabs: TempDB, User Instances, and FILESTREAM.

14. Click Next and wait for the installation to complete

15. Click Close

In SQL Server Configuration Manager:

1. In SQL Server Network Configuration, click Protocols for MSSQLSERVER

2. Double-click TCP/IP

3. On the Protocol tab, change Enabled to Yes

4. Click OK

5. In SQL Server Services, restart SQL Server (MSSQLSERVER)

In Microsoft SQL Server Management Studio:

1. In Server name, enter the hostname of the server that hosts SQL server. For example: WinAppServer

2. In Authentication, select SQL Server Authentication

3. In login, enter SA

4. Enter the password for MS SQL SA user (built-in administrator)

5. You should be able to connect to the SQL server without errors.

6. Install Microsoft SQL Server Management Studio on a client computer, and repeat this test.

You're going to access SQL Server Manager Studio again later, so make a note of steps 1-5.

Check that database recovery model, database maintenance and backup configuration is properly taken care of.

If no transaction log backup job is configured for regular execution, the database LDF files will expand until the disk is full. In this case, check that the database recovery model is simple for ZyDB and ZyStatDB.

For SQLServer Express, simple is default. However, for SQL Server Standard or Enterprise editions, the default is full, and that means that the log disk is likely to run out of space at some point.