Warning "You are not logged on as the database owner or system administrator" in SQL Management Studio

Created:

2017-03-30 06:59:49 UTC

Modified:

2017-08-08 13:28:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Warning "You are not logged on as the database owner or system administrator" in SQL Management Studio

Applicable to:

  • Plesk Onyx for Windows

Symptoms

Warning You are not logged on as the database owner or system administrator in SQL Management Studio on attempt to create/modify table, when connection is made under MSSQL user created in Plesk.

Cause

DB user has no role db_owner set in its properties

Resolution

This is an expected behavior. Such setting is not being set by default, when the user is created via Plesk. If the user has this role enabled, it allows to change database size, logs size, etc and overuse limits that have been set in Plesk for subscription or specified in the service plan.

However, the DB user has all required permissions to create/read/write/modify tables permissions and if click OK button, it is possible to continue and create table.

Have more questions? Submit a request
Please sign in to leave a comment.