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

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

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...

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...

How do I install an SSL certificate on a Windows Server?

In order to generate a Certificate Signing Request on your Windows Server 2008 environment: Go...

How do I enable audio over Remote Desktop?

There are two basic steps which need to be taken to ensure audio is enabled on your Windows VPS....

How to disable DNS recursion?

Disabling recursion on the DNS server Start->Administrative Tools->DNS Manager.In the...