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

Click OK
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:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Was this answer helpful?

 Print this Article

Also Read:

How do I secure my Windows Server?

There are numerous ways to help improve security on your Windows server. Starting with the...

How to Open A Custom Port in Windows Server 2008

We recommend using the extensive support documentation from Microsoft:...

How do I transfer files to my Windows Server?

One simple method of transferring data to your windows server is by doing so through Remote...

How do I manually add a second IP address to my Windows installation?

If you have purchased a second ip address for your Windows installation and need to add the new...

Why can't I connect via Remote Desktop?

If you have a new server and are unable to connect via Remote Desktop, you may need to first...