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 Accounts /add /AccountType:ApplicationTier /account:NEWTFS\TFSService$ /SQLInstance:tfs /DatabaseName:TFS_Configuration
TFSConfig Accounts /add /AccountType:ReportingDataSource /account:NEWTFS\TFSReports$ /SQLInstance:tfs /DatabaseName:TFS_Configuration
:: Optional - register DB instance:
:: TFSConfig RegisterDb /sqlInstance:tfs /databaseName:Tfs_Configuration
:::::: CHANGE DOMAIN
TFSConfig identities /change /fromdomain:TFS /todomain:NEWTFS
TFSConfig Accounts /change /AccountType:ApplicationTier /account:TFSService$ /password:******
TfsSecurity.exe /server:https://tfs/tfs /im n:NEWTFS\TFSAdmin
:::::: REPORTING SERVER
:: Check that only current server is listed:
RSKeyMgmt.exe -l
:: Optional – encrypt key for SSRS:
:: rsconfig -c -sTFS -dTFS -awindows -uNEWTFS\TFSReports$
:: Remove old entry:
RSKeyMgmt.exe -r 7f46c503-1aba-48bd-a731-f3440077fb32
:: Test SSRS datasource:
http://localhost/Reports/Pages/DataSource.aspx?ItemPath=%2fTfs2010ReportDS
::::::PURGE VERISON CONTROL CACHE (http://support.microsoft.com/?kbid=2025763)
del "%PROGRAMFILES%\Microsoft Team Foundation Server 2010\Application Tier\Web Services\_tfs_data\%tfsInstanceGuid%\Proxy"
::::::BRING BACK ONLINE
iisreset /start