Thursday, March 22, 2012
Cannot Deploy Report Model
cannot deploy the model. The message I get is:
The permissions granted to user 'DOMAIN\USER' are insufficient for
performing this operation.
Both the SQL Server 2005 and SSRS are deployed on my machine on which I am
an administrator (both within the windows environment and in SQL Server).
Can someone please help?
Thanks,
JimI would imagine you are part of the Content Manager role on the report
server? Make sure your role on the report server has permission to Manage
Models and View Models. I had this problem when I upgraded from SSRS 2000 to
2005. For some reason none of the report model permissions were set after
the upgrade.
"Jim" wrote:
> I'm going through the 2005 SSRS tutorial for creating a report model and I
> cannot deploy the model. The message I get is:
> The permissions granted to user 'DOMAIN\USER' are insufficient for
> performing this operation.
> Both the SQL Server 2005 and SSRS are deployed on my machine on which I am
> an administrator (both within the windows environment and in SQL Server).
> Can someone please help?
> Thanks,
> Jim
cannot deploy analysis services tutorial db
i am using sql server developer 2005 .... i follow a tutorial example and attempt to deploy a created analysis services project to the analysis server .... but when i attempt to deploy i get the following:
Error 1 The following system error occurred: Key not valid for use in specified state. . 0 0
i have looked a bunch of different places and found references to this error and have tried things like deleting & creating a new data connection but this does not have any effect .... also these references i have found on the web dont look like they matche my particular situation (deploying to the analysis server) ..... does anyone know how I can get around this ? unfortunately i have not been sucessful in executing the most rudimentary task in sql server ...
thanks
Daver, this error message typically appears in scenarios where the SQL Server Analysis Services service account has been changed to Local Service or if there was an inappropriate change in the service startup account. Can you run your AS service as "Local System" or some valid domain user that has permissions to the relational database referenced in your project’s data source? To change the service account, please use the SQL Server Configuration Manager utility that ships with the product.
Hope this helps,
Artur
sql