Take the 2-minute tour ×

I've just installed SQL Server 2008 Express. But when I try to connect to database engine via SQL Server Management Studio I get "A network-related or instance-specific error occurred while establishing a connection to SQL Server" error. I want to allow remote connections to the server but Surface area configuration is missing in 2008. If I cannot connect to the server instance then how am I supposed to configure this feature? Thanks ahead.

share|improve this question

migrated from stackoverflow.com Aug 1 '12 at 14:01

This question came from our site for professional and enthusiast programmers.

1 Answer 1

Go into the SQL Server Configuration Manager (SSCM) and under Service Protocols enable TCP/IP for your SQL Server Express instance (most likely called SQLEXPRESS).

share|improve this answer
...and restart the instance. –  Jon Seigel Aug 1 '12 at 17:06

Your Answer


