Solved

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

Posted on 2004-09-07
9
1,706 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

734 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