The database principal owns a schema in the database, and cannot be dropped.

The database principal owns a schema in the database, and cannot be dropped.The database principal owns a schema in the database, and cannot be dropped.

The database principal owns a schema in the database, and cannot be dropped.

Hi everyone,

Another problem arise while I tried to restore a backup of some database and try to remove the user ASPNET. After ‘googlear’ I found with the entry of blog of Kaushal where explain how to solve this issue.

After fix it,  other error message was show which doesn’t allow me delete an user of database (ASPNET), the message was similar to previous. This was: The database principal owns a database role and cannot be dropped.

To fix the last error, I follow the same steps which I used to previous error, but I look for Roles instead of Schemas, and then I changed the owner from ASPNET to dbo

Regards,

Álvaro

Advertisements

One response to “The database principal owns a schema in the database, and cannot be dropped.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: