Dark Developments Where Knowledge Meets Power

15Sep/110

SQL – Enable Remote Access for SQL Express and SQL Server Developer Edition

Posted by Dark#Basics

SQL - Enable Remote Access for SQL Express and SQL Server Developer Edition

By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps:

* Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
* Turn on the SQL Server Browser service.
* Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.