When i enter log in, I get the following error page.
Server Error in '/' 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] 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) +421 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.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
How can I resolve this issue?
This is my web.config file. Is there anything I need to add to make my log in system work. The database is already at the hosting server.
<?xml version="1.0"?><!--Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
\Windows\Microsoft.Net\Framework\v2.x\Config
--><
configuration><appSettings/><
connectionStrings><add name="kcolDatabaseConnectionString" connectionString="Server=mssql.namesco.net;Database=kcoldatabase;uid=kcol2;pwd=******;" providerName="System.Data.SqlClient"/><
add name="ASPNETDBConnectionString" connectionString="Server=mssql.namesco.net;Database=kcolroles;uid=roles;pwd=******;" providerName="System.Data.SqlClient"/> </connectionStrings><
system.web><!--Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
Visual Basic options:
Set strict="true" to disallow all data type conversions
where data loss can occur.
Set explicit="true" to force declaration of all variables.
<customErrors defaultRedirect="~/redirect.aspx" />
--><
compilation debug="true" strict="false" explicit="true"> <assemblies><
add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/><
add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies></compilation><
pages> <namespaces><
clear/> <add namespace="System"/><
add namespace="System.Collections"/> <add namespace="System.Collections.Generic"/><
add namespace="System.Collections.Specialized"/> <add namespace="System.Configuration"/><
add namespace="System.Text"/> <add namespace="System.Text.RegularExpressions"/><
add namespace="System.Web"/> <add namespace="System.Web.Caching"/><
add namespace="System.Web.SessionState"/> <add namespace="System.Web.Security"/><
add namespace="System.Web.Profile"/> <add namespace="System.Web.UI"/><
add namespace="System.Web.UI.WebControls"/> <add namespace="System.Web.UI.WebControls.WebParts"/><
add namespace="System.Web.UI.HtmlControls"/> </namespaces></
pages><!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
--><authentication mode="Forms"/><
customErrors mode="Off"/><!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
--></
system.web></
configuration>
Can anybody help me out here, before I loose my job?
____________________________________
u dont luv me the way that I luv u !!
![]() |
-1 |
![]() |
Is this an internal server or available over the internet? Can you ping the server?
Rob Mills
www.dotnetadvisor.com
![]() |
-1 |
![]() |
It is in the server.... and the webconfig that is mentioned above is the one configured at the server...
I have made it work ... i dont see the above error any more... this is because i had changed the webconfig file....here is the changes I made in the webconfig file...
<add name="ASPNETDBConnectionString"
connectionString="Server=mssql.namesco.net;
Database=kcolroles;uid=roles;pwd=***;" providerName="System.Data.SqlClient"/>
<remove name="LocalSqlServer"/><add name="LocalSqlServer"
connectionString="Server=mssql.namesco.net;
Database=kcolroles;uid=roles;pwd=***;" providerName="System.Data.SqlClient"/>
Now I can log in ..... but I get a blank screen... the page should contain the contents... but I dont see any content??? none of the role works...
Any idea rob?
____________________________________
u dont luv me the way that I luv u !!
![]() |
-1 |
![]() |
Well if you're not getting any results I'm going to need to know more about what you're trying to accomplish. Can you explain the page and it's purpose?
Rob Mills
www.dotnetadvisor.com
![]() |
0 |
![]() |
Hi,If you have full control over your sql server2005 then follow these steps:
Go to sql2005->configuration tools->Sqlserver surface area configuration then
Click on surface area configuration for services and connections then clik on remote connections and select local and remote connections.
and apply the new settings .
Hope this will solve your Prob.
"Happy Coading"
Thanks
Anand Kumar Mishra
Sr.Consultant Enterprise Solutions
Expedien e-Solutions Ltd.
Noida
![]() |
0 |
![]() |
i added the following things in my webconfig file and worked....
<roleManager enabled="true"/>
<
authentication mode="Forms"><forms loginUrl="~/login.aspx" slidingExpiration="true" timeout="60"/></
authentication><
customErrors mode="Off"/>
..i believe the above additional to the log in page has made it to work....
____________________________________
u dont luv me the way that I luv u !!
![]() |
0 |
![]() |