SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 ASP.NET
 error has occurred while establishing a connection
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

robertnzana
Starting Member

42 Posts

Posted - 05/23/2008 :  20:17:27  Show Profile  Reply with Quote
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

USA
36594 Posts

Posted - 05/23/2008 :  21:33:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

robertnzana
Starting Member

42 Posts

Posted - 05/24/2008 :  17:11:15  Show Profile  Reply with Quote
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? :)
Go to Top of Page

Rashaali84
Starting Member

1 Posts

Posted - 06/11/2008 :  03:27:17  Show Profile  Reply with Quote
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 ?
Go to Top of Page

shijobaby
Starting Member

India
44 Posts

Posted - 07/19/2009 :  07:22:50  Show Profile  Visit shijobaby's Homepage  Reply with Quote
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
Go to Top of Page

shijobaby
Starting Member

India
44 Posts

Posted - 07/19/2009 :  07:23:14  Show Profile  Visit shijobaby's Homepage  Reply with Quote
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
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 07/20/2009 :  16:57:28  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000