Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

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


When working within the Jet Data Manager, or anytime Admin permissions are needed within SQL Server Analysis Services, you may encounter the following error: "Either the user does not have permission to alter the object, or the object does not exist".


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.
    1. 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'.
    1. 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'.
    1. If the account your 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, right-click on the server name in the 'Object Explorer' tree on the left 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'
    1. Once you've identified the correct account, simply select it, click 'OK', and then click 'OK' once more.
    2. 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.
    1. 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'.
What this process does is it sets your primary account as a default Analysis Services admin account.  Upon doing this, you can then physically add your primary account to the Analysis Services security correctly.  Once your primary account is setup within the security protocols, you simply rollback the default admin account to the NT SERVICE default and restart the service.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request