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

  • windows, sql, server express
  • 1 Benutzer fanden dies hilfreich
War diese Antwort hilfreich?

Verwandte Artikel

How do I disable Internet Explorer Enhanced Security Configuration?

How to disable Internet Explorer Enhanced Security Configuration (IE ESC) in Windows Server 2012...

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

How to Open A Custom Port in Windows Server 2008

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

How do I secure my Windows Server?

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

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