Solved

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

Posted on 2004-09-07
9
1,630 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
 
LVL 7

Author Comment

by:vnvk
ID: 11997723
This is after I changed to anonymous login
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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…
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…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

706 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now