Enable Remote Connection on SQL Server 2008 Express
Update to my earlier post "A network-related or instance-specific error occurred while establishing a
connection to SQL Server. ....".
Now SQL Server 2008 Express doesn’t allow
remote connection on default installation as on SQL Server 2005
Express. So you have to enable it manually.
If
you’re trying to connect to SQL Server 2008 Express remotely without
enable remote connection first, you may see these error messages:
connection to SQL Server. ....".
Now SQL Server 2008 Express doesn’t allow
remote connection on default installation as on SQL Server 2005
Express. So you have to enable it manually.
If
you’re trying to connect to SQL Server 2008 Express remotely without
enable remote connection first, you may see these error messages:
- “Cannot connect to SQL-Server-Instance-Name
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 28 – Server
doesn’t support requested protocol) (Microsoft SQL Server)”