Senstar
Safeguarding people, places and property
Contact       Xnet Login       English
Knowledge Base Article
Article Type: How To
Product: Other
Product Version:
Component:
Device Brands:
Created: 11-Jun-2013 3:19:31 PM
Last Updated:

How to configure SQL Server Express to allow remote TCP/IP connections on port 1433

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

Important:

  • It is recommended that you also enable the SQL Server Browser.
  • For firewalls, you need to allow port 1433 (TCP) and 1434 (UDP).

 

Average rating:
Please log in to rate.
Rated by 1, Viewed by 3232