Solved

SQL Reporting Services 2008 Authentication Prompt

Posted on 2011-02-18
4
703 Views
Last Modified: 2012-05-11
We recently setup reporting services on a 2008 SQL box.  Previously we had this installed on 2005.  All reports are running fine but I continually get prompted for authentication when connecting to the report server.  I know that anonymous access has been taken away in 2008 and it no longer uses IIS.  However I am NOT an anonymous user anyway so I'm not sure why it can't get the credentials from my current session.  Is there a configuration option that I might have missed?
0
Comment
Question by:radpat
[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
  • 3
4 Comments
 
LVL 13

Expert Comment

by:Jesus Rodriguez
ID: 34928040
Chechk this links
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/23c5daa0-3232-4e8c-89c9-4526960c9d14http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/32563/SSRS-Security

How did you use your Report server?? like this http://my-rs/reports 
or http://my-rs.mydomain.com/reports like this. I suggest to try to use it like the first option to see if it solve your problem
0
 
LVL 13

Accepted Solution

by:
Jesus Rodriguez earned 500 total points
ID: 34928046
0
 
LVL 13

Expert Comment

by:Jesus Rodriguez
ID: 34928070
0
 
LVL 3

Author Comment

by:radpat
ID: 34928382
Thanks for the push in the right direction.  All I needed to do was add the server to our local Intranet zone.  Since this was a new server in a separate domain it was not yet part of that zone.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 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