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 » Dec 09, 2010 8:52 pm

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.
Product Manager
Posts: 23214
Liked: 1608 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Reporter Cannot connect to SSRS

Post by Vitaliy S. » Dec 09, 2010 10:06 pm

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 » Dec 10, 2010 1:43 pm

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.
Product Manager
Posts: 23214
Liked: 1608 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Reporter Cannot connect to SSRS

Post by Vitaliy S. » Dec 10, 2010 2:17 pm

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 2 guests