Configuring the Initial Settings of SQL Server
This section describes the procedure for configuring the initial settings on the computer where SQL Server is running. These initial settings are only required if the Manager of this software and SQL Server are running on different computers.
If they are running on the same computer, proceed to the next step.
Enabling Connection via TCP
1.
Log on to the computer as a user with administrator privileges for SQL Server.
2.
Start the SQL Server configuration manager.
3.
In [SQL Server Network Configuration], select the protocol for SQLEXPRESS.
4.
Enable connection via TCP.
Double-click [TCP/IP].
On the [Protocol] tab, set [Enabled] to [Yes].
On the [IP Addresses] tab, enter "1433" for [TCP Port] in [IPAll].
Click [OK].
5.
Select [SQL Server Services], and restart the SQL Server service.
Starting SQL Server Browser
1.
Log on to the computer as a user with administrator privileges for SQL Server.
2.
Start the SQL Server configuration manager.
3.
Select [SQL Server Services].
4.
Right-click [SQL Server Browser], and select [Properties].
5.
On the [Service] tab, set [Start Mode] to [Automatic].
6.
Click [OK].
7.
Start the SQL Server Browser service.
Enabling Remote Connection
1.
Log on to the computer as a user with administrator privileges for SQL Server.
2.
Start SQL Server Management Studio and connect to the database engine (SQLEXPRESS).
NOTE |
If you cannot connect to the database engine because a TLS certificate error has occurred, one of the following measures is required. Change the server certificate (key) of the computer where SQL Server is installed to a trusted certificate (key) Install the certificate (public key) of the server to the client computer connected to SQL Server Trust the existing server certificate of the computer where SQL Server is installed |
3.
Right-click the database engine, and select [Properties].
4.
Select [Connections].
5.
In [Remote server connections], select [Allow remote connections to this server].
6.
Click [OK].
7.
Right-click the database engine, and select [Restart].
Configuring the Firewall Reception Settings
When the Manager of this software connects to an instance of SQL Server running on another computer, the port configured in "
Enabling Connection via TCP" is used (port 1433). Therefore, this port (1433) must be registered to the firewall on the computer where SQL Server is installed.
Configure the following settings in [New Inbound Rule Wizard] in [Windows Defender Firewall with Advanced Security].
[Rule Type]: Select [Port].
[Protocol and Ports]: Select [TCP], and enter '1433' in [Specific local ports].
[Action]: Select [Allow the connection].
[Profile]: Select all the check boxes.
[Name]: Configure a name of your choice.
For details, see the instruction manual for your firewall.
Preventing the Computer from Entering the Sleep Mode
When installing this software to a different computer from SQL Server, confirm that the computer where SQL Server is installed is not configured to enter the sleep mode.
1.
Select [Settings] > [SYSTEM] > [Power & sleep] from the Start menu.
2.
Confirm that the computer is not configured to enter the sleep mode.