Welcome to MSDN Blogs Sign in | Join | Help

Problems installing TFS SP1

For a while now I've been seeing people struggling with some TFS SP1 install issues and I've been silent about it for too long.  I was waiting for my team to investigate the issues and compile a summary.  I appologize for not speaking up about it sooner.  The vast majority of issues come down to a tool we have called TFSQuiesce.exe.  The purpose of this tool is to "shutdown" TFS while we perform the SP1 upgrade and restart it when we are done.  The biggest set of issues with it are that, for some reason, it does not always shutdown all services and it does not always restart them properly - leaving your server in an inoperable state.  The good news is that it is almost always easy to recover from.  The bad news is that it makes us look stupid and pisses people off :(. I honestly can't tell you how we missed this set of issues.  We tested the SP1 upgrade process for months and didn't hit these issues.  We didn't hear about them in the SP1 Beta period.  We still don't know all of the causes.  We're continuing to work on it, but in the mean time, here is all of the information we have.

Customer Scenarios

The following scenarios describe the vast majority of issues we have seen around SP1.  One important statistic is that we have had zero cases of data-loss. 

 

Issue

Customer Impact

Workarounds/Next Steps

1

SP1 fails to install on a SQL Cluster

·         Blocked from installing SP1 or any other DT patches.

·         None.  Look for a patch/work around coming in the next couple of weeks.

2

·         SP1 install fails and:

o    TFS databases in single-user mode

o    IIS in state where remote connections are declined

·          AT won’t start an errors reported in Event Log.

·         Http 403 forbidden error with browsers

·         TF2101 message from TE (can't connect)

 

·         To get running (without SP1):

o    Databases must be manually placed back in multi-user mode.  Use SQL Management Studio; right click on each TFS database; select properties; Select the Options page; At the very bottom there is an item called "restrict access" - set it to "multi_user".  There is a KB article in the works and should be published soon.

o    IIS must be manually configured to accept remote connections - See section 6.9 of the SP1 Known issues doc below.

·         To install SP1:

o    Manually put remaining databases in single-user mode and retry installation.  Use SQL Management Studio; right click on each TFS database; select properties; Select the Options page; At the very bottom there is an item called "restrict access" - set it to "single_user".  This will not always work if other people are trying to use the database at the same time.

 

3

SP1 install succeeds but leaves IIS in state where remote connections are declined

·         Http 403 forbidden error with browsers

·         TF2101 message from TE (can't connect)

·         IIS must be manually configured to accept remote connections - See section 6.9 of the SP1 Known issues doc below.

4

Users can’t uninstall SP1 Beta after installing Quiescing

The Quiescing logic breaks the Beta from uninstalling but you can’t uninstall Quiescing from Add/Remove programs because it doesn’t appear there if SP1 Beta is installed. (A chicken and egg issue.) The SP1 RTM will not allow you to install if the SP1 Beta is installed.

1.       Run a manual uninstall operation from the command-line.  See the steps at the bottom of this post...

2.        Uninstall TFS SP1 Beta - using Add/Remove Programs.

5

SP1 fails to install

These error are usually due to changes in configuration after RTM installation that our setup does not handle well. In some cases the customers are left with an unusable server.

·         Requires a review of the install logs for more details on the specific error and then ultimately identify the configuration change that broke the installer.

Here is a link to an SP1 Known Issues page.  Most of these "issues" aren't new problems with SP1 but rather just common issues that people run into with TFS and what you can do about them. 

We hope to have some more detailed step by step instructions help with this in the next week.  We hope to have a patch for TFSQuiesce soon after that.  We're working hard to address these issue as quickly as we can.  I very much appologize for the inconvenience.

Brian

Steps for a manual uninstall of TFS SP1 Beta:

1)      Uninstall Quiescing with the following command-line. This step only needs to be done if Quiescing was installed before SP1 Beta was uninstalled.(\vs_setup.msi is the path to the original RTM install  media .msi file)

Msiexec.exe /uninstall {ED6FB172-8DB0-420F-9E81-2B38FFE7D0C3} /package \vs_setup.msi

2)      Uninstall SP1 Beta (KB922996) using Add/Remove Programs.  Make sure that “Show Updates” is checked to see the entry.

3)      Run a repair operation to ensure that the SP1 RTM installer updates all necessary files. (\vs_setup.msi is the path to the original RTM install  media .msi file)

Msiexec.exe /package \vs_setup.msi ADDLOCAL=ALL

4)      Install SP1 RTM (KB926738)

Published Thursday, February 08, 2007 7:49 AM by bharry

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# A quick guide to fixing problems after installing Team Foundation Server Service Pack 1 (SP1)

Thursday, February 08, 2007 4:40 PM by Buck Hodges

Neno Loje , an MVP, recently posted about dealing with HTTP 503 or 403 errors after installing TFS SP1

# re: Problems installing TFS SP1

Friday, February 09, 2007 7:27 AM by Gabriel Lozano-Moran

I am one of those who encountered an issue trying to patch to SP1. The admin account running the installer could not set the database TFSWorkItemTracking to single-user mode for some reason. I manually set only that database to single-user and I was able to finish the installation.

# Installation of Service Pack 1 for Team Foundation Server fails

Friday, February 09, 2007 7:49 AM by Gabriel Lozano-Morán - The .NET Aficionado

For some reason when I was trying to install the Service Pack 1 for Team Foundation Server, the installation

# VSTS Links - 02/13/2007

Tuesday, February 13, 2007 9:12 AM by Team System News

Rob Caron on Team Foundation Server and Microsoft Project. Brian Harry on Problems installing TFS...

# re: Problems installing TFS SP1

Thursday, February 22, 2007 3:46 PM by Arvinder Chopra

With all due respect, I am compelled to make this observation and I hope you will take it in a constructive manner. TFS from the start has been plagued with quality problems. I have been involved with rolling out TFS (from version 1.0) for a large client, and we have always encountered nagging problems, involving manual fixes and workarounds.

This latest SP1 is a case in point. It cost our company a lot of downtime, and I am still unable to get TFS working again.

I am sorry, but I really think the TFS program manager should be fired as the first step in getting this product to an acceptable level of quality.

# re: Problems installing TFS SP1

Monday, February 26, 2007 9:34 AM by bharry

I appreciate your feedback.  I don't think it's fair to say that TFS has been plagued with quality problems but I do think it is fair to say that setting TFS up is very difficult - particularly if you try to stray form the straight and narrow path even the slightest bit.  As a general rule, once you get it up and running, it works well and with very little maintenance.

SP1 installation is another matter.  I'm sorry to say that we botched the TFSQuiece tool badly and I appologize to all of you who have struggled with it.  It is designed to "shut down" the TFS server so that it can be patched.  Unfortunately, the technique it uses to do this can result in a race condition when any other piece of software is trying to access the database at the same time.  Further, it doesn't "rollback" and restore itself to a good state if it does hit this race condition.  Generally getting out of this situation is pretty easy (if you know what to do) but clearly, it's a frustrating experience and I feel terribly about it.

We tested the quiescing tool fairly extensively before we released it but clearly not well enough.  I don't believe it was tested on an actively used server (which would probably have identified the issue) nor was it included in the Beta of the SP1 patch.  We've done quite a lot of investigation to learn from the mistakes we made here and are working to make sure we don't repeat them.

Again, I appologize for the problems this has caused.

Brian

# re: Problems installing TFS SP1

Wednesday, February 28, 2007 11:25 AM by Michael Aaron

Any word on when the fix for installing SP1 on a SQL Cluster will be released?

# re: Problems installing TFS SP1

Friday, March 02, 2007 8:49 AM by bharry

Here's some more info on installing the service pack from Richard Berg.  We've had a fair number of questions about install order.  Fundementally, it comes down to - we can't patch it if it isn't already on the system.  The most common issue I've seen is people instally SP1, then Team Explorer and being upset because their bugs weren't fixed.  It's a bit wierd the way we've shipped patches that patch so many different components and, as I say, if it isn't already installed, we can't patch it.

Here's Richard's post: http://blogs.msdn.com/richardb/archive/2007/02/22/install-sequence-vsts-sp1-tfs-sp1-vista-quiescing-oh-my.aspx

I'm looking into when the clustering fix will be available.  Sorry for the delay.

Brian

# re: Problems installing TFS SP1

Friday, March 02, 2007 10:12 AM by bharry

OK, I have the status on the clustering fix.  We have a fix and have tested it with a few of our large customers.  We are working through the final testing process and are planning (assuming nothing goes wrong - always a dangerous assumption) to release it towards the end of this month.

Brian

# re: Problems installing TFS SP1

Thursday, March 08, 2007 6:12 AM by Dave Hope

Thanks for posting that, I came across an issue when installing not TFS SP1, but the prerequisite (KB919156) In the effort of helping out others, I've blogged about the problem I had and how I overcame it here: http://davehope.co.uk/Blog/1173351206

Hope it helps someone,

Dave

# re: Problems installing TFS SP1

Monday, March 19, 2007 1:17 AM by googlexp

--- I am sorry, but I really think the TFS program manager should be fired as the first step in getting this product to an acceptable level of quality.

Arvinder Chopra

-----

Excellent suggestion! I've wasted hundreds of hours struggling with this crappy product for months, it's a total flop in terms of quality and usability. Maybe some naive newbies think it's great (for toy apps they tinker with), but for production use, forget it.

# re: Problems installing TFS SP1

Monday, March 19, 2007 8:35 AM by bharry

I'm sorry you feel that way.  I assure you, there are many thousands of people using it and very happy with it.  Are there specific things you've had issues with?  We'd be very happy to help you resolve any problems you are having.

Brian

# re: Problems installing TFS SP1

Tuesday, March 20, 2007 10:44 PM by Marc Beauchamp

I'm also having some issues.  Trying to install TFSQuiese, I get the following:

"Windows SharePoint Services cannot extend the default virtual server. For more information, see the Microsoft Windows SharePoint Services Administrator's Guide."

BTW, I'm running Sharepoint 3.0.  When the update came out, we upgraded since there was no note about TFS incompatibility.  Up to know, we've been running it sucessfully.

Is there any way to insert something in the registry to mimic having the KB installed?

# re: Problems installing TFS SP1

Wednesday, March 21, 2007 8:59 AM by bharry

Unfortunately TFS is not compatible with Sharepoint 3.0 yet.  Sharepoint 3.0 support is a feature of our Orcas release.  Send mail to edpsyk@microsoft.com and he may be able to help you get unwound from where you are.

Brian

# re: Problems installing TFS SP1

Wednesday, March 28, 2007 5:31 AM by paso

I'm still waiting to install TFS SP1 because the status of it is unclear to me.

This post somewhere states the following: "We hope to have some more detailed step by step instructions help with this in the next week.  We hope to have a patch for TFSQuiesce soon after that.  We're working hard to address these issue as quickly as we can." (February 08, 2007 )

A problem with the TFSQuiesce patch is also mentioned here (http://msmvps.com/blogs/vstsblog/comments/541324.aspx): "The Quiescence patch for TFS changed IIS's directory security to "deny access" and the switched the databases from MULTI_MODE to SINGLE_USER that no data corruption occures during the update process. For some reason this is in some cases not reverted automatically. Microsoft is investigating the issue and preparing to create a fix"

However I cannot find any further info about the status of this fix to the patch. Can you clear things up please ?

Thanks.

# re: Problems installing TFS SP1

Wednesday, March 28, 2007 7:01 AM by bharry

Sorry, we've released the patch to a few customers to try it out.  I'll get someone to follow up on this post with details on when it will be more broadly available.  I'm expecting any day now.

Brian

# re: Problems installing TFS SP1

Wednesday, March 28, 2007 7:27 AM by Ed Psyk

We are in the final stages of testing the updated Quiescing patch and it will be released as soon as possible.  The problems this patch created highlighted the importance of getting it right this time.  

In addition to the race condition Brian mentions, Quiescing brought to our attention that a number of TFS installations have had their configuration modified after install.  Some of these configuration changes, if not done correctly, can lead to serviceability issues with TFS.  Patching would fail even if Quiescing wasn't a required patch but because Quiescing doesn't leave the system in a good state when these failures occur it is masking the real problem at times.  We will have some guidance to go along with the new release of Quiesicng that will help you to verify your configuration.

If you have any questions feel free to ping me at edpsyk@microsoft.com.

Ed

# re: Problems installing TFS SP1

Thursday, April 12, 2007 4:18 PM by Jay Ur

Thanks for posting this. Why isnt this included in the msdn disks I just received today? Why are you creating a patch for your Quiescing when you should be patching the sp1 install to do the Quiescing?

It was a good scare to have our TFS go down for a few hours. I'll think long and hard before I patch this system.

# re: Problems installing TFS SP1

Friday, April 13, 2007 5:54 AM by William Gregoire

Any news on the patch?

Is the patch meant to solve the cluter (named instance) poblem upgrade to SP1?

# re: Problems installing TFS SP1

Monday, April 16, 2007 8:30 AM by bharry

I'll get an update on the status.  My shame at how long this is taking us is unbounded.  I'm really sorry.  All I can say is that the team is working really hard to make sure this patch solves the problems and doesn't introduce any new issues.  There have been some problems due to resource conflicts trying to get Beta 1 out the door.  I've been assured it's going to be soon but I don't have a date yet.

Brian

# re: Problems installing TFS SP1

Monday, April 23, 2007 4:33 PM by Mike Aaron

Time for the weekly ping on the patch....

Any update on a release date for the cluster patch?

# re: Problems installing TFS SP1

Tuesday, May 01, 2007 3:00 PM by bharry

I'm just ignoring you because I don't want to disappoint you with an answer.  Well, maybe honesty will buy me something.  I just checked on it again and we hit another bug in some installation scenario.  This is complicated by the fact that the work is split across two distant teams and the turn around time every time we find a bug is mind boggling.  I'm going to escalate the issue again today.

Brian

# re: Problems installing TFS SP1

Wednesday, May 02, 2007 4:07 AM by Sindre

While waiting for the patch... If we temporarily move the databases (and analysis services) to a non-clustered server and install SP1 there, will it be possible to move back to the SQL cluster and separate database and analysis services after a successful upgrade?

-Sindre

# re: Problems installing TFS SP1

Wednesday, May 02, 2007 6:15 AM by bharry

We do have a manual process for managing the upgrade.  Email edpsyk@microsoft.com and he can give you instructions.

Brian

# re: Problems installing TFS SP1

Tuesday, May 29, 2007 9:53 AM by Mike Aaron

Its been about a month and no word on the cluster patch...

I'm assuming that you still don't have an answer, but I'd figure I check in anyway.

# re: Problems installing TFS SP1

Thursday, May 31, 2007 4:27 PM by Scott Anderson

After some research and trial and error the following method worked for a new install and should work for an upgrade as well.  The goal is to temporarily disable the cluster and make SQL run stand alone.

1.  On the active node, go to the cluster administrator and stop all cluster services.  This will cause the UI to not be able to view cluster information.

2.  In the service manager, disable the "Cluster" service.

3.  In the registry, export and then delete the registry key that the cluster disk driver uses to control the shared array.  (http://support.microsoft.com/default.aspx?scid=KB;EN-US;309186)

4.  In the registry, export and then delete the registry keys that SQL service and anlaysis use to associate themselves with the cluster.  This is usually

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Cluster and HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Cluster.

5.  In the service manager, set all of the sql services, except the active directory one, to automatic.  Note which ones you are setting to automatic.

6.  In the WINDOWS\system32\drivers\etc\hosts file, add an entry to make this machine appear as the cluster i.e. 127.0.0.1    YourVstsDbClusterName

7.  Restart the machine.  When the machine restarts, cluster services should not have started, the shared array should be accessible, and the sql services should be working without error.

8.  Install or upgrade TFS using the directions on the TFS install guide. The GDK and SP1 will install ... just wait for it. (http://www.microsoft.com/downloads/details.aspx?familyid=e54bf6ff-026b-43a4-ade4-a690388f310e&displaylang=en)

9.  Remove the hosts file entry that was made earlier.

10. In the service manager, reset the changed SQL services to manual.

11.  Restore the 2 SQL cluster registry keys from step 4.

12.  Restore the shared array registry key to the cluster disk driver from step 3.

13.  In the service manager, set the "Cluster" service to automatic.

14.  Restart the computer.  When the machine has rebooted, the cluster services should start and SQL should again be controlled by the cluster services.

15.  In the cluster administrator, restart the cluster services on the other nodes.

# re: Problems installing TFS SP1

Wednesday, June 13, 2007 8:48 AM by Stephen

I've got a problem trying to install SP1 on the Database tier server and am having trouble finding an answer.  The installer dialogue box just disappears during install, so I look at the application event viewer and see this error.

Product: Microsoft Visual Studio 2005 Team Foundation Server (databases) - ENU - Update 'Microsoft Visual Studio 2005 Team Foundation Server (databases) - ENU Service Pack 1 (KB926738)' could not be installed. Error code 1603. Additional information is available in the log file C:\DOCUME~1\wackesj\LOCALS~1\Temp\1\MSI2c9cb.LOG.

I look in the log file and see lots of lines like so.

DEBUG: Error 2745:  Transform T2_102ToU186_102 invalid for package C:\WINDOWS\Installer\44a5b3.msi. Expected language 1036, found language 1033.

1: 2745 2: T2_102ToU186_102 3: C:\WINDOWS\Installer\44a5b3.msi 4: 1036 5: 1033

This is stopping me using TFS as the Application Tier server is reporting this in the event log

Detailed Message: TF53018: The application tier LDN-APP-TSS-P01 is attempting to connect to a data tier with an incompatible version.

Any help would be appreciated?

Steve

# re: Problems installing TFS SP1

Wednesday, June 13, 2007 10:17 AM by Ed Psyk (MSFT)

Stephen, can you send me the log file?  We should be able to diagnose the issue with it.  

Thanks,

Ed

edpsyk@microsoft.com

# re: Problems installing TFS SP1

Thursday, June 14, 2007 4:44 PM by Mic

Hello Brian,

I look at your blog from time to time because we are using TFS in our company and would like to move to SP1 as fast as possible due to several known issues.

You wrote at the beginning of March, that the SQL Cluster Fix should be avialble at the end of March. This  is nearly a quarter year ago. Can you tell us the current status of that fix or is it not possible to make  halfway reliable statement on that?

BTW: Was SP1 never tested on a SQL cluster maschine before releasing it? I can't imagine that.

Thanks, Mic

# re: Problems installing TFS SP1

Friday, June 15, 2007 7:23 AM by bharry

Yes, it was a long time ago and I was really wrong on when it would be done.  It was a long and painful process getting the patch produced.  But it has finally been released.  See: http://blogs.msdn.com/bharry/archive/2007/06/15/updated-quiescing-patch-released.aspx

I apologize that it took so long.

As for testing SP1 with clustered SQL Servers, I'm afraid, we actually didn't test it (which is why it slipped through not working).  Some background on this.  When we released TFS V1, we had tons of restrictions about how you could configure TFS based on the configurations we had included in our test matrix.  Restrictions included things like: Must be installed on a clean box, No clustering, No VPCs, etc...  We had kept the V1 test matrix comparatively small so that we could get the product shipped (it actually wasnt very small).

Soon after we released, we came to realize that customers found some of these restrictions unacceptable and didn't even read them in most cases.  As a result we began testing the server in more configurations, producing whitepapers and, in some cases, producing hot fixes to enable more configurations.

The problem with SP1 is that the team used the V1 test matrix to verify the patch and not the post release expanded matrix.  The updated fix referenced above has been tested on the expanded matrix.

Two other issues plagued SP1.  We tested it extensively within the V1 configs, but unfortunately, none of the testing was done on a "live" server.  They were all done on test servers.  So the race conditions that we found in the field between patching and people actually trying to use the server were not discovered.  Lastly, the troublesome "quiescing" step in SP1 missed the SP1 Beta release and we incorprated between Beta and RTM.  Clearly a big mistake.

The only think I can say is that we're sorry for the trouble it caused and we have learned from the mistakes.  I really believe we are doing it "right" in Orcas and servicing of Orcas should be much better.

Brian

# re: Problems installing TFS SP1

Friday, June 15, 2007 11:01 AM by Mic

Hi Brian,

thanks for your fast answer and your "open book policy" (I've no idea if this has the same meaning as in german ;-)

We will try to move to SP1 in the next two weeks.

BTW: I like this product and such problems happens and if I'm telling you the truth I'm pacified that such things not only happens in my company ;-)

Have a nice weekend

Mc

# re: Problems installing TFS SP1

Wednesday, June 20, 2007 4:46 PM by Ian

Hi Brian,

I have gone through the installation of both patches several times (insanely) expecting different results. My TFSQuiesce file is the latest though .886! I don't get any errors during the installs but I have noticed some things that make me wonder if anything was updated.

First thing I noticed was something I read here (http://blogs.microsoft.co.il/blogs/srlteam/archive/2007/03/29/Migrating-a-TFS-with-a-partially-installed-SP1.aspx) where the schema version is not being updated.

Also, I can no longer connect to my Team Server in the Team Explorer. I get the error TF31004.

Please help - our development is at a complete hault.

Best,

Ian

# re: Problems installing TFS SP1

Wednesday, June 20, 2007 11:14 PM by edpsyk

Ian, I am sure we can help you through this.  The first thing I would ask for is the MSI install log for patch installation.  You can usually find it in the %temp% folder of the account you were logged in as when you installed.  If it isn't there you can re-install and pass in the following parameters from the command-line:

/l*v <logfile name>

You can send the log file to edpsyk@microsoft.com and we can see if it has anything to help us.

Thanks,

Ed

# re: Problems installing TFS SP1

Thursday, August 02, 2007 11:09 AM by Ravindra

I am getting the following error when I try to create a team project. It started hapenning after installing TFS Service Pack 1.

Error

TF30170: The plugin Microsoft.ProjectCreationWizard.WorkItemTracking failed during task WITs from group WorkItemTracking.  

Explanation

Plugin error text: “Could not find stored procedure 'BoxCarIdentityChanges'. ---> Could not find stored procedure 'BoxCarIdentityChanges'. ---> Could not find stored procedure 'BoxCarIdentityChanges'.”  

User Action

Contact your Team Foundation Server administrator.  

Event Viewer shows

****************

TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.

Technical Information (for the administrative staff):

Date (UTC): 8/2/2007 2:13:20 PM

Machine: SILICUS15

Application Domain: /LM/W3SVC/3/Root/WorkItemTracking-4-128305371634427982

Assembly: Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayer, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 1832

Thread Id: 1412

Account name: SILICUS\Administrator

Detailed Message: TF51618: Service Error: Could not find stored procedure 'ApplyAllTreeChanges'.

Exception Message: Could not find stored procedure 'ApplyAllTreeChanges'. (type ValidationException)

Exception Stack Trace:

Inner Exception Details:

Exception Message: Could not find stored procedure 'ApplyAllTreeChanges'. (type SqlException)

SQL Exception Class: 16

SQL Exception Number: 2812

SQL Exception Procedure:

SQL Exception Line Number: 1

SQL Exception Server: silpunappdev2

SQL Exception State: 62

SQL Error(s):

Exception Data Dictionary:

HelpLink.ProdName = Microsoft SQL Server

HelpLink.ProdVer = 09.00.3042

HelpLink.EvtSrc = MSSQLServer

HelpLink.EvtID = 2812

HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink

HelpLink.LinkId = 20476

Exception Stack Trace: 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.WorkItemTracking.Server.ProcessStructureEventMessage.Process()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

***************

--------------------------------------------------------------------------------

Ravindra, Silicus Technologies

# re: Problems installing TFS SP1

Thursday, August 02, 2007 11:32 AM by bharry

This symptom looks to me like the SP has been installed on the application tier but not the data tier.

Brian

# re: Problems installing TFS SP1

Thursday, August 02, 2007 3:31 PM by Ed Psyk (MSFT)

Ravindra, we have seen this a few times and if you call our support team they can get you going.  We are looking into workarounds that would eliminate the need to call the support team but do not have any at this time.

Please feel free to contact me at edpsyk@microsoft.com if you need anything.

Thanks,

Ed

# re: Problems installing TFS SP1

Monday, August 06, 2007 3:41 PM by Ed Psyk (MSFT)

Ravindra, we have a possible solution for this issue that we would like to verify with you.  Can you send me the msiproperty.ini file that resides in the Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Microsoft Visual Studio 2005 Team Foundation Server – ENU directory?

Thanks,

Ed

edpsyk@microsoft.com

# Planning on installin SP1

Thursday, September 06, 2007 10:46 AM by David Olfert

I'm planning on installing SP1 for Team Foundation Server. I have Team Foundation Server on one machine, database server, IIS, Sharepoint is all on the same machine. Is there anything special I need to know to install SP1 on this configuration successfully.

# re: Problems installing TFS SP1

Thursday, September 13, 2007 8:38 PM by Ed Psyk

David,

There shouldn't be anythng special required to install SP1 on a single server.  If you run into any problems feel free to email me at edpsyk@microsoft.com

Thanks,

Ed

# re: Problems installing TFS SP1

Friday, November 02, 2007 1:16 PM by Bryan Bedard

Hi Brian and Ed,

I am in the same situation as Ian describes above. I have put all my databases in single user mode and I have confirmed that the version of TfsQuiesce.exe I have is the .886 version. When I run the SP1 installer, it gets about 10% in then backs everything out and shuts down. In event viewer, I see this message:

Product: Microsoft Visual Studio 2005 Team Foundation Server - ENU - Update 'Microsoft Visual Studio 2005 Team Foundation Server (databases) - ENU Service Pack 1 (KB926738)' could not be installed. Error code 1603. Additional information is available in the log file C:\DOCUME~1\SUPERD~1\LOCALS~1\Temp\VS80sp1-KB926738-X86-ENU\VS80sp1-KB926738-X86-ENU-msi.0.log.

Were you able to help Ian? Can I send you my MSI log file?

# re: Problems installing TFS SP1

Saturday, November 03, 2007 7:39 AM by bharry

I've forwarded your issue to Ed.  He should get back to you on Monday.

Brian

# re: Problems installing TFS SP1

Tuesday, November 06, 2007 7:10 PM by Ed Psyk - MSFT

Bryan, please send me your install log.  I would be happy to look into the your problem.  

Thanks,

Ed

edpsyk@microsoft.com

# re: Problems installing TFS SP1

Wednesday, November 07, 2007 11:34 AM by Bryan Bedard

Thanks Ed. I did try sending the log files to you on Friday. Perhaps the message was filtered out. I just tried sending it again a few moments ago. Let me know if you don't receive it.

# re: Problems installing TFS SP1

Friday, November 09, 2007 11:19 AM by Ed Psyk -MSFT

Bryan was able to resolve their problem by changing the SQL service to run as an admin account rather than Local System.  We often run SQL as Local System ourselves so this is a supported configuration.  The issue is either with a policy on the Local System account that doesn't allow AD to be queried or with SQL itself.  The behavior is independent of TFS and can be seen by trying to disable a SQL account mapped to an AD identity from within the SQL Management Studio.  

If you are having problems similiar to this and can't get past them, feel free to contact me at edpsyk@microsoft.com.

Thanks,

Ed

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker