Enabling Network Access to SQL Server Express

When Microsoft SQL Server 2005 Express Edition (SQL Server Express) is installed, the networking protocols are disabled by default for security purposes.

Providing Network Access

Many applications that use SQL Server Express will only access data locally, and so leaving these protocols disabled is appropriate. However, if your application accesses an instance of SQL Server Express that is running on a different computer, you must enable one or more network protocols, and you must also start the SQL Server Browser service.

The following procedural topics describe how to enable network access to SQL Server Express:

How to: Start and Stop the SQL Server Browser Service (SQL Server Express)

How to: Enable Network Access During Installation (SQL Server Express)

How to: Enable Network Access in SQL Server Configuration Manager (SQL Server Express)

See Also

Other Resources

Networking in SQL Server Express

Help and Information

Getting SQL Server 2005 Assistance