• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1722
  • Last Modified:

problem in autheticating SQL reporting services...urgent....

Hi,

Recently, I was given an application,  and then asked to work on reports in SQL reporting services.
WEll, I folowed the steps given by Ms as it is in the guidelines and installed the application successfully ( I think so for now atleast).

Now, when I try to access the application over intranet, I get a prompt for authentication and then its failing. when I access the site from the same system, then, Reports folder working fine in default site, atleast I can see the data. But, the ReportServer is not getting displayed. I cant see the contents of Reports folder from the other websites where I mapped it.

Can anyone help me out? Please :(

I should prepare 4 reports by week end, after learning how to work.

And I am sure that I would be popping up many qestins in coming few days.

Thanks in advance

0
vnvk
Asked:
vnvk
  • 7
  • 2
1 Solution
 
Jay ToopsCommented:
it sounds to me like this is an authentication problem with the configuration of
the Webserver.

Go to IIS administrator and check the security settings for the reporting directory.
you might want to turn off domain authentication.

Jay
0
 
vnvkAuthor Commented:
did that, authentication is given to anonymous user and the user used is iuser_machinename
0
 
vnvkAuthor Commented:
eror thats coming when I try to authenticate:

You are not authorized to view this page
You do not have permission to view this directory or page due to the access control list (ACL) that is configured for this resource on the Web server.
--------------------------------------------------------------------------------

Please try the following:

Contact the Web site administrator if you believe you should be able to view this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the requested resource.
Internet Information Services (IIS)

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Go to Microsoft Product Support Services and perform a title search for the words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled About Security, Access Control, and About Custom Error Messages.
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
vnvkAuthor Commented:
This is after I changed to anonymous login
0
 
vnvkAuthor Commented:
earlier, its this issue:
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials that you supplied.
--------------------------------------------------------------------------------

Please try the following:

Contact the Web site administrator if you believe you should be able to view this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Go to Microsoft Product Support Services and perform a title search for the words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Authentication, Access Control, and About Custom Error Messages.  
0
 
Jay ToopsCommented:
This is a variant of the same problem .. the "anonymous" user
or whatever users is used by IIS has to be granted permission
to that FOLDER on the hard disk.

so go in to folder properites. and make sure you propagate the
permissions to the subdirectories.

Jay
0
 
vnvkAuthor Commented:
No Use. I am going through other aticles on net. But would be glad if I can get some quick assistance.

its workin fine when I run it like

http//localhost/reports

but when I say

http://10.0.3.98/reports 

or http://machinename/reports

its failing
same with Reporting services
0
 
vnvkAuthor Commented:
machine name access is working from the same system, but not other over intranet, where as ip address, its not working from anywhere
0
 
vnvkAuthor Commented:
thanks to your suggestions and the suggestions found at

http://groups.google.com/groups?q=authentication++intranet+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&group=microsoft.public.sqlserver.reportingsvcs&c2coff=1&selm=OsfVBXSOEHA.3964%40TK2MSFTNGP10.phx.gbl&rnum=5

I am able to browse the directory.

I will get back if I have any issues, with a new question. Posting the info here, as it might be of use to others.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now