Error: Either the user does not have permission to alter the object, or the object does not exist.

Symptoms

Resolution

Generally speaking, this is a permissions error and the user account that the JDM is running as will need to have Admin privileges granted.

However, what if the only account that has SQL Server Admin rights was the initial installer and they're no longer available?  In situations like this, it is much more reasonable and expedient to follow the process detailed below and grant those permissions locally, rather than uninstall/reinstall the SQL Server and/or wait for that person to be available to grant such permissions.

1. Launch Services.msc as an admin account.  This can be found here: C:\Windows\System32\Services.msc.
2. Scroll down to SQL Server Analysis Services (NAMED_INSTANCE).  Right-click on the service name and select Stop.
3. Right-click on the service name again and select Properties.
4. On the Log On tab, copy the value that is currently set in the This account: box and paste this into a notepad file for temporary storage.
   

   • Typically, this will be NT Service\MSSQLServerOLAPService
5. Once copied, change the This account: box to reflect the user you would like to grant Admin privileges to and fill in the corresponding password fields.
6. Once the fields are complete, click Apply, then OK.
7. Right-click on the service once more, and select Start.
   

   • At this point, we have changed the default account that Analysis Services will run as to an account that we can make changes with.
8. Now, open your SQL Server Management Studio (SSMS) program and connect to Analysis Services.
   

   • If the account you are granting 'Admin' privileges differs from the account you're logged in as, you will need to run SSMS as the account you assigned in Step 5.
9. Once connected, in the Object Explorer tree (on the left) right-click on the server name and select Properties
10. Click Security from the list on the left pane and then choose Add.
11. Choose the correct location to find your new 'Admin' account, type in the name, and then click on Check Names
    

    • Once you've identified the correct account, simply select it, click OK, and then click OK once more.
    • We've now added this login as an Analysis Services administrator account.
12. The last step is to reset the default account that the 'Analysis Services' service will run as, so open up your Services.msc window again.
13. Locate the SQL Server Analysis Services (NAMED_INSTANCE) service again, right-click on it and select Stop.
14. Right-click on the service name again and select Properties.
15. On the Log On tab, paste the value that you previously copied into a notepad into the This account: box.
    

    • Delete the **** entries within the two password fields.
16. Once the fields are complete, click Apply, then OK
17. Right-click on the service once more, and select Start.