title: Move Team Foundation Server from one PC to another PC in a workgroup
body: <p>I am using TFS 2012. All the PC are connected by using Workgroup.(we are not using domain). The TFS PC is having PC name as PCTFS . We have about 15 developers who use TFS. As we use workgroup so we have created all windows users of 15 developers in the TFS server pc.  So now TFS server PC has windows users like PCTFS\user1 , PCTFS\user2 ,PCTFS\user3 so on.</p>
  
  <p>All these users connect to TFS server PC from their PC. As they have same user created in TFS server PC the authentication works by matching windows user name. So developer can connect to TFS server and work on it. All users have the required permission for all collection databases.</p>
  
  <p>Now we are planning to shift the TFS server to another PC. So PC name having TFS installed will change from PCTFS to PCNEWTFS . So when After restoring the sql databases of all collection and required database the permission will be referring old PC name. So all the users should be again to new PC. Also for all users permission should be given in each collection. </p>
  
  <p>Also if i do add all the users again the added user will be having old OwnerId in tbl_Identity table of each collection as it is restored database. But as i added all the users again with new pc name it will be assigning new OwnerId  i guess. So none of the developers are able to get their old workspaces.</p>
  
  <p>I followed below steps to restore TFS to new PC(<a href="http://msdn.microsoft.com/en-us/library/ms404869.aspx" rel="nofollow">referred this link</a>) </p>
  
  <p>1)I had full backup of TFS_configuration and all other collection database.(backup taken using TFSbackup.exe)</p>
  
  <p>2)In new PC i installed all the softwares(such as TFS 2012, sql server etc).</p>
  
  <p>3)created all the windows user account as in old server.</p>
  
  <p>4)When I checked the New PC it had default collection created which was mapped to SQL server which I stalled.</p>
  
  <p>5)Now I deleted that default collection and restored all databases of my old TFS server(TFS_configuration and all other collection database.)(backup restored using TFSrestore.exe)</p>
  
  <p>6)Now I opened Application-Tier Only wizard and select the sql server instance as mentioned in link. Also changed Team Foundation Server URL properly. I have also cleaned cache.</p>
  
  <p>7)Now when I checked TFS administrative console it had all the collections as my old server.</p>
  
  <p>8) Also i can access group membership etc. But the problem comes as i mentioned above.</p>
  
  <p>So please help me on this.</p>