Asp .net enterprise Manager - CREATE TABLE permission denied in database

Refers to:

  • Plesk 11.5 for Windows

Created:

2016-11-16 12:45:33 UTC

Modified:

2017-02-23 08:23:10 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Asp .net enterprise Manager - CREATE TABLE permission denied in database

Symptoms

I have uploaded the database and website content: http://domain.tld.

But there is no database create permission. It is not possible to create table from MSSQL webamin panel "Asp .net enterprise Manager":

Error:   CREATE TABLE permission denied in database 'redspot'.
Source: .Net SqlClient Data Provider

Cause

Database user does not have 'db_owner' role.

Resolution

To grant permissions in SQL Server

  • Open SQL Server Management Studio and connect to your instance of SQL Server.
  • In the left pane, click Databases , select a database, click Security, and then click Users.
  • In the Users pane, right-click the user that needs permissions, and on the shortcut menu, click Properties.
  • Under Database role membership, select relevant privileges, and then click OK.
Have more questions? Submit a request
Please sign in to leave a comment.