Discussion :

[Im.Cresus]

Bonjour

Je viens de développer une application ASP.net 4 avec un système de login via des formulaires et une base de données SQL, celle fournie par défaut dans VisualStudio 2010...

Mon application marche, en local... mais quand je la publie sur mon serveur... Le système de login ne marche plus et le serveur me renvoi l'erreur suivante:

Server Error in '/' Application.
--------------------------------------------------------------------------------

User does not have permission to perform this action.
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: User does not have permission to perform this action.

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): User does not have permission to perform this action.]

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

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412

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

System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +53

System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +6292062

System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +6291977

System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +352

System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +506

System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +49

System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +6293782

System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +78

System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1922

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +89

System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6296606

System.Data.SqlClient.SqlConnection.Open() +300

System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +150

System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +4603263

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) +3665527

System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +189

System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +202

System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +225

System.Web.UI.WebControls.Login.AttemptLogin() +166

System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +93

System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +52

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

Comment faire pour solutionner ce probème ?

[lutecefalco]

Apparemment problème de droit sur la DB

[hwoarang]

Comment faire pour solutionner ce probème ?

En créant un utilisateur avec le bon login/mot de passe que tu utilises pour acceder à la base sur le serveur et en lui donnant les droits necessaires sur les tables sensées etre utilisées.

a+