Manual backups also fail. A crash dump is created. I stumbled across this thread http://www.sqlservercentral.com/Forums/Topic1588898-3411-2.aspx. My issue appears similar. I am running 2014 RTM (no CU). I have...

You can download BIDS free:

http://www.microsoft.com/en-us/download/details.aspx?id=42313

Phil.

This is bugging me now! The certificate name matches the server name so why will only <Add Key="SecureConnectionLevel" Value="0"/> function?

Report Server Web Service Site Identification: SSL Certificate = SQL-SERVER-NAME.

IE displays...

I amended RSReportServer.config file.

I have changed line:

I am now able to connect. I am not sure why SSL connection was failing as the cert referenced...

Thanks for the replies. It is a clean install.

Phil.

Thanks Ed.

Phil.

Hi Gail. I guess I am on the naughty step regards bad coding and a distinct lack of understanding:)

University put me off of programming and aged me by 10 years,...

Hi Dwain, thanks for the link. I may need a lobotomy to implement 🙂

Phil.

Hi Phil. The report does not pose much of a performance hit although I agree it is not the best way to write code (limited by ability in this instance...

It would appear I cannot have multiple selections for @status due to the expected Boolean expression.

CASE WHEN @status = 'C' AND ecn.FinishingEffectivityDate >=@StartDate AND ecn.FinishingEffectivityDate<=@EndDate THEN...

Hi. The IN was used as the parameter in the report accepts multiple values. Although not ideal regards performance it was a quick and dirty way to deliver the multi...

Thanks for your quick response.

WHERE

ecnt.EngineeringChangeNoteTypeId IN (@ECNType)

AND ecn.SystemType IN (@Status)

CASE WHEN @status = 'C' AND ecn.FinishingEffectivityDate >=@StartDate AND ecn.FinishingEffectivityDate<=@EndDate THEN 1

WHEN @status !=...

I am CONFUSED! I am unclear how Web Service URL and Report Manger URL interact and how SSRS uses certificates.

I managed to get past error "The underlying connection was closed:...

Thanks for the heads up on IIS, that explains that! As far as I am aware I am not using SSL or a certificate for SSRS? Reporting Services Configuration Manager...

Hi. Has anyone else come across error "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." when browsing the reporting manager URL?

Thanks,

Phil.