New SSRS 2008 R2 installation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » New SSRS 2008 R2 installation

New SSRS 2008 R2 installation

Rate Topic

Display Mode

Topic Options

Author

Message

HildaJ

Posted Wednesday, October 24, 2012 7:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 104, Visits: 287

I just finished installating SSRS 2008 R2 on a brand new machine. I have the ReportServer databases on that same system (System A) but I'm connecting to System B for the reports data. I'm getting the following error when running the report, the data source that I'm using is set to use windows credential. Just to mention we have another server System C which is also configure as SSRS and connects to System B for the data and is working properly.

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dsULDBDev'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Thanks.

Post #1376497

Kenneth.Fisher

Posted Wednesday, October 24, 2012 8:19 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 7:53 PM
Points: 3,367, Visits: 1,577

Sounds like a classic "double hop" problem. Read this and see if it helps:

http://www.sqlservercentral.com/articles/Double+Hop/76743/

Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com

Post #1376510

HildaJ

Posted Wednesday, October 24, 2012 8:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 104, Visits: 287

Thanks I'll give it a try. I also would like to point out that when I go to the http://servername/ReportServer the connection works fine. I get really confused on this one.

Post #1376520

HildaJ

Posted Wednesday, October 24, 2012 12:48 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 104, Visits: 287

Got it working using a sql account and I believe we were getting the connection problem because we are reporting services is using RSWindowsNTLM. So we got all the reports running perfectly, but now I'd like to ask another question. Every time a user connects to the report manager either from the local machine or from another machine a windows login prompt shows up. I can put my login credentials and it works fine but I would like to pass this window and not have the users type their user name and password. Do anybody know how to bypass this window?

thanks.

Post #1376633

Joie Andrew

Posted Wednesday, October 24, 2012 2:28 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:10 AM
Points: 578, Visits: 1,107

I agree that it sounds like a double-hop issue. You can either do what you did, and explicitly define the account that will connect to your data source, or setup Kerberos.

Joie Andrew
"Since 1982"

Post #1376671

« Prev Topic | Next Topic »

Permissions