I recent installed a named instance of SSRS 2005 on a remote server. The server has a side by side install of SSRS 2000 and SSRS 2005, with the SSRS 2005 being a named instance. The server also has SSL and MS Sharepoint Portal Server installed.
When I try and connect to the SSRS 2005 instance with my client install of Mangement Studio, I get the error message:
"The underlying connection was closed: Could not establish a trust relationship for the SSL/TLS secure channel. (System.Web.Services)
Additional Information: The remote certificate is invalid according to the validation procedure. (System)."
Obviously, this is a SLL issue, but, not being a security guru, I have no clue on how to fix this. I do know the certificate is valid, not expired and properly working. Both installs of SSRS are set up using the SSL certificate. Also, I am not connecting to SSIS with Management Studio, as I heard there is a bug connecting to both SSRS and SSIS at the same time.
Anyone have any ideas
Thanks!!
Jeff
Cannot connect to remote SSRS instance with SSMS
PaulSullivan
Can you connect to https://<CN name in cert>/reportserver$instancename locally or remotely Make sure you have correctly set the report server urls in your report server and manager config files. The urls should be in the same format.
http://blogs.msdn.com/bimusings/archive/2006/03/06/544856.aspx#621163
http://msdn2.microsoft.com/en-us/library/ms188133(SQL.90).aspx
TracyWIII
Yes, I have the URLs set correctly in the config files.
I am not sure how your reply has anything to do with connecting to the reporting server with SSMS. I can see where your answer will affect connecting with Internet Explorer, but not SSMS.
Can anyone else help please
Thanks,
Jeff
Davedub