Article ID: 125089, created on Apr 2, 2015, last review on Jun 17, 2016

  • Applies to:
  • Plesk 11.5 for Windows


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


Database user does not have 'db_owner' role.


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.

Search Words

sql query not running

websadmin not working

85a92ca67f2200d36506862eaa6ed6b8 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128

Email subscription for changes to this article
Save as PDF