Friday, May 07, 2010

Error on SQL Server Reporting Services for Team Foundation Server 2010

If you are installing a Reporting Services 2008R2 instance that is going to be used as report repository for TFS 2010, you may find this error:

TFxxxxxx: SQL Server Reporting Services is configured to require a secure connection, however no HTTPS URL is configured with a valid certificate


If you want to use certificates, just request a new one an configure it, but if you don’t want to use SSL you can follow these steps to get over this error:

 

  1. First remove the SSL binding from the report server using the Reporting Services Configuration Manager
  2. Navigate to your report server folder (by default MSRS10.MSSQLSERVER\Reporting Services\ReportServer), open the rsreportserver.config file and locate the entry named SecureConnectionLevel and set its value to 0
  3. Now you can run the configuration checker and the error will be gone.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

No comments:

SQL Server 2016 Stretch Databases

El SQL Server Stretch Database permite que los datos históricos o de bitácoras puedan ser movidos hacia Azure, específicamente permite mover...