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 all

shalu

Dear Mudassar,

I tried the sample given in the below link:

http://aspsnippets.com/Articles/Simple-Insert-Select-Edit-Update-and-Delete-in-ASPNet-GridView-control.aspx

but i'm getting below error

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)

How to resolve this.

Thanks,

shalu

Mudassar

0 1

The sql server instance specified in the connection string is incorrect or not reachable

http://www.aspsnippets.com/Articles/Exception---error-26---Error-Locating-Server-Instance-Specified.aspx

hammath

0 2

u have to change the connection string ,,

just drag and drop any table from the serverExplorer to ur design page

it ll genarate connection string automatically in web.Config file..

Mudassar

0 3

Then your Sql Server might not be running or some Firewall is blocking connection to it

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html