How to Enable Remote SQL connections with SQL Server Express?
To enable remote SQL connections with SQL Server Express please use the following steps:
Click Start => Programs => Microsoft SQL Server 2005/2008 => SQL Server Configuration Manager.
Select SQL Server Network Configuration
Double click on Protocols for SQLEXPRESS
Right click TCP/IP and select Properties
Click on the IP Address tab, and then under IP2 IP Address, enter your IP Address
Scroll down to IPAll make sure TCP Dynamic Ports is blank and that TCP Port is set to your custom port
Make sure that your custom port is enabled on your firewall and that mixed mode authentication is enabled for remote connections
When using SQL Express you will also need to open UDP port 1434
You may also find the following documentation helpful:
Was this answer helpful?
There are numerous ways to help improve security on your Windows server. Starting with the...
We recommend using the extensive support documentation from Microsoft:...
One simple method of transferring data to your windows server is by doing so through Remote...
If you have purchased a second ip address for your Windows installation and need to add the new...
If you have a new server and are unable to connect via Remote Desktop, you may need to first...