Importing Reports From SSRS 2008 R2 To SSRS 2008

Tuesday, April 3, 2012

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: ...
no comments

TFS 2010 Server Domain and Database Move – Command Summary

Tuesday, March 6, 2012

cd "%PROGRAMFILES%\Microsoft Team Foundation Server 2010\Tools" :::::: BRING TFS OFFLINE TfsServiceControl quiesce iisreset /stop :::::: CONFIG DATABASE TFSConfig PrepSQL /sqlinstance:tfs TFSConfig RemapDBs /DatabaseName:tfs;Tfs_configuration /SQLInstances:tfs /continue :: run again for verification: TFSConfig RemapDBs /DatabaseName:tfs;Tfs_configuration /SQLInstances:tfs /continue :::::: CONFIG PERMISSIONS TFSConfig Accounts /ResetOwner /SQLInstance:tfs /DatabaseName:TFS_Configuration TFSConfig Accounts /add /AccountType:ApplicationTier /account:NEWTFS\TFSAdmin /SQLInstance:tfs /DatabaseName:TFS_Configuration TFSConfig Accounts /add /AccountType:ReportingDataSource /account:NEWTFS\TFSAdmin /SQLInstance:tfs /DatabaseName:TFS_Configuration TFSConfig...
no comments