Hi All, i am using tha conncetion string in web.config.

 Instance=false and true both i have used

 but i am getting error like that. on my web hosting site

 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)

 can u send me the solutions of that problem.

Thanks in Advance.

Dheeraj Mittal

dhemittal@gmail.com

 I am getting the same error, does anyone have an update on this?

Set Try to set Data Source = "Server name" in connection string

Open "SQL Server Surface Area Configuration"

then opne the "Surface Area Configuartion for Services and Connections "

Under the Remote connection u have to enable the "Using both TCP/IP and Named  Pipes "

then It will work..

Try to set Data Source= "serverName" in you connectionString

Data Source=.\SQLEXPRESS will work only on local m/c, It will not work if you host your site

Check in web.config for connectionString, configure it according to your server name, password etc.

In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..

You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

aspnet_regsql, it will open one window, where you  have to configure DB.

Hope it will help you, let me know.

Hope it will help you, let me know.

http://forums.asp.net/t/1260556.aspx

http://forums.asp.net/t/913172.aspx

http://forums.asp.net/t/1008091.aspx

Hi

i was facing the error when opening connection using sqlconnection nw got solved

http://sqlservererror-info.blogspot.com/2009/07/error-has-occurred-while-establishing.html

http://aspnetmembershipprovider.blogspot.com/2009/02/error-has-occurred-while-establishing.html

See This

Hi

If you wants to know how to enable remote connections in sql server 2005 pls visit this

http://aspnetmembershipprovider.blogspot.com/2009/02/eanble-remote-connections-on-instance.html

Regards

 Configure throgh SQL Server Management Configuration tools

 Thanks for the information