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.
0
Add a comment
|
1 Answer
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).
answered Aug 1, 2012 at 14:02
