Check SQL Services, named pipes, and TCP/IP settings

In order to install the SafeGuard Management Center, it is required that the SQL Browser Service is running and that Named Pipes and TCP/IP are enabled. These settings are required to access the SQL server from other machines. This can be checked in the SQL Server Configuration Manager. The description relates to Microsoft Windows Server 2008 (R2) and Microsoft SQL Server 2012 Standard or Express Edition.

  1. Open SQL Server Configuration Manager.
  2. From the navigation tree on the left, select SQL Server Services.
  3. Make sure that the State of both SQL Server and SQL Server Browser is Running and that Start mode is set to Automatic.
  4. From the navigation tree on the left, select SQL Server Network Configuration and select the current instance.
  5. Right-click the protocol Named Pipes and click Enabled.
  6. Right-click the protocol TCP/IP and click Enabled.
  7. Additionally, right-click the protocol TCP/IP and click Properties. On the IP Addresses tab, under IPAll, leave TCP Dynamic Ports blank. Set TCP Port to 1433.
  8. Restart the SQL Services.