Insufficient privileges to manage this database

Anis Abed
Anis Abed Active Partner
Level 200: Building A Planning Solution in Board Name Dropper Level 100: Foundations of Building in Board First Anniversary
in Platform

Hi,

I am migrating a board 10 datamodel to a board 12 datamodel on a new server with an on-premise installation, I successfuly copied the database file to the board 12 database folder, I restarted the server, but when trying to upgrade the datamodel I get the following error " Insufficient privileges to manage this database "

Privileges.png


Upon checking the diagnostics file I found this log line as well :
Administrator dbaa59c7-f0fe-4dbf-b6f8-75ba4815f118 DTB_OpenByName Inviflam {"ErrorCode":"DatabaseAccessDenied"

Note : I have an admin license with the full rights on my server

How can I solve this issue please ?

Best regards,

Accepted Answer

  • Willians Santana
    Willians Santana Employee
    5 Answers 10 Comments Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
    Answer ✓

    Hi Anis,

    How are you doing? I hope you are having a great day!
    Please, check the Database Security Profile Name.

    Is the new Board 12 installation's Administrator or Developer Security Profile assigned with the proper Database Security Profile Name?

    Best Regards,
    Willians

Answers

  • Leone Scaburri
    Leone Scaburri Employee
    Fourth Anniversary 100 Comments 5 Answers 25 Likes

    Hi @Anis Abed,

    make sure you extracted and cleared all cubes before migrating your data model from B10 to B12

  • Neha Hasija
    Neha Hasija Employee
    Fourth Anniversary 10 Comments Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board

    Hi Anis,

    It most likely looks like Database Security Issue.

    Did you change any Database security recently.If yes, trying restoring backup with proper security.

    Also, Did you extract all the cubes on B10?

    Thanks,

    Neha

  • Anis Abed
    Anis Abed Active Partner
    Level 200: Building A Planning Solution in Board Name Dropper Level 100: Foundations of Building in Board First Anniversary

    Hi All,

    Thanks for your answers, fortunately I was able to resolve the issue, indeed it was the default database security profile parameter that was missing, I had to type "ADMIN" to gain access to the database.

    Thanks you very much,

    Anis

  • Holly Rieke
    Holly Rieke Employee
    100 Likes Second Anniversary 10 Comments New Community Member
    admin

    @Anis Abed I'm happy you were able to get your question answered! If you'd like, you can select 'Yes' to the 'Did this answer the question?' option. This helps others identify the best solution.

  • Willians Santana
    Willians Santana Employee
    5 Answers 10 Comments Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board

    Awesome, @Anis Abed! Great News! Thank you for your message and feedback! I do appreciate that, and I am glad to know that.

Categories