Showing posts with label deniedquot. Show all posts
Showing posts with label deniedquot. Show all posts

Monday, February 13, 2012

Access is denied when trying to restore Anaylsis Services 2005 Databases

I'm getting a "access is denied" error when I try to create a new analysis services 2005 database by restoring one from a backup created from a different server. I can restore a backup created from the same machine w/o any problems. The login I'm using is a domain admin account.

Both machine is running SQL 2005 SP2. Any help would be appreciated.

Thanks,

Henry

Hello! I recommend you to use the BI-Dev project instead and deploy it on a new server. Delete any roles you have in the project because I think they are the cause of problem.

I think that there is an issue with moving cubes between servers and the cube roles.

HTH

Thomas Ivarsson