Thursday, March 22, 2012
Deployment problem - Insufficient Rights
problem with Deployment Reports to Server.
when i click the deploy, i am getting the following error.
The permissions granted to user 'domain/machinename' are insufficient for
performing this operation.
pls assist me.
muraliIs the account your are trying to deploy with an account known on the report
server, and ifit is does it have publish rights in the report server? this
might be a the cause of this issue
"Murali" wrote:
> Dear friends,
> problem with Deployment Reports to Server.
> when i click the deploy, i am getting the following error.
> The permissions granted to user 'domain/machinename' are insufficient for
> performing this operation.
> pls assist me.
> murali|||Yes. My Account have full control on the Report Server.
How to check My Account have publish rights or not?
please reply.
"Remond" wrote:
> Is the account your are trying to deploy with an account known on the report
> server, and ifit is does it have publish rights in the report server? this
> might be a the cause of this issue
>
> "Murali" wrote:
> > Dear friends,
> >
> > problem with Deployment Reports to Server.
> >
> > when i click the deploy, i am getting the following error.
> >
> > The permissions granted to user 'domain/machinename' are insufficient for
> > performing this operation.
> >
> > pls assist me.
> >
> > murali
Wednesday, March 21, 2012
Deployment Errors
services database server and also admin rights on the server. I deployed my
report to the reporting services server without errors, however someone else
(not sa equivalent on the database, and not admin equivalent) cannot deploy
because they get permission errors.
Any ideas? Thanks in advance.Read up on roles. Security works in RS via assigning user or groups to
roles. By default the administrators group of the server is in a role which
is why everything works for you. What I do is create local groups and to
that group I add domain users/groups. Then I assign that local group to a
role (this is done in Report Manager).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> Hi, I'm new to Reporting Services. However, I am sa on the reporting
> services database server and also admin rights on the server. I deployed
> my
> report to the reporting services server without errors, however someone
> else
> (not sa equivalent on the database, and not admin equivalent) cannot
> deploy
> because they get permission errors.
> Any ideas? Thanks in advance.|||Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
Solutions, but can you recommend any other courses?
Thanks.
"Bruce L-C [MVP]" wrote:
> Read up on roles. Security works in RS via assigning user or groups to
> roles. By default the administrators group of the server is in a role which
> is why everything works for you. What I do is create local groups and to
> that group I add domain users/groups. Then I assign that local group to a
> role (this is done in Report Manager).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
> > services database server and also admin rights on the server. I deployed
> > my
> > report to the reporting services server without errors, however someone
> > else
> > (not sa equivalent on the database, and not admin equivalent) cannot
> > deploy
> > because they get permission errors.
> >
> > Any ideas? Thanks in advance.
>
>|||Sorry. Not familiar with the course. I would recommend buying some books.
There are several good ones. Two I have are Hitchhiker's Guide to SQL Server
2000 Reporting Services and Microsoft Reporting Services In Action.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:058E276C-0DE6-4667-8D98-8B1226CA224D@.microsoft.com...
> Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
> Solutions, but can you recommend any other courses?
> Thanks.
> "Bruce L-C [MVP]" wrote:
>> Read up on roles. Security works in RS via assigning user or groups to
>> roles. By default the administrators group of the server is in a role
>> which
>> is why everything works for you. What I do is create local groups and to
>> that group I add domain users/groups. Then I assign that local group to a
>> role (this is done in Report Manager).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
>> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
>> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
>> > services database server and also admin rights on the server. I
>> > deployed
>> > my
>> > report to the reporting services server without errors, however someone
>> > else
>> > (not sa equivalent on the database, and not admin equivalent) cannot
>> > deploy
>> > because they get permission errors.
>> >
>> > Any ideas? Thanks in advance.
>>
Sunday, March 11, 2012
Deploying Reporting Services
Hi,
I've installed reporting services and reporting services sp2 on my local computer and I have admin rights on this computer.
But when I am trying to deploy reports in the report server, It is asking for login and password. If I give my machine login and password, it is not taking.
Even if type http://localhost/reportserver or http://localhost/reports it is giving an error saying
"CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\1bbf2d18\2968d42e\App_global.asax.2trocnva.dll' -- 'Access is denied. "
I've been trying to fix it for past few days but I couldn't.
Can anyone help me on this., Please.
Thanks in advance
Kusuma
Hi,
Check this link:http://blogs.msdn.com/astebner/archive/2005/04/08/406671.aspx
Thanks
|||The solution from this thread below worked for me. I had to add write access to the Network Service account to the c:\winnt\temp directory.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588823&SiteID=1
Deploying Reporting Services
Hi,
I've installed reporting services and reporting services sp2 on my local computer and I have admin rights on this computer.
But when I am trying to deploy reports in the report server, It is asking for login and password. If I give my machine login and password, it is not taking.
Even if type http://localhost/reportserver or http://localhost/reports it is giving an error saying
"CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\1bbf2d18\2968d42e\App_global.asax.2trocnva.dll' -- 'Access is denied. "
I've been trying to fix it for past few days but I couldn't.
Can anyone help me on this., Please.
Thanks in advance
Kusuma
Hi,
Check this link:http://blogs.msdn.com/astebner/archive/2005/04/08/406671.aspx
Thanks
|||The solution from this thread below worked for me. I had to add write access to the Network Service account to the c:\winnt\temp directory.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588823&SiteID=1
Tuesday, February 14, 2012
denying read rights to a dimension
Hi,
When you give read rights to a cube then the dimension gets read rights by default. Is there a way by which you can grant read rights to certain dimensions of that cube and deny the read rights to certain dimensions of that cube?
thanx.
In AS 2005, just create a new Role, and select what the users belonging to that role can see in the Dimension Data tab. If you select the "Deselect All Members" option, then the users of the role won't be able to see any data of that dimension.
In AS 2000, you have to add the dimension to the restricted dimension list when editing the proper role.
Hope this help,
Santi
|||Thanx. But then in that case I can still see the dimension. However if I dont want to show any of the attributes of a dimension, is it possible to hide the dimension completely..
Deny Anything to sa Account in SQL Express?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:88E5AC42-E241-4365-9D82-5D000664A2F3@.microsoft.com...
> Hello. My client is distributing an application that uses SQL Server 2005
> Express and mixed mode authentication. Most, if not all, of our users
> will
> be installing SQL Server 2005 Express only for our application.
> We want to be able to prevent ANY users (including sa) from being able to
> select, insert, create tables, views, etc. except through the application.
> Is this even possible?
> Thanks,
> JohnHello. My client is distributing an application that uses SQL Server 2005
Express and mixed mode authentication. Most, if not all, of our users will
be installing SQL Server 2005 Express only for our application.
We want to be able to prevent ANY users (including sa) from being able to
select, insert, create tables, views, etc. except through the application.
Is this even possible?
Thanks,
John|||No.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:88E5AC42-E241-4365-9D82-5D000664A2F3@.microsoft.com...
> Hello. My client is distributing an application that uses SQL Server 2005
> Express and mixed mode authentication. Most, if not all, of our users
> will
> be installing SQL Server 2005 Express only for our application.
> We want to be able to prevent ANY users (including sa) from being able to
> select, insert, create tables, views, etc. except through the application.
> Is this even possible?
> Thanks,
> John