Skyline Installation

Installing the Database

Installing the Database

Previous topic Next topic  

Installing the Database

Previous topic Next topic JavaScript is required for the print function  

Skyline needs a copy of SQL Server Express or a full version of Microsoft SQL Server database management system to be installed on the web server.

SQL Server Express is a free edition of SQL Server, which includes the core database engine. There is maximum database size of 10 GB in SQL Server 2016, SQL Server 2014 or SQL Server 2012.

To download the software:

1.Open https://www.microsoft.com/en-us/sql-server/sql-server-downloads.
2.Download the Express Edition.
SQL Server 2017 Express is a free edition of SQL Server ideal for development and production for desktop, web, and small server applications.

 

To Install the software:

1.In the Downloads folder, double click the installation file that was downloaded, for example SQLServerInstal-Download
2.When asked to select an installation type select Custom.
3.The next window asks you to specify the media download target area, accept the default location. Click Install to continue.
SQLServerInstal-DownloadTargetLocation
4.The installation software is downloaded into the default location. This may take a few minutes depending on the speed of your network connection.
5.When the Installation window opens select the option "New SQL Server stand-alone installation or add features to an existing installation".
SQLServerInstall-01
6.The license Terms window opens. Tick the box "I accept the license terms" and then click Next.
7.The Global rules are checked then the Microsoft Update window opens, It is recommended that you select the option "Use Microsoft Update to check for updates". Click Next to continue.
8.The Install Setup files are run then the Install Rules window opens. If there are any rules that have failed you will need to rectify the problem. If the rules have passed or there is just a warning about the windows firewall, click Next to continue.
9.The Feature Selection window opens.
SQLServerInstall-02
1.Click the button Unselect All.
2.Select the Instance Feature Database Engine Services.
3.Click Next to continue.
10.The Feature Rules are checked then the Instance Configuration window opens. Change the named instance from SQLExpress to Skyline. The Instance ID will be updated automatically. Click Next to continue.
SQLServerInstall-04
11.The Server configuration window opens. Accept the defaults and click Next to continue.
12.The Database Engine Configuration window opens. The authentication mode Mixed needs to be selected.
SQLServerInstall-06
1.Select the Mixed Mode (SQL Server authentication and Windows authentication).
2.Enter the password for the SQL Server system administrator account. The default Skyline password is SkylineH0$t.
3.Click Next to continue.
13.The feature configuration rules are checked and then the installation begins. The process can take a few minutes but when finished the Complete window opens. Click Close to finish the installation process.
SQLServerInstall-05

You now need to install the SQL Server Management Tools.

1.At the Installation window select the option "Install SQL Server Management Tools"
SQLManagementTools-01
2.Your internet explorer browser will open https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms. Select to option to download SQL Server Management Studio 17.
3.In the Downloads folder, double click the installation file that was downloaded, for example SSMS-Setup-ENU.
4.The Welcome window opens. Click Install to begin.
5.The process of the installation is displayed. Depending on the speed of your server, this could take some time.
SQLManagementTools-02
6.When the installation has been completed close any open windows. You are now ready to add databases to SQL.