By default, Microsoft SQL Server Express 2008 uses TCP Dynamic Ports for communication and data transfer. For remote access to your SQL Server using SQL Server Management Studio, you must configure the system to use a static TCP port. For this document, we will use port 1433 (default), but you can assign whichever port you would like.
This document assumes you have successfully installed SQL Server 2008 Express on Windows Server 2003.
First we need to create two firewall rules. One for the (TCP) port that the SQL Server will use and one for the (UDP) port that the SQL Server Browser uses.
Now we need to remove the dynamic ports and tell SQL Server that you want to use port 1433 to connect to the server.
You need to restart the SQL Server Service for the changes to take effect.
To restart the SQL service...
Also, while you are here, make sure that the SQL Server Browser service is started.
Open a Command Prompt. Run the command:
Ports 1433 and 1434 should both be open and listening.
You should now be able to connect to your SQL Server remotely.
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License