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
Solved

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

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

 
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

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.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

860 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