Management reporting and documentation
Post Reply
J2Harrell
Lurker
Posts: 2
Liked: never
Joined: Dec 09, 2010 8:37 pm
Full Name: Jim Harrell
Contact:

Reporter Cannot connect to SSRS

Post by J2Harrell »

Reporting jobs fail with the error "Unable to connect to the Microsoft Reporting Services server." However, when I go to configuration - settings - ssrs server and test the connection, it passes just fine. I can also connect manually to the SSRS server URL from a web browser.
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Reporter Cannot connect to SSRS

Post by Vitaliy S. »

Hello Jim,

When you connect to SSRS via browser, are you able to generate any report? By the way, do you have any error messages in Reporter's Service log files?

Thanks!
J2Harrell
Lurker
Posts: 2
Liked: never
Joined: Dec 09, 2010 8:37 pm
Full Name: Jim Harrell
Contact:

Re: Reporter Cannot connect to SSRS

Post by J2Harrell »

I can connect to SSRS via the browser and generate a report. Also, I can connect to the SQL instance via the SQL Management Studio.

Here is what is in the log that was emailed me:

12/10/2010 8:42:00 AM [info] : Getting 'Capacity Planning Test 1' report...
12/10/2010 8:42:00 AM [error] : Unable to connect to the Microsoft Reporting Services server

Are there other logs that I can check?

Thanks,
Jim
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Reporter Cannot connect to SSRS

Post by Vitaliy S. »

I think it would be best if you could contact our support team, as all the settings seem fine to me... just to make sure, have you used the same user account while connecting to SSRS through Reporter?
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest