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 Int
dheeraj_mitt...
Member
13 Points
83 Posts
Error : An error has occurred while establishing a connection to the server. When connecting to S...
Oct 21, 2008 02:04 PM|LINK
Hi All, i am using tha conncetion string in web.config.
<add name="MyLocalSqlConnection" connectionString="Data Source=.\SqlExpress;AttachDbFilename=|DataDirectory|\SqlServer\OC00003SQL.mdf;User Instance=false" providerName="System.Data.SqlClient"/> Instance=false and true both i have usedbut 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
Time Tracker
henropotter
Member
2 Points
1 Post
Re: Error : An error has occurred while establishing a connection to the server. When connecting ...
Oct 21, 2008 06:49 PM|LINK
I am getting the same error, does anyone have an update on this?
chetan.sarod...
All-Star
65719 Points
11133 Posts
Re: Error : An error has occurred while establishing a connection to the server. When connecting ...
Oct 22, 2008 03:45 AM|LINK
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
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
shijobaby@ya...
Member
14 Points
20 Posts
Re: Error : An error has occurred while establishing a connection to the server. When connecting ...
Jul 20, 2009 04:21 AM|LINK
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
shijobaby@ya...
Member
14 Points
20 Posts
Re: Error : An error has occurred while establishing a connection to the server. When connecting ...
Jul 20, 2009 04:22 AM|LINK
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
chetan.sarod...
All-Star
65719 Points
11133 Posts
Re: Error : An error has occurred while establishing a connection to the server. When connecting ...
Jul 23, 2009 03:05 AM|LINK
Configure throgh SQL Server Management Configuration tools
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
chetan.sarod...
All-Star
65719 Points
11133 Posts
Re: Error : An error has occurred while establishing a connection to the server. When connecting ...
Jul 27, 2009 03:04 AM|LINK
Thanks for the information
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.