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

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

DENY permission

Hi ,
i have set up to db roles "Admin" which have been
granted select , delete , insert , update
and "test" which has been granted select and DENY update
i have set up a user "user1" account which is part of
the "Admin" and "test" db role.
In this case will "user1" be denied the ability to
UPDATE ?
AND if i also set up user1 as a system administrator
fixed server role besides the 2 db role above , will the
DENY update has any effect on user1 ?
thks & rdgs
Hi,
Answer to your queries:-
In this case will "user1" be denied the ability to UPDATE ?
Ans: - Yes, User will not be able to select and update.
if i also set up user1 as a system administrator fixed server role besides
the 2 db role above , will the
DENY update has any effect on user1 ?
Ans: - Sysadmin role will override all the roles or Deny permissions. The
user with SYADMIN role can do any functionality in the SQL server
as well as all databases.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:0d4a01c484cd$c77bfbd0$a301280a@.phx.gbl...
> Hi ,
> i have set up to db roles "Admin" which have been
> granted select , delete , insert , update
> and "test" which has been granted select and DENY update
> i have set up a user "user1" account which is part of
> the "Admin" and "test" db role.
> In this case will "user1" be denied the ability to
> UPDATE ?
> AND if i also set up user1 as a system administrator
> fixed server role besides the 2 db role above , will the
> DENY update has any effect on user1 ?
> thks & rdgs
|||IN addition permissions are cumulative across all of the roles, etc which
apply to a user, THEN subtract out all of the DENY permissions... ( Deny
overrides a grant.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:0d4a01c484cd$c77bfbd0$a301280a@.phx.gbl...
> Hi ,
> i have set up to db roles "Admin" which have been
> granted select , delete , insert , update
> and "test" which has been granted select and DENY update
> i have set up a user "user1" account which is part of
> the "Admin" and "test" db role.
> In this case will "user1" be denied the ability to
> UPDATE ?
> AND if i also set up user1 as a system administrator
> fixed server role besides the 2 db role above , will the
> DENY update has any effect on user1 ?
> thks & rdgs

DENY permission

Hi ,
i have set up to db roles "Admin" which have been
granted select , delete , insert , update
and "test" which has been granted select and DENY update
i have set up a user "user1" account which is part of
the "Admin" and "test" db role.
In this case will "user1" be denied the ability to
UPDATE ?
AND if i also set up user1 as a system administrator
fixed server role besides the 2 db role above , will the
DENY update has any effect on user1 ?
thks & rdgsHi,
Answer to your queries:-
In this case will "user1" be denied the ability to UPDATE ?
Ans: - Yes, User will not be able to select and update.
if i also set up user1 as a system administrator fixed server role besides
the 2 db role above , will the
DENY update has any effect on user1 ?
Ans: - Sysadmin role will override all the roles or Deny permissions. The
user with SYADMIN role can do any functionality in the SQL server
as well as all databases.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:0d4a01c484cd$c77bfbd0$a301280a@.phx.gbl...
> Hi ,
> i have set up to db roles "Admin" which have been
> granted select , delete , insert , update
> and "test" which has been granted select and DENY update
> i have set up a user "user1" account which is part of
> the "Admin" and "test" db role.
> In this case will "user1" be denied the ability to
> UPDATE ?
> AND if i also set up user1 as a system administrator
> fixed server role besides the 2 db role above , will the
> DENY update has any effect on user1 ?
> thks & rdgs|||IN addition permissions are cumulative across all of the roles, etc which
apply to a user, THEN subtract out all of the DENY permissions... ( Deny
overrides a grant.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:0d4a01c484cd$c77bfbd0$a301280a@.phx.gbl...
> Hi ,
> i have set up to db roles "Admin" which have been
> granted select , delete , insert , update
> and "test" which has been granted select and DENY update
> i have set up a user "user1" account which is part of
> the "Admin" and "test" db role.
> In this case will "user1" be denied the ability to
> UPDATE ?
> AND if i also set up user1 as a system administrator
> fixed server role besides the 2 db role above , will the
> DENY update has any effect on user1 ?
> thks & rdgs

DENY permission

Hi ,
i have set up to db roles "Admin" which have been
granted select , delete , insert , update
and "test" which has been granted select and DENY update
i have set up a user "user1" account which is part of
the "Admin" and "test" db role.
In this case will "user1" be denied the ability to
UPDATE ?
AND if i also set up user1 as a system administrator
fixed server role besides the 2 db role above , will the
DENY update has any effect on user1 ?
thks & rdgsHi,
Answer to your queries:-
In this case will "user1" be denied the ability to UPDATE ?
Ans: - Yes, User will not be able to select and update.
if i also set up user1 as a system administrator fixed server role besides
the 2 db role above , will the
DENY update has any effect on user1 ?
Ans: - Sysadmin role will override all the roles or Deny permissions. The
user with SYADMIN role can do any functionality in the SQL server
as well as all databases.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:0d4a01c484cd$c77bfbd0$a301280a@.phx.gbl...
> Hi ,
> i have set up to db roles "Admin" which have been
> granted select , delete , insert , update
> and "test" which has been granted select and DENY update
> i have set up a user "user1" account which is part of
> the "Admin" and "test" db role.
> In this case will "user1" be denied the ability to
> UPDATE ?
> AND if i also set up user1 as a system administrator
> fixed server role besides the 2 db role above , will the
> DENY update has any effect on user1 ?
> thks & rdgs|||IN addition permissions are cumulative across all of the roles, etc which
apply to a user, THEN subtract out all of the DENY permissions... ( Deny
overrides a grant.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:0d4a01c484cd$c77bfbd0$a301280a@.phx.gbl...
> Hi ,
> i have set up to db roles "Admin" which have been
> granted select , delete , insert , update
> and "test" which has been granted select and DENY update
> i have set up a user "user1" account which is part of
> the "Admin" and "test" db role.
> In this case will "user1" be denied the ability to
> UPDATE ?
> AND if i also set up user1 as a system administrator
> fixed server role besides the 2 db role above , will the
> DENY update has any effect on user1 ?
> thks & rdgs