Solved

SQL Reporting Services 2008 Authentication Prompt

Posted on 2011-02-18
4
699 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
  • 3
4 Comments
 
LVL 13

Expert Comment

by:Jesus Rodriguez
Comment Utility
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
Comment Utility
0
 
LVL 13

Expert Comment

by:Jesus Rodriguez
Comment Utility
0
 
LVL 3

Author Comment

by:radpat
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
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…
This video discusses moving either the default database or any database to a new volume.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

771 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

14 Experts available now in Live!

Get 1:1 Help Now