The underlying connection was closed... with report selection
This is happening in SCE 2010 on Server 2003 with SQL 2008 Express. Whenever I select a report, I get this error: "System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
SCE and SQL with reporting services are all on the same server.
I've tried importing the certificates but that didn't help. I can use a remote console but it doesn't display any reports in the reporting section.
Doug
February 28th, 2011 4:27pm
I've already tried importing the certificates, on the server, with no resolution of the issue. I'm doing all of the troubleshooting on the server to eliminate any potential workstation related issues and everything is installed on the same server.
I've verified that the cert hash in the registry, admin site, and local certs match, we're not utilizing a proxy, and I've checked the certificates and verified that the WSUSSSL.cer is using the SCE server FQDN (server.domain.local) and not the NETBIOS name.
Free Windows Admin Tool Kit Click here and download it now
March 1st, 2011 8:15pm
Hi Doug,
Please check if any information as below will help:
http://social.technet.microsoft.com/Forums/en-US/systemcenterrom/thread/98a03b37-40ca-4964-8630-bece685c0fc0#8ca36d85-c4db-470f-86f9-e90c87e82ecd
http://social.technet.microsoft.com/Forums/en-US/systemcenterrom/thread/9dd23288-fc8d-44cd-9af0-7d7cd029ab2d
The above threads discussed the similar issue.Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
March 1st, 2011 9:04pm
Does anyone have any ideas? I'd like to get the reports working as quickly as possible since I'm evaluating SCE prior to purchase and I need to see the reporting functionality.
Thanks
Free Windows Admin Tool Kit Click here and download it now
March 7th, 2011 7:46pm
WSUSSSLCert:
Personal
Trusted Root Cert. Authorities
Enterprise Trust
WSUSCodeSigningCert:
Trusted Root Cert. Authorities
Trusted Publishers
Third-party root cert. Authorities
WSUS
March 7th, 2011 8:06pm
what stores are the certs residing in?Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
My Blog Site: http://tmagnuson.wordpress.com
Free Windows Admin Tool Kit Click here and download it now
March 7th, 2011 8:30pm