TFS 2008 Patch Failed - VS90SP1-KB974596-x86.exe

Question

The patch VS90SP1-KB974596-x86.exe was downloaded from:

https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=34302

Because of the KB here: http://support.microsoft.com/kb/974596

Background:

•Previously we sucessfully migrated TFS from one Domain to Another.
•Even though Reporting Services and SharePoint are running, they have never been associated to the TFS2008 Installation.
•The TFS Team Explorer Nodes within Visual Studio show a red "X" where Reports (Reporting Services) and Documents(Sharepoint) would be.

During the patch the installation is asking for an Old Domain Account. The error log is here. I have anonymized the script to remove domains, servernames but the error starts at line 7541

"An unexpected error occurred: Windows NT user or group 'OLDDOMAINNAME\tfsreportservice' not found. Check the name again."

How do we get past this error.

I can't post the whole log because it's more than 60K characters long. Here are the lines that wrap around the error:

Upgrading the Warehouse Database
 Upgrading the Warehouse Database (TfsWarehouse)
 c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe
 -upgrade -int TfsIntegration -s SERVERNAMEROOTSQL001\SQL -d TfsWarehouse -c "c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml" -a "NEWDOMAINNAME\svc_tfs" -ra "OLDDOMAINNAME\tfsreportservice" -asinst "SERVERNAMEROOTSQL001\SQL" -asdbname "TfsWarehouse" -asacct ""
 c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe -upgrade -int TfsIntegration -s SERVERNAMEROOTSQL001\SQL -d TfsWarehouse -c "c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml" -a "NEWDOMAINNAME\svc_tfs" -ra "OLDDOMAINNAME\tfsreportservice" -asinst "SERVERNAMEROOTSQL001\SQL" -asdbname "TfsWarehouse" -asacct ""
 System.Data.SqlClient.SqlException: Windows NT user or group 'OLDDOMAINNAME\tfsreportservice' not found. Check the name again.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.TeamFoundation.Warehouse.WarehouseSchemaCreator.SqlExecuteNonQuery(SqlCommand cmd)
    at Microsoft.TeamFoundation.Warehouse.WarehouseSchemaCreator.GrantAccess(String accessUser, String dataReaderAccount)
    at Microsoft.TeamFoundation.Warehouse.WarehouseSchemaCreator.RepairWarehouse(String accessUser, String dataReaderAccount)
   
 An unexpected error occurred: Windows NT user or group 'OLDDOMAINNAME\tfsreportservice' not found. Check the name again.
 5
 c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 5 76518
 Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException: c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 5 76518
   at Microsoft.TeamFoundation.DatabaseInstaller.ProcessDeployer.ExecuteCommand(String filePath, String arguments, Boolean continueOnError)
Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException: c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 5 76518
   at Microsoft.TeamFoundation.DatabaseInstaller.ProcessDeployer.ExecuteCommand(String filePath, String arguments, Boolean continueOnError)
   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunDbActions(InstallerMode mode, String server, Boolean preview)
   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunSteps(InstallerMode mode, String server, IPropertyCollection properties, Boolean preview)
   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.Repair(String server, IPropertyCollection properties, Boolean preview)
   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.CommandRepair.OnRun()
   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.InstallerCommand.Run()
   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.CommandLine.RunCommand(String args)

c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 5 76518
04/15/12 03:43:12 DDSet_Status: Process returned 100
04/15/12 03:43:12 DDSet_Status: Using default error code for return value '100' and it is: '29002'
04/15/12 03:43:12 DDSet_Error:  100
MSI (s) (94!60) [03:43:12:127]: Product: Microsoft Visual Studio 2008 Team Foundation Server - ENU -- Error 29002.The Team Foundation databases could not be repaired. For more information, see the Microsoft Windows Installer (MSI) log.

Error 29002.The Team Foundation databases could not be repaired. For more information, see the Microsoft Windows Installer (MSI) log.

Answer 1

Hi SQL Sr Consultant,

Thanks for your post!

From "An unexpected error occurred: Windows NT user or group 'OLDDOMAINNAME\tfsreportservice' not found. Check the name again."

It looks like the old account might have been deleted entirely. If this isn't the case, then you might resolve the issue by granting the old account permissions to the server, then run TfsAdminUtil ChangeAccount.

Please perform the following steps:

1.     Make sure that the old service account exist in database. Open database on data tier, [TfsIntegration].[dbo].[tbl_registration_extended_attributes], check the value of TfsServiceAccount.

2.     Use TFSSecurity /g+ "[Server]\Service Accounts" <member> to add old account to service account.

3.     Add new service account to services account of Windows in Local Security Policy.

4.     Use TFSAdminUtil changeaccount

TfsAdminUtil ChangeAccount "OldComputerName\OldTFSServiceAccount" "NewDomain\NewTFSServiceAccount" NewPassword

About how to Move User and Service Accounts, you can refer to http://msdn.microsoft.com/en-us/library/ms404883(VS.90).aspx#MoveAccounts

For more information about move TFS, you can refer to

http://msdn.microsoft.com/en-us/library/ms404883(VS.90).aspx

If a red X appears on the Documents node in Team Explorer, it indicates that Team Explorer has lost communication with Windows SharePoint Services. The permissions granted to your user account are not sufficient to access to the Windows SharePoint.

Please go to Project portal site to add the permissions to the user account:

1. Login with an account who is the member of Members of the Project Administrators group,
2. Right Click the team project name in Team Explorer, select Show Project Portal,
3. Click Site Actions->Site Settings,
4. Under Users and Permissions, select people and groups,
5. Add your user account, and give the Contribute permission to that account.

In addition, can you run the BPA (Best Practice Analysis) in TFS power tools to eliminate any common issues?
http://msdn.microsoft.com/en-us/teamsystem/bb980963.aspx

Hope it helps!

Best Regards,

Cathy Kong

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Thanks for the quick reply Cathy.

The old account name was in the previous WINDOWS DOMAIN. I don't think I can add this account back to the project. The old domain doesn't exist. Does that matter?

---

SQL Sr Consultant Making life easier for people who don't know what a SQL Server is.

Answer 3

Hi SQL Sr Consultant,

Thanks for your feedback!

Could you tell the following questions so we can make further analysis?

1. When you move the TFS 2008 to the new domain, have you run command line TfsAdminUtil ChangeAccount and TfsAdminUtil Sid.

        For more information, you can refer to http://msdn.microsoft.com/en-us/library/ms404883(VS.90).aspx.

1. Could you run TfsSecurity.exe /server:servername /im n:DOMAIN\User to check your user account group memberships? For more information, you can refer to http://msdn.microsoft.com/en-us/library/ms252504(VS.90).aspx
2. After the TFS migrated from one Domain to Another, can the TFS work fine in the new domain?
3. run the BPA (Best Practice Analysis) in TFS power tools to eliminate any common issues?
   http://msdn.microsoft.com/en-us/teamsystem/bb980963.aspx

Please let me know if it helps!

Best Regards,

Cathy Kong

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Thank you Cathy.

After trying to use the command line and failing twice, I updated the entry in [TfsIntegration].[dbo].[tbl_registration_extended_attributes] to match the new domain user. We ran the patch and everything went very well.

Initially when the TFS Server was migrated to the new domain on parallel hardware the TFS team did translate all the Service Accounts from the Old Domain to the New Domain. All of the other service accounts were fixed prior to this incident. It was only the user who was in the "RsDataSourceAccount" that failed to convert.

Thanks for your help this issue is solved.

---

SQL Sr Consultant Making life easier for people who don't know what a SQL Server is.

Answer 5

Hi SQL Sr Consultant,

I am glad to here that you solve the issue and thanks for sharing the experiences here!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us