?
Solved

SQL Reporting Services 2008 Authentication Prompt

Posted on 2011-02-18
4
Medium Priority
?
709 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 2000 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

770 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