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

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

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