TFS 2010 Server Domain and Database Move – Command Summary

March 6, 2012

no comments

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

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*