DCSIMG
April 2012 - Posts - KMoraz's Sandbox

April 2012 - Posts

Friday, April 27, 2012 3:03 AM

TF31002 and TFS on SSL

I had an issue of TFS web access resulted with TF31002 error along with HTTP 404 response:

TF31002: Unable to connect to this Team Foundation Server: https://tfs/tfs. Team Foundation Server Url: https://tfs/tfs. Possible reasons for failure include: - The name, port number, or protocol for the Team Foundation Server is incorrect. - The Team Foundation Server is offline. - The password has expired or is incorrect. Technical information (for administrator): The request failed with HTTP status 404: Not Found.

The Problem

As indicated from the error, the TFS application tier DNS name cannot be resolved. In this case the server was configured with SSL only access, with HTTPS binding to a FQDN.

The Solution

Adding an explicit server name in the application tier configuration file has resolved the issue. Open for edit:

C:\Program Files\Microsoft Team Foundation Server 2010\Application Tier\Web Access\Web\web.config
Add the server FQDN address: 
<tfServers>
 <add name="https://tfs.company.com/tfs" />
</tfServers>
Posted by kmoraz | with no comments
תגים:,
Tuesday, April 03, 2012 9:47 PM

Importing Reports From SSRS 2008 R2 To SSRS 2008

When importing an RDL report from SSRS 2008 server to the newer SSRS 2008 R2 version, the server will automatically upgrade it to latest version. But when attempting to import the other way around it won’t work as the older server doesn’t recognize the newer format.

In order to successfully import an RDL from 2008 R2 to the previous SSRS 2008 version, you need to downgrade the RDL file format.

1. Change schema:

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" 
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">

2. Remove <rd:SecurityType> element under the <DataSources> element:

<rd:SecurityType>None</rd:SecurityType>

3. Remove <ReportSections> and <ReportSection> elements:

<ReportSections> 

<ReportSection>
…
 </ReportSection> 
</ReportSections>

4. Copy ReportServerUrl:
<rd:ReportServerUrl>http://sql.company.com/ReportServer</rd:ReportServerUrl>

Posted by kmoraz | with no comments
תגים:, , ,