ALM 12.x obligatory permits SA Database to perform an upgrade
In ALM 12.x is obligatory permits SA Database to perform an upgrade. This previously was not. The installation manuals say it is not mandatory, but it is false.
It would be good that could be done using an account with specific permissions, but not SA.
Is this going to change in the future?
This is in SQL Server 2008 and 2012. Processes for the upgrade running SP (Statistics) from the database. These require mandatory permission as SA
It is not mandatory to use the SQL sa account. You can always create a new user with Database Creators and Security Administrators roles to install or upgrade to ALM 12.xx
In your case, it seems that the account does not have enough permissions, or have more permissions than required. I recommend you to contact your DBA and open a case with Support for further assistance and this seems not to be a simple issue.
It is not that way.
- If I try to do UPGRADE to SA, does not allow me.
- I also tried creating a new user, but when making the UPGRADE tells me it is mandatory that the user has SA permission.
I can not create a new user with Database Creators and Security Administrators roles to install or upgrade to ALM 12.xx any more. I can make it to the version ALM 11.x , but I can not in ALM 12.x
After some research, this is a bug in the SQL Server with the Admin Accounts (except for sa). The explanation for the bug is at -> https://connect.microsoft.com/SQLServer/feedback/details/436562/sp-updatestats-access-denied-for-db-owner-member
Also, the way to fix it, is by giving the proper permissions to the SQL Account:
create procedure dbo.up_updstats
with execute as 'dbo'
grant execute on dbo.up_updstats to [ HPPQC...user]
After that, you should be able to do the upgrade.