|
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
- Run SQL Server Configuration Manager.
- Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
- Ensure that TCP/IP is enabled.
- Right-click on TCP/IP and select Properties.
- Verify that under IP2, the IP Address is set to the computer's IP address on the local subnet.
- Scroll down to IPAll. Ensure that TCP Dynamic Ports is blank.
- 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 4698
|
|