Server Principal insufficient privileges : Bienabee

How can we help you today?

Modified on: Tue, 21 Mar, 2017 at 12:57 PM

Applies to:

SQL Server 2012, windows authentication

Issue:

Getting some errors when trying to upgrade the ALM database saying user cannot execute sp_updatestats.

When we click on the database in SQL Management Studio we are not able to access the properties of the database.

Solution:

EXEC sp_chagedbowner 'theusername-here'

Did you find it helpful? Yes No

Help Desk Software by Freshdesk