SQL Server does not allow remote connections

29 Mar 2007 9:20 AM

Gudni G. Sigurdsson

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

29 Mar 2007 11:20 AM

Rory Becker

> 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

--
Rory

29 Mar 2007 3:38 PM

Roy Soltoff

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.

Show quote

"Gudni G. Sigurdsson" <GudniGSigurds***@discussions.microsoft.com> wrote in
message news:36C351CD-0900-436A-9414-888717C9F9E5@microsoft.com...
> 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