rsAccessDenied and

I have installed Reporting Services on a production server that host a
website using SQL Express. I have set up RS in the RS configuration manager
and got green button all the way down
Requesting http://www.xx.dk/reports replies:
The request failed with HTTP status 400: Bad Request.
Requesting http://www.xx.dk/reportserver replies:
The permissions granted to user 'TF4\ms' are insufficient for performing
this operation. (rsAccessDenied)
Any idea what the problem might be ?
--
Paul SHello Paul,
Based on my research, please check the following settings:
1. Make sure you disable the Anynomous Access on IIS for the reporting
services virtual directory.
2. Make sure you enable Windows Authentication on IIS
3. Make sure you have use the rsconfig utility to connect to the correct
SQL Instance for the report server.
4. Make sure you are using a correct identity for the application pool the
reporting services using. Please try to use a domain account with local
admin privilage to have a check.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||1)
Anynomous Access is disabled for the reportServer dir. and the reports dir.
but not for the parent dir - the original dir for the website.
2)
Windows Authentication is enabled for the reports and the reportserver dir.
3)
I only have one - it's correct
4)
The application pool for both the ReportServer and the Report manager is
DefaultAppPool
ps. In database setup the credentials type is Service credentials
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> Based on my research, please check the following settings:
> 1. Make sure you disable the Anynomous Access on IIS for the reporting
> services virtual directory.
> 2. Make sure you enable Windows Authentication on IIS
> 3. Make sure you have use the rsconfig utility to connect to the correct
> SQL Instance for the report server.
> 4. Make sure you are using a correct identity for the application pool the
> reporting services using. Please try to use a domain account with local
> admin privilage to have a check.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Paul,
1. Please run the rsconfig utility to specify a new connection to the sql
server:
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
2. Please recreate an application pool for the report server and use a
domain account which have local admin privilage as the identity to have a
try.
Please let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei Lu
Your suggestions gave the follwing:
1)
No Reporting Services instance found on localhost.
2)
I created a new user with local admin rights and used him when I created a
new app pool for the reports server - the report manager still uses
DefaultAppPool.
Why is it talking about localhost - I'm not using localhost. The values
specifid in the RS Configuration manager for Report Server Virtual Directory
is:
Name: ReportServer, Website xxx
accessing http://www.xxx.dk/reports gives
The request failed with HTTP status 400: Bad Request.
acessing http://www.xxx.dk/reportserver still gives The permissions granted
to user 'TF4\ms' are insufficient for performing this operation.
(rsAccessDenied)|||Hello Paul,
I would like to get the RSWebApplication.config file and
rsreportserver.config file in the report manager and report server folder.
By default, these two folders is located at :C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\
Also, please send me the screenshot for the Configuration Tool. Make sure
you have a default instance installed in the server.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you. To get my real email addresss, please
remove the ONLINE in my display mail.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I've send you the information needed
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Paul,
From your rsreportserver.config file, I did not see the LogonUser
credential is applied. So please use the rsconfig utility to specify the
credential to connect to SQL Server Report Server.
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hello Wei
I get an error message saying
'No reporting services instance found on localhost'
when I run the rsconfig utility
I have been going through this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=143931&SiteID=1
but I have the folders mentioned.
Paul S
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> From your rsreportserver.config file, I did not see the LogonUser
> credential is applied. So please use the rsconfig utility to specify the
> credential to connect to SQL Server Report Server.
> rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>|||Hello Paul,
According to your email, I found that you are going to configure your
Express instance in your computer.
Please try the following:
rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
<SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Issuing that command was what gave me the
'No reporting services instance found on localhost'
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> According to your email, I found that you are going to configure your
> Express instance in your computer.
> Please try the following:
> rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
> <SAPASSWORD>
>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello Paul,
I would like to know how many instances you installed in the machine.
Pleas run the MPS Report .
--
a. Download MPSReport tool from below URL:
<
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
15706/MPSRPT_SETUPPerf.EXE>
b. Execute the tool on the computer, and if you are prompted "Include the
MSINFO32 report?", please type Y.
c. Please send the result file (CAB file) to me
To reach me, please remove the ONLINE in my display email address.
For detailed information about the MPS Report Tools, please refer to the
following link:
Microsoft Product Support's Reporting Tools
<http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F
-88B7-F9C79B7306C0&displaylang=en>
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi
I have just send you the described CAB file
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>