SQL Server does not allow remote connections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
The message in itself is clear, but where do I change the default
settings of SQL Server?
Click to expand...

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
 
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.
 
Back
Top