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 !! 

Is this an internal server or available over the internet?  Can you ping the server? 
Rob Mills

www.dotnetadvisor.com

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 !! 

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

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

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 !!