error has occurred while establishing a connection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

error has occurred while establishing a connection

Author

Topic

robertnzana
Starting Member

42 Posts

Posted - 2008-05-23 : 20:17:27

I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life.

NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. I am using the same connection string with the exception of teh db name.

Now I'm getting this error. Any idea why?

Server Error in '/myuser4/MyWebApp' Application.
--------------------------------------------------------------------------------

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

Line 4:
Line 5: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Line 6: If User.IsInRole("LexAdmin") Or
User.IsInRole("LexOperator") Or User.IsInRole("LexUser") Then
Line 7: Response.Redirect("admin/ManagePackages.aspx")
Line 8: ElseIf User.IsInRole("CustomerAdmin") Or
User.IsInRole("CustomerClient") Or User.IsInRole("CustomerUser") Then

Source File: d:\hosting\member\myuser4MyWebApp\loginredirect.aspx.vb
Line: 6

Stack Trace:

[SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +186
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject) +737554
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject) +114
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
+173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) +133
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context,
Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String
connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +771
System.Web.Security.RolePrincipal.IsInRole(String role) +272
loginredirect.Page_Load(Object sender, EventArgs e) in
d:\hosting\member\myuser4\MyWebApp\loginredirect.aspx.vb:6
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
ASP.NET Version:2.0.50727.1433

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-23 : 21:33:16

http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

robertnzana
Starting Member

42 Posts

Posted - 2008-05-24 : 17:11:15

it's wierd, when i added (in my web.config) a reference to "LocalSQLServer" (typical "remove", then "add") it worked! what's wierd is that in NONE of my sqldatasources do I reference this!!!!! any insight to this strangeness? :)

Rashaali84
Starting Member

1 Post

Posted - 2008-06-11 : 03:27:17

i have the Sam SQl connection problem
in my login page i have this part of Code
/////////////////////
Validate("Login");
if (IsValid)
{
bool isPasswordCorrect = false;
String email = this.EmailTextBox.Text.Trim();
String password = this.PasswordTextBox.Text.Trim();
SyrexeUser su = null;
SyrexeUserBusiness subl = new SyrexeUserBusiness();
try
{
su = subl.GetUser(email, password);
UserProfile.SetProfileUserInfo(su.UserId);
String roles = subl.GetUserRoles(su.UserId);
SyrexeHelper.Authenticate(su.UserId, roles, false);
isPasswordCorrect = true;
}
catch (DataAccessException exception)
{
isPasswordCorrect = false;
}

if (isPasswordCorrect)
{
String returnUrl = Utility.GetParameterValue("ReturnUrl", Utility.DataHolders.QueryString);
if (!String.IsNullOrEmpty(returnUrl))
{
Response.Redirect(returnUrl);
}

try
{
Response.Redirect("~/Default.aspx", false);

}
catch (ThreadAbortException ex)
{
}

}
else
{
List<String> errors = new List<string>();
errors.Add("Incorrect user name or password");
ErrorsRepeater.DataSource = errors;
ErrorsRepeater.DataBind();
}
}
///////////////

in RESPONSE.REDIRECT Line gives me the Following 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Please Any help ?

shijobaby
Starting Member

44 Posts

Posted - 2009-07-19 : 07:22:50

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
Starting Member

44 Posts

Posted - 2009-07-19 : 07:23:14

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

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-07-20 : 16:57:28

quote:
Originally posted by Rashaali84
. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Please Any help ?

also change it from name pipes to TCP/IP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources