Skip to main content
Version: Next

SQLServer

SQL Server Express is SQLServer Express edition is the entry-level, free database, used for Relational Databases . SQLServer Express Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications.

sqlserver

Prepare​

When referring to this document to use SQL Server Express, please read and ensure the following points:

  • This application is installed by Websoft9 console.

  • Please check the application's usage license agreement to ensure compliance.

  • Configure the domain name or server security group opens external network ports for application access.

Intellectual Property Statement​

The SQLServer covered in this document are all Express editions and may be used or distributed free of charge (detailed terms)

  • Linux Server for: SQL Server Express 2017 2019 2022

Getting started​

Initial setup​

  1. When completed installation of SQLServer at Websoft9 Console, get the applicaiton's Overview and Access information from My Apps

  2. Complete the install wizard step by step

Client Remote Connection​

SQL Server installed under Linux can be used to connect to the database remotely through a client tool as long as the server allows it:

  1. Install the common database management tool CloudBeaver

  2. Login to CloudBeaver and create a new SQL Server connection.

You can also install tools such as Navicat on your local computer to manage the database.

Configuration options​

Administer​

Manual backup​

The generic manual backup procedure is as follows:

  1. SQL Server Enterprise Manager: Right-click the target database and select Tasks > Backup to bring up the Backup Database window.

  2. Follow the backup wizard to complete the backup step by step

Auto Backup​

SQL Server Express does not have a SQL Server Agent service, i.e. you cannot directly use the automatic backup feature that comes with SQL Server.

However, there are still alternative autobackup solutions that are widely used:

  • Use SQL Backup Master, a professional free backup tool (recommended).

  • Write a backup script and run it in a scheduled task on your Windows system.

Troubleshooting​

Can't login with SQLServer password?​

Reference: enable password

SQLServer local connection failed?​

Please check if the server name is correct: in Server Name by Browse More... Select the correct server

Backup failed: ensure correct media...?​

Reason: This is not a failure of the database itself, but a problem with the usage of the backup.
Solution: Remove a backup file, and overwrite it in the existing backup for each backup.