Pages

Thursday, December 20, 2012

‘Unable to connect to the remote server’ error when try to open SQL reporting link

 

You may get an error while configuring the reporting service and opening the reporting service URL stating that ‘Unable to connect to the remote server’. This error normally visible when you change the default reporting DB name or reporting URL.

clip_image002

Solution

From the SQL server where you have reporting DBs configured,

  1. Go to the ReportServer folder [By default its C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer]
  2. Locate the file ‘rSreportServer.config’
    clip_image004
  3. Open ‘rSreportServer.config’ in notepad and search for ‘SecureConnectionLevel’ and set the value to “0”
    clip_image006
  4. Save the file and close it.
  5. Now try opening the URL it will be opening without any issue.
Posted by at
Labels:

6 comments:

  1. edjuncosOctober 19, 2013 at 4:19 AM

    Great! very helpfull thread !!!

    ReplyDelete
  2. GnawgnuNovember 11, 2013 at 6:27 AM

    Thanks, this was driving me up the wall on my cross hardware TFS upgrade.

    ReplyDelete
  3. AnonymousMarch 4, 2014 at 4:27 PM

    Excellent Tips... Its solved my time !! Thanks a million...

    ReplyDelete
  4. AnonymousJune 23, 2014 at 5:35 PM

    i save value as 0 but error still come.

    ReplyDelete
  5. AnonymousApril 1, 2015 at 12:02 AM

    Very helpful, thank you!

    ReplyDelete
  6. AnonymousJuly 20, 2015 at 4:53 PM

    thanks it was very helpful saved mu time

    ReplyDelete

Subscribe to: Post Comments (Atom)