|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:31 AM
Points: 101,
Visits: 305
|
|
Over the weekend we change the IP for our SRS webFarm server. from 999.999.0.17 to 999.999.10.17.
The reports are still rendering fine, but I can no longer get to the Report manager page.
https://reporting.???????.com/reporting/Pages/Folder.aspx
I'm getting this error on the screen: "The underlying connection was closed: Could not establish secure channel for SSL/TLS
Can anyone Help me? Yes, the certificate is still valid and the computer clock time is correct. I have also tried IISReset and Rebooted both servers.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:31 AM
Points: 101,
Visits: 305
|
|
I fixed this problem with the following DOS commands: cd \program files\microsoft SQL Server\80\tools\binn C:\Program Files\Microsoft SQL Server\80\Tools\Binn>RSConfig.exe -c -s SQLReport -d ReportServer -a windows -u "Domain\UserName" -p "PassWordHere"
The "-a" had me stuck until I figured out that my user was a window's domain user. The two options for this are: -a window -a SQL
Also need to Restart ReportService Window service Don't know if this was needed but I also ran "IISReset" at the DOS Prompt.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, April 12, 2011 4:41 AM
Points: 112,
Visits: 83
|
|
| Configure report server so that it does not attempt to detect a local SSL certificate by setting the SecureConnectionLevel to 0 in the RSReportServer.config file.
|
|
|
|