Hi.
I recently had to remove SQL Server 2005 and SQL Server 2005 Express from my
system. Then, I reinstalled the express edition. This works locally, but
when I try to connect to a database on this computer from another computer on
my local network, I get the message:
System.Data.SqlClient.SqlException: 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: 26 - Error Locating Server/Instance Specified)
The message in itself is clear, but where do I change the default settings
of SQL Server?
Regards,
Gudni
Rory Becker - 29 Mar 2007 12:20 GMT
> The message in itself is clear, but where do I change the default
> settings of SQL Server?
SQL Server Surface Area Configuration
In "All Programs\Microsoft SQL Server 2005\Configuration" on my machine
Then visit "Surface Area Configuration for services and connections"
Select "Remote Connections" and Enable things as you see fit
--
Ror
Roy Soltoff - 29 Mar 2007 16:38 GMT
I believe the other poster's comments related to SQL Server, not SQL Server
Express. Look at MSDN Article ID 555585 for the solution for SQL 2005
Express Server. You may need to install the Express Edition Management
Studio as discussed in the document.
> Hi.
> I recently had to remove SQL Server 2005 and SQL Server 2005 Express from
[quoted text clipped - 18 lines]
> Regards,
> Gudni