Installation guide

MEDIAEDGE
70
IV-2. Database Checks
If you cannot connect to the database, check the following items.
DCM server settings
[IV-2-1 TCP/IP settings for SQL Server]
[IV-13. Windows Firewall Settings]
DCM console settings
[IV-2-2 Settings for database connection]
IV-2-1. TCP/IP settings for SQL Server
This section describes how to perform the settings for SQL Server that is installed on the DCM server.
[1] From the [Start] menu, select [All Programs]->[Microsoft SQL Server]->[Configuration Tools], and
click [SQL Server Configuration Manager].
=> [SQL Server Configuration Manager] opens.
[2] From the tree, open [SQL Server Network Configuration] and click [Protocols for DB instance
name](*1).
*1: DB instance name is the instance name of the database. If the instance name was set as
blank during installation, SSQLSERVER is displayed as the default instance name.
[3] Right-click [TCP/IP] and click [Enable].
[4] Right-click [TCP/IP] and click [Properties].
=>[TCP/IP Properties] opens.
[5] Click [IP Address] tab and check whether the value of [TCP Port] for [IP All] is set to 1433.
* If the Windows firewall is not disabled, add a rule to permit the TCP port number for the
Windows firewall.
* If multiple instances exist, changing the TCP port number of a particular instance might
affect other instances.
[6] Close [SQL Server Configuration Manager].
[7] From the [Start] menu, open [Control Panel]. Next, double-click [Administrative Tools], and then
double-click [Services].
=> [Services] opens.
[8] Click [SQL Server (DB instance name)], and then click [Restart the service].
=> [SQL Server (DB instance name)] restarts and the setting changes are updated.