How to redify the connection Error

14 Dec 2006 6:35 AM

Krishna

Hi,
I developed one solution using .net 2005 and sql server 2005.The sql
server acess to the management studio and server default settings is local
and remote connection.But I run the application it's display the following
error.how to solve the issue.
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)

Regards
T.A.Krishna

15 Dec 2006 3:13 PM

Ciaran O''Donnell

you need to make sure the connection string has a valid instance name for the
server and you are connecting to the right port number. This is almost
impossible to debug with out being able to see your connection strings and
server config.

--
Ciaran O''''Donnell
http://wannabedeveloper.spaces.live.com

Show quote

"Krishna" wrote:

> Hi,
> I developed one solution using .net 2005 and sql server 2005.The sql
> server acess to the management studio and server default settings is local
> and remote connection.But I run the application it's display the following
> error.how to solve the issue.
> 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)
>
>
> Regards
> T.A.Krishna