SSRS 2008 - Unable to connect to remote server
Win2k3 R2 SP2/SQL Server 2008 instance with SSRS/Visual Studio 2008I installed SQL 2008 and SSRS with native mode default configuration.All SQL 2008 services are running under "NT Authority\Network Service" account.When i try to deploy a new report, I get the "Unable to connect to remote server" error.The deploy operation creates empty folders on the web server (hosted by the SQL Server 2008 service)for e.g. my instance name is <machinename>$sql2008. i configured the WebService URL and the Reports Manager URL to port 85the deploy from VS creates ssrs2008Test folder and a Shared Data Sources folder in the following virtual directory - Report Manager URL: http://<machinename>:85/Reports_SQL2008/ - Web Service URL: http://<machinename>:85/ReportServer_SQL2008however these folders are empty w/ no .rdl or .rds file. and i get the "Unable to connect to remote server" error in Visual Studio 2008 when i deploy it.is there something else i have to tweak in either the SQL Server/SSRS Configuration Manager or the Windows Server Settings(like port settings or group policy) to get the reports to work?thanks-vt
August 28th, 2008 11:28pm

Are you able to access these URLs from IE.
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2008 1:14am

yes
August 29th, 2008 1:16am

Check this out : http://patricknielsen.net/2008/03/reporting-services-unable-to-connect-to.html Might help.. Regards... Girija Shankar
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2008 1:31am

nope i still havent gotten it to deploy. here's my config settings snippetfor SQL 2008 Reporting Services.The Virtual Directory looks okay to me. i'm able to access (from IE)the sub folder for my test projectthat gets created. (via the SSRS Report Manager app) <URLReservations><Application><Name>ReportServerWebService</Name><VirtualDirectory>ReportServer_SQL2008</VirtualDirectory><URLs><URL><UrlString>http://+:85</UrlString><AccountSid>[xyzwhatever]</AccountSid><AccountName>NT AUTHORITY\NETWORK SERVICE</AccountName></URL></URLs></Application><Application><Name>ReportManager</Name><VirtualDirectory>Reports_SQL2008</VirtualDirectory><URLs><URL><UrlString>http://+:85</UrlString><AccountSid>[xyzwhatever]</AccountSid><AccountName>NT AUTHORITY\NETWORK SERVICE</AccountName></URL></URLs></Application></URLReservations>
August 29th, 2008 2:06am

I am getting the exact same error too. My site was set to port 82 and my folder and data source get created but not the report. I can navigate to the Report Manager but can not even manually upload an rdl either, i just get a page cannot be displayed.
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2008 2:25am

Do you see any errors in the report server log file when this problem occurs. Also whatis the value of the"SecureConnectionLevel" property in the rsreportserver.config file.
August 29th, 2008 10:50am

SecureConnectionLevel = 2 From logFile: appdomainmanager!DefaultDomain!740!08/29/2008-08:00:30:: i INFO: Appdomain:6 ReportServer_SQL2008_0-3-128644956308203194 started.appdomainmanager!ReportServer_0-3!740!08/29/2008-08:00:31:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/ReportServer_SQL2008.httpruntime!ReportServer_0-3!740!08/29/2008-08:00:31:: i INFO: Report Builder manifest file C:\Program Files\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\ReportServer\ReportBuilder\ReportBuilder_2_0_0_0\MSReportBuilder.exe.manifest not found.appdomainmanager!DefaultDomain!740!08/29/2008-08:00:31:: i INFO: Appdomain:6 ReportServer_SQL2008_0-3-128644956308203194 initialized (#2).webserver!ReportServer_0-3!740!08/29/2008-08:00:37:: i INFO: Reporting Web Server startedresourceutilities!ReportServer_0-3!740!08/29/2008-08:00:37:: i INFO: Reporting Services starting SKU: Developerresourceutilities!ReportServer_0-3!740!08/29/2008-08:00:37:: i INFO: Evaluation copy: 0 days leftresourceutilities!ReportServer_0-3!740!08/29/2008-08:00:37:: i INFO: Running on 1 physical processors, 4 logical processorsrunningjobs!ReportServer_0-3!740!08/29/2008-08:00:37:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 secondsrunningjobs!ReportServer_0-3!740!08/29/2008-08:00:37:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 secondsrunningjobs!ReportServer_0-3!740!08/29/2008-08:00:37:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 secondslibrary!ReportServer_0-3!1588!08/29/2008-08:00:38:: Call to GetItemTypeAction(/ssrs2008Test).library!ReportServer_0-3!1588!08/29/2008-08:00:39:: i INFO: Catalog SQL Server Edition = Developercrypto!ReportServer_0-3!1588!08/29/2008-08:00:39:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICEcrypto!ReportServer_0-3!1588!08/29/2008-08:00:39:: i INFO: Exporting public keycrypto!ReportServer_0-3!1588!08/29/2008-08:00:39:: i INFO: Performing sku validationcrypto!ReportServer_0-3!1588!08/29/2008-08:00:39:: i INFO: Importing existing encryption keylibrary!ReportServer_0-3!740!08/29/2008-08:00:39:: Call to GetItemTypeAction(/Data Sources).library!ReportServer_0-3!1588!08/29/2008-08:00:39:: Call to GetItemTypeAction(/Data Sources/masterDB).library!ReportServer_0-3!740!08/29/2008-08:00:40:: Call to GetItemTypeAction(/ssrs2008Test/sp_who2).
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2008 6:05pm

Try changing the SecureConnectionLevel to 0 and see if it works.
August 29th, 2008 8:08pm

Bingo! that fixed it. thank you very much.
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2008 9:35pm

Good to know that it worked. Please mark the thread as answered.
August 29th, 2008 11:08pm

That you for this sweet, sweet config setting. It has made four days of trying everything complete my week with a working environment between SSRS and Sharepoint. Thank you for posting this.
Free Windows Admin Tool Kit Click here and download it now
December 5th, 2009 1:22am

Hallelluya!!! I was about to shoot my brains out on this very problem! Spent 8hrs all day "wracking" my brain on this and un-installing/ re-installing SSRS and RSAddonX64. Geez wish it was better documented. Anyway- my Report Server/2008 w/integrated Sharepoint sites are up and running and screaming thanks to this. Thank you ! Wish there was a tip jar so I could give Neeraja a free lunch ticket ! : ) Here's the default path where that file is located (assuming you accept the SQL2008 default install defaults): C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config
January 4th, 2010 9:38am

Thanks you very much... it's working for me....
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2010 8:34am

Thanks a lot it is very useful!! Regards, Eshwar.
March 24th, 2010 9:34am

Changed the SecureConnectionLevel to 0 after trying everything else and that worked for me. I had mine connected as network service before swithcing to local system and that might be the root cause. Thanks Neeraja Eric Ashihundu
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2011 8:30pm

It works for me too. thanks Neeraja
June 8th, 2011 5:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics