Site not working

Refers to:

  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows

Created:

2016-11-16 13:24:36 UTC

Modified:

2016-12-21 20:39:09 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Site not working

Symptoms

While accessing site it shows following error :

Server Error in '/' Application.
The INSERT permission was denied on the object 'DetLog', database 'database_name', schema 'dbo'.
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: The INSERT permission was denied on the object 'DetLog', database 'test123', schema 'dbo'.

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.

Cause

Wrong permissions are set for database.

Resolution

To resolve issue, follow the steps:

  • Open Microsoft SQL Management Studio Express
  • Navigate to Security > Logins > Right-click the db user and select Properites
  • In properties go to User Mappings , check the db user
  • Click on the database and check that the options db_owner and Public are selected.
  • Uncheck if you found any deny access is given to database under User Mappings.
Have more questions? Submit a request
Please sign in to leave a comment.