Showing posts with label rights. Show all posts
Showing posts with label rights. Show all posts

Thursday, March 22, 2012

Deployment problem - Insufficient Rights

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.
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

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.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?

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,
> 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