SQL Reporting Services error causing my DPM 2010 install to fail
Home  » Data Protection Mgr  » SQL Reporting Services error causing my DPM 2010 install to fail

SQL Reporting Services error causing my DPM 2010 install to fail
Posted: Sat, Jan 23, 2010 1:04 PM :: Rank: 0
Author
Points: 20757
Level: System Center Expert

 I just tried to install DPM  2010 beta. I met all requirements and allowed installer to install the SQL 2008 version included with DPM. DPM install fails do to an issue with SRS installed by DPM. 

"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

I found this

http://www.sqlservercentral.com/Forums/Topic522201-162-1.aspx

and this 

http://social.technet.microsoft.com/Forums/en-GB/systemcenterdeployment/thread/597c668a-f537-414a-a2b5-6a4e44fa64c9

but neither solved my issue.

Any thoughts on other possible solutions? 

Reply  
Report Abuse
RE: SQL Reporting Services error causing my DPM 2010 install to fail
Posted: Sat, Jan 23, 2010 4:46 PM :: Rank: 0
Author
Points: 2731
Level: System Center Specialist

Hey Tommy,

This is a pretty generic error unfortunately, is there an associated entry in the event log with some more detail?

David

Reply  
Report Abuse
RE: SQL Reporting Services error causing my DPM 2010 install to fail
Posted: Sun, Jan 24, 2010 11:17 AM :: Rank: 0
Author
Points: 20757
Level: System Center Expert

 You nailed it. After posting, I did finally see a more detailed event relating to SRS 2008 database access, although just now saw this and not yet sure what the issue is

Event ID 107:

Source: Report Server Windows Service

Description: Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

I'll have a  go at some research and testing to see why I cannot connect, and then back to you in a bit. Thanks.

Reply  
Report Abuse
RE: SQL Reporting Services error causing my DPM 2010 install to fail
Posted: Sun, Jan 24, 2010 2:37 PM :: Rank: 0
Author
Points: 29130
Level: System Center Expert

SQL 2008 is a bit tricky in that it's default can be a bit "too secure" (if there is such a thing). If you've eliminated the SecureBindings issue we see on SQL 2008 (and it seems you have by the articles you've checked), you may also want to run the Reporting Service Configuration (on the Start Menu) to make sure databases are present and accessible to the security context used by your Reporting Services service.

Reply  
Report Abuse

Home  » Data Protection Mgr  » SQL Reporting Services error causing my DPM 2010 install to fail
Tag Cloud
Quick Links
Top Contributors
Pete Zerger
Points: 29130
Level: System Center Expert
Simon Skinner
Points: 24529
Level: System Center Expert
Tommy Gunn
Points: 20757
Level: System Center Expert
Stefan Koell
Points: 12514
Level: System Center Expert
MadHatter
Points: 11676
Level: System Center Expert