We downgraded our SQL Server from Enterprise to Standard.

Now on 3 of my 5 non system databases a lot of users no longer have effective permissions. My admin account is in the same boat. I have owners for all the databases. I changed the owner and then changed back but it hasn't helped. Running the service and SQL Server Manager as Administrator didn't either.

No Effective Permissions

Has Effective Permissions

On one of the databases no users have any effective permissions?

  • Could you elaborate on the procedure used for downgrading? It could provide us with clues to help you.
    – artificer
    Feb 15 '15 at 18:29
  • @artificer I followed this guide, and it appeared to work fine: mssqltips.com/sqlservertip/3079/…
    – Nikewatch
    Feb 15 '15 at 18:32
  • AFAIK downgrade does not touches permisson, i am talking about ent avaluation to standard. Its strange issue you are talking about. How did you downgraded I can only say by uninstalling Enterprise and installing standard edition ? I guess you did some mistake.
    – Shanky
    Feb 16 '15 at 5:51
  • @Shanky It was an uninstall / install. I did at least one thing wrong in that I installed it as NT Authority instead of our domains sqladmin. So none of my jobs would run. As soon as I changed Log On As on Sql Server and Agent to sqladmin the jobs ran fine. I have probably done something along those lines for the permissions. I have now recreated the logins and all is back to normal.
    – Nikewatch
    Feb 16 '15 at 8:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.