- Plesk 11.x 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.
- 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.