خطأ عند رفع الموقع,المستخدم غير مصرح له بدخول

aurora كتب:

السلام عليكم ورحمه الله ...اولا اللي يساعدني في هالمشكله بدعي له برمضان من كل قلبي لاني صار علي شهر وانا احاول احلها وتعبت نفسيا من هالمشكله الموقع كان شغال عندي من اروع ما يكون بس لمن رفعته على السيرفر طلع لي هالخطأ واختكم مبتدئه في ال asp اتمنى تساعدوني ربي يوفقكم .. Server Error in '/' Application.--------------------------------------------------------------------------------Cannot open database "SQL2005_405980_master\App_Data\master1.mdf" requested by the login. The login failed.Login failed for user 'SQL2005_405980_master_user'. 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: Cannot open database "SQL2005_405980_master\App_Data\master1.mdf" requested by the login. The login failed.Login failed for user 'SQL2005_405980_master_user'.Source Error: Line 26: Line 27: If Not Page.IsPostBack() ThenLine 28: objDA.Fill(objDS)Line 29: intrecordcount.Text = CStr(objDS.Tables(0).Rows.Count)Line 30: objDS = NothingSource File: E:\web\pinktulip42\htdocs\recent.aspx.vb Line: 28 Stack Trace: [sqlException (0x80131904): Cannot open database "SQL2005_405980_master\App_Data\master1.mdf" requested by the login. The login failed.Login failed for user 'SQL2005_405980_master_user'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349 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) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 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.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86 recent.dofill() in E:\web\pinktulip42\htdocs\recent.aspx.vb:28 recent.Page_Load(Object sender, EventArgs e) in E:\web\pinktulip42\htdocs\recent.aspx.vb:13 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(خواني انا نسخت ال

connection string اللي عطاني اياه السيرفر وحطيته في ال web.configهل اغير فيه شي ولا احطه نفسه ؟

الخطأ يقول انه المستخدم'

SQL2005_405980_master_user' ما يقدر يدخل قاعدة البيانات ؟كيف اعطي هالمستخدم الصلاحية ؟وكيف انشىء هالمستخدم ؟

للاسف اللى بعرفه انك تتعاملى مع ال iss

وتعطى كل الصلاحيات لليوزر ولكن مابعرف كيف راح تعمليها من الويب ارجوا من شخص ما المساعدة ولكن تأكدى انك غيرتى ال id

الخاص بالويب جيدا وتاكدى من كل شىء عاملاه وبالأخص المتعلق بال sql

فى جمل الاتصال واتمنى لك التوفيق

السلام عليكم

طلعت لي مشكله ثانيه

بعد ما قدرت ادخل باسم المستخدم

يطلع لي هالخطأ

ال client هو عبارة عن جدول انا مسوته في قاعده البيانات اللي سويت لها Attach

شو الحل ؟؟؟؟

Invalid object name 'client'.

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: Invalid object name 'client'.

Source Error:

Line 18:

Line 19: If Not Page.IsPostBack() Then

Line 20: objDA.Fill(objDS)

Line 21: intrecordcount.Text = CStr(objDS.Tables(0).Rows.Count)

Line 22: objDS = Nothing

Source File: E:\web\pinktulip42\htdocs\clients.aspx.vb Line: 20

Stack Trace:

[sqlException (0x80131904): Invalid object name 'client'.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956

System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31

System.Data.SqlClient.SqlDataReader.get_MetaData() +62

System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32

System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122

System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12

System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavio

behavior) +7

System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86

clients.dofill() in E:\web\pinktulip42\htdocs\clients.aspx.vb:20

clients.Page_Load(Object sender, EventArgs e) in E:\web\pinktulip42\htdocs\clients.aspx.vb:11

System.Web.UI.Control.OnLoad(EventArgs e) +99

System.Web.UI.Control.LoadRecursive() +47

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061