ورود

View Full Version : سوال: مشکل با کنترل login ساخته شده توسط ویژوال استدیو (aspnetdb)



mohsen_t1
سه شنبه 18 فروردین 1388, 18:39 عصر
با سلام
من یه سایت طراحی کردم که دو بانک داره یه بانک رو خودم درست کردم و یکی دیگه رو زمانی که از کنترل login استفاده کردم توسط ویژوال استدیو ایجاد شده (aspnetdb).
من سایتو روی اینترنت آپلود کردم تمام قسمت هایی که با بانک خودم سرو کار داره درست کار می کنه و اطلاعاتو درست نشون می ده و لی زمانی که می خوام با نام کاریری وارد بشم به کانکشن بانک aspnetdb گیر میده .
این پیام رو می ده :

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.OnErro r(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(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.Att emptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114 System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +421 System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +133 System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(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.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.Validate User(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

mohsen_t1
سه شنبه 18 فروردین 1388, 18:55 عصر
این هم قسمتی از وب کانفیگ :



<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSecti on, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
</configSections>
<appSettings/>
<connectionStrings>
<add name="ConnectionString" connectionString="server=(local);uid=database1user240;pwd=8451622.50 587463;database=database1"/>
<add name="ConnectionString2" connectionString="server=(local);uid=aspnetdb1user661;pwd=8752770.20 523071;database=aspnetdb1"/>


</connectionStrings>

<system.web>


<roleManager enabled="true" />

<compilation debug="true" strict="false" explicit="true">
<assemblies>
<clear/>

mohsen_t1
سه شنبه 18 فروردین 1388, 19:18 عصر
من حتی جداول بانک خودمو در بانک aspnetdb ایجاد کردم - بانک رو آپلود کردم.و کانکشن هم درست کردم .
روی اینترنت باز هم اطلاعات خودمو درست نشون می داد ولی زمانی که می خوام لوگین کنم باز همون خطا رو می ده.
دیگه نمی دونم باید چه کنم.:عصبانی++:
اساتید کمک کنید.

mohsen_t1
پنج شنبه 20 فروردین 1388, 01:13 صبح
از اساتید و دوستان کسی نیست کمکم کند. :گریه:
ممنون می شم.