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 2012, Follow this guide for post installation tasks.

Information

SQL Server Express 2012 may need the following configuration before Goverlan creates the DB for use with SUREDATA.

  1. Go to Start –> All Programs –> SQL Server 2012
  2. Run SQL Server Configuration Manager.
  3. Go to SQL Server Services.

SQL Browser Service Enable

  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.

SQL Network Configuration

  1. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
  2. Make sure TCP/IP is enabled.
  3. Right-click on TCP/IP and select Properties.
  4. Verify that, under IP2, the IP Address is set to the computer’s IP address on the local subnet.
  5. Scroll down to IPAll.
  6. Make sure that TCP Dynamic Ports is blank.
  7. Make sure that TCP Port is set to 1433.

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

Was this article helpful?

Related Articles