Solved

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

Posted on 2004-09-07
9
1,704 Views
Last Modified: 2008-02-20
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
Comment
Question by:vnvk
  • 7
  • 2
9 Comments
 
LVL 10

Expert Comment

by:Jay Toops
ID: 11997449
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
 
LVL 7

Author Comment

by:vnvk
ID: 11997563
did that, authentication is given to anonymous user and the user used is iuser_machinename
0
 
LVL 7

Author Comment

by:vnvk
ID: 11997639
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 7

Author Comment

by:vnvk
ID: 11997723
This is after I changed to anonymous login
0
 
LVL 7

Author Comment

by:vnvk
ID: 11997777
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
 
LVL 10

Accepted Solution

by:
Jay Toops earned 500 total points
ID: 11997829
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
 
LVL 7

Author Comment

by:vnvk
ID: 11997958
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
 
LVL 7

Author Comment

by:vnvk
ID: 11997971
machine name access is working from the same system, but not other over intranet, where as ip address, its not working from anywhere
0
 
LVL 7

Author Comment

by:vnvk
ID: 11998202
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question