|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/19/2006 12:02:00 AM
Posts: 6,
Visits: 1
|
|
Please give me connection string for clasic, standard asp.net 2.0 membership class. Thanks
InternetOglas
|
|
|
|
|
Junior Member
Group: Administrators
Last Login: 7/19/2006 11:19:00 AM
Posts: 19,
Visits: 1
|
|
Is this what you are looking for: <connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=SQL2005DatabaseServer;Integrated Security=false;Initial Catalog=DatabaseName;User ID=DB_User;Password=DB_Password" providerName="System.Data.SqlClient" />
</connectionStrings>
Re-invent Technologies LLC
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/5/2006 7:58:00 PM
Posts: 1,
Visits: 1
|
|
Dear webmaster,
iam using ASP.NET 2.0 to connect to my database
iam using this connection string in the web.config file
and iam getting 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
i tried to connect to the database using SQL Management Studio, it succeeded for the first time, but failed after that ,i mean it worked only once.
i needto solve the problem ASAP.
Thank you fo your suggestion.
|
|
|
|
|
Supreme Being
Group: Administrators
Last Login: Today @ 11:22:29 AM
Posts: 170,
Visits: 476
|
|
What is your domain name?
Paul BRe-invent Technologies LLC
http://www.re-invent.com
Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
|
|
|
|
|
Supreme Being
Group: Administrators
Last Login: Today @ 11:22:29 AM
Posts: 170,
Visits: 476
|
|
Hello, This will commonly occur if using SQL Express instead of connecting to your hosted SQL 2005 database with Re-invent in your web.config file. I can direct our support dept to assist you further if you send us your domain name or contact our support dept directly if you require further assistance.
Paul BRe-invent Technologies LLC
http://www.re-invent.com
Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/5/2006 11:40:00 AM
Posts: 2,
Visits: 1
|
|
hello,
my domain is gssohal.com
sql server ip is sqlserver-2.reinventinc.com
this is my connectionString
i have done all the above but it does nothing i still get that same -26 error message
Server Error in '/dev/chakardar' 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) +734995
System.Data.SqlClient.TdsP****r.ThrowExceptionAndWarning(TdsP****rStateObject stateObj) +188
System.Data.SqlClient.TdsP****r.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
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) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
|
|
|
|
|
Supreme Being
Group: Administrators
Last Login: 1/1/2009 9:27:17 AM
Posts: 106,
Visits: 276
|
|
The SQL Server you are on is sql2005-2.reinventinc.com
Plato
Re-invent Technologies LLC
Re-invent Support Team
http://www.re-invent.com
Specializing in ASP.NET Hosting
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/5/2006 11:40:00 AM
Posts: 2,
Visits: 1
|
|
yeah sorry that was a typo in this thread, i have it as u have said above, sql2005-2.... no can do , does not work!
|
|
|
| | |