1. Support
  2. KBAs
  3. Configuring SQL Server Express for SUREDATA

Configuring SQL Server Express for SUREDATA

If you plan to install a new instance of SQL Server (including EXPRESS), Follow this guide for post installation tasks.

Information

SQL Server may need the following configuration before the Goverlan Reach Console creates the DB.

  1. Go to Start –> All Programs –> SQL Server (Your Edition)
  2. Run SQL Server Configuration Manager.
  3. Go to SQL Server Services.

SQL Server can be configured to use Dynamic TCP ports or a Static TCP port.

Option 1: SQL DYNAMIC PORTS

SQL Server will dynamically assign ports for server communication.

  1. Right click SQL Server Browser > Properties > Service tab > Start Mode. Change this to Automatic. Then click Ok.
  2. Right click SQL Server Browser > Start.

Option 2: SQL Static Port

SQL Server will listen on a defined port for server communication.

  1. Go to SQL Server Network Configuration > Protocols for (Your SQL Instance Name).
  2. Make sure TCP/IP is enabled.
  3. Right-click on TCP/IP and select Properties.
  4. Scroll down to IPAll.
  5. Make sure that TCP Dynamic Ports is blank.
  6. Make sure that TCP Port is set to XXXX where XXXX is the static port you wish to use.

NOTE: In the Goverlan Reach Console or Goverlan Reach Server policy for DB Settings, specify the Server\Instance as follows: SERVERNAME\INSTANCENAME,1433 where 1433 is the static port assigned.

Source: http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012

Was this article helpful?

Related Articles