Reportbuilder 3 cannot connect to Reportserver 2008 R2
Hi all! Spent almost a week with this problem: Report Builder 3.0 cannot connect to Reporting Services 2008 R2 (win srv 2008 r2) from remote client (win xp). It hangs until I get a timeout or it freezes. Address is correct http://servername/reportserver or http://ipaddress/reportserver Connecting through Internet Explorer works fine. There are no security issues, all rights are set properly. All ports on database server are open. Additional Information: Also connecting to Reporting Services through Management Studio doesn't work. But all other database services (intergration servieces,...) can be reached through SSMS. pls help! thx rudi
November 30th, 2010 4:45am
What is the error that you get when you try to connect from Managment Studio? Does that freeze too? Also have you checked the Reporting Services Configuration tool. Does everything seem fine there? Finally check the Report server log. If you provide some error messages that you are getting it will give some clues.
November 30th, 2010 9:33am
Hi RMehta, Error message from SSMS is (translated from German) like "Connection to 'Servername' cannot be established. Maybe URL is not valid .....". Reporting Services Configuration is all ok. In the report server log I can find this message: extensionfactory!ReportServer_0-9!a60!11/30/2010-13:42:38:: e ERROR: Exception caught instantiating SQLPDW report server extension: System.Reflection.TargetInvocationException: Ein Aufrufziel hat einen Ausnahmefehler verursacht. ---> System.ArgumentException: Der angeforderte .Net Framework-Datenprovider kann nicht gefunden werden. Er ist ggf. nicht installiert. bei System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) bei Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper..ctor() thx rudi
November 30th, 2010 10:00am
I wish I had paid more attention to my Greman launguage class in school... Seems to be an issue with the Reporting Services configuration. I have seen this issue when we have some kind of non standard install. When you built the server did you a default install? If it is an option I would un-install reporting Services and re-install it.
November 30th, 2010 12:59pm
There are no security issues, all rights are set properly. All ports on database server are open. Hi rudi, How do you know this is not security issue? To try to solve this issue, follow my suggestions: 1. On the report sever, open rsreportserver.config file, then remove/comment RSWindowsNegotiate and ensure RSWindowsNTLM is specified. 2. Logon report manager, explicitly assign content manager (just for test) to your client account, then try to connect the report server via SSMS or report builder 3.0 to see if it works. thanks, Jerry
December 2nd, 2010 9:07pm
Hi rudi, have you solved the problem? I have a similar problem, but without errors in the log-file. Oliver
December 7th, 2010 8:07am
thx jerry! Was sick for 1 week, so sorry for this late reply. Followed Your suggestions but no changes. thx rudi
December 9th, 2010 3:02am