TFS 2008 SP1 RTM installation problem, reason and solution

August 13, 2008

While VS 2008 SP1 and SQL Server 2008 were relatively painless to install, I run into some issues with the TFS 2008 SP1.

I’ll tell briefly my case so you can avoid this or find the solution, should you have the same reason for the problem.

The TFS 2008 is installed on a single Windows Server 2008 machine (except SharePoint) and uses SQL Server 2005 SP2.

When I tried to install the KB949786 (TFS SP1), the first part went always fine (TFS Build), but it ended in Fatal Error during the update of the actual TFS. TFS got into unusable state (clients couldn’t connect etc)

The errors in the Event Log were:

“Product: Microsoft Visual Studio 2008 Team Foundation Server – ENU – Update ‘KB949786′ could not be installed. Error code 1603. Additional information is available in the log file <file>”

and

“Product: Microsoft Visual Studio 2008 Team Foundation Server – ENU — Error 29003.TF 230001: The error mode for the Team Foundation Server Web application could not be configured properly. This problem occurred because the application root for the Team Foundation Server Web application does not exist. For more information, see the Microsoft Windows Installer (MSI) log.”

After some googling, I found similar symptoms from the MSDN Forums. Logins etc were alright in my case, so the reason was elsewhere. (Tip: don’t change TFS service accounts unless you have a very good reason and if you do, use the tools mentioned in the forum)

Finally I just had to go through the installation log and from there I found the reason:

08/13/08 10:51:15 DDSet_Status: Commandline: "C:\Windows\system32\inetsrv\appcmd.exe" set config "Team Foundation Server" -section:httpErrors -existingResponse:PassThrough -commitpath:apphost
08/13/08 10:51:15 DDSet_Status: IgnoreExitCode: 0
08/13/08 10:51:15 DDSet_Status: Silent: 0
08/13/08 10:51:15 DDSet_Status: ActionStart: 0
08/13/08 10:51:15 DDSet_Status: Cost: 0
08/13/08 10:51:15 DDSet_Status: WorkingDirectory:
08/13/08 10:51:15 DDSet_Status: HideCmdLine: 0
ERROR ( message:Cannot find SITE object with identifier "Team Foundation Server". )
08/13/08 10:51:16 DDSet_Status: Process returned 1168
08/13/08 10:51:16 DDSet_Status: Found the matching error code  for return value ‘1168′ and it is: ‘29003′
08/13/08 10:51:16 DDSet_Error:  1168
MSI (s) (B8!94) [10:51:16:127]: Product: Microsoft Visual Studio 2008 Team Foundation Server – ENU — Error 29003.TF 230001: The error mode for the Team Foundation Server Web application could not be configured properly. This problem occurred because the application root for the Team Foundation Server Web application does not exist. For more information, see the Microsoft Windows Installer (MSI) log.

I have the habit of putting server port in the names of the web sites in the IIS and I had renamed the “Team Foundation Server” to “Team Foundation Server – 8080”. The patch was obviously looking for the original name and failed because it didn’t find a web site with exactly the same name.

I just renamed the web site hosting the web services back to “Team Foundation Server”, run the patch again (without uninstalling it first) and everything went fine. :)

Microsoft, you could modify that part of the patch to search the web site with partial match or better: with some kind of unique ID of the web site instead of the name.

TFS is still very new product and it relies on so many other services and products that there are many places where something can go wrong. This is why it is better not to mess with anything directly without using official tools.


SQL Server 2005 Security Update (KB948109) fails to install with error code 0×773F – how to fix

July 9, 2008

Today I got a batch of updates via Windows Update. Most updates installed fine, but the “Security Update for SQL Server 2005 Service Pack 2 (KB948109)” failed with error code of 0×773F.

This computer runs Windows Vista and SQL Server 2005 Developer Edition.

There is also a named instance (MSSMLBIZ) for Outlook with Business Contact Manager (or whatever). I had disabled this instance for performance reasons as I never use the add-on. However, I had to enable and start the service through the SQL Server Configuration Manager to get the update to install.

Then I downloaded the stand-alone security update from the Microsoft Downloads. You can find it from here: Security Update for SQL Server 2005 Service Pack 2 (KB948109). This isn’t probably necessary, as long as all the instances are running, but if you still get errors, you can check the separate log file with more verbose information.

In short, all you need to do is:

  • Make sure all the SQL Server 2005 instances are running able to start
  • …or uninstall unnecessary instances, including hidden ones
  • Download and run the manual update

This fixed it for me.

Update #1:

Make sure that you don’t have NTFS folder compression on for the folders where the database files (*.mdf, *.ldf) are located. This may prevent the instances from starting.

Update #2:

I just installed the patch through Windows Update on my home computer (Vista Ultimate, SQL Server Developer Edition) and it went fine (with services already stopped).

I’m now certain that my first problem was caused by the disabled service and starting the services has nothing to do with it (as commenters has pointed out).

One solution that I found was disabling the firewall (the error code was also different, though).

There are probably many causes for this issue, so if you succeed to fix it, please comment here what you did, thanks :)

Update #3:

Updated SQL Server 2005 Standard Edition and Windows Server 2008 that hosts it. Through the Microsoft Update with no problems. Still recommend to proceed with caution on production servers before these symptoms are explained/fixed.

Update #4:

Found some good related discussions and solutions:

Especially this excerpt from the first link explains the 733F:

“Error: 733F– Services Failed to Start “From MS Support”

“Description: This error occurs when the installation program can’t start the SQL Server services. This can happen for several reasons including: expired account password, invalid user account, user account does not have permission to start the service, or there is something else wrong with the service.”


Myth: Keyboard can’t crash your computer

February 24, 2008

I recently upgraded my server to Windows Server 2008 and soon after that the problems started. No, not because of the greatest server operating system there is, but because of a hardware issue.

The symptom was always the same: computer would suddenly reboot, then turn off. Power led, fans etc were on and keyboard LEDs (caps lock, scroll lock and num lock) were flashing very fast. I couldn’t find many similar symptoms by searching the web, either.

The server started crashing after variable periods of time and it was difficult to find the reason. I had upgraded the memory to 2GB at the same time, so that’s where it was natural to start troubleshooting. I tried various memory tests, old memory DRAM’s etc, but still the computer kept crashing.

It could have been a heating issue, but it hadn’t been a problem before and the hardware monitor in BIOS showed low temperatures. By the way, crashed happened in CMOS-setup, too, so it had to be a hardware-related issue.

I also suspected faulty hard disk, motherboard or PSU, but luckily I found the reason: my old Microsoft Natural Keyboard Pro that I had reserved for random uses like this.

I had attached the keyboard for the fresh install of the Windows Server 2008 as Remote Desktop can’t be used in the early phase of installation. After installation, I had left the keyboard attached, just in case there were problems and I needed to login directly. Never would I have thought that the keyboard could actually cause this severe problems. How ironic.

At one point I guessed that maybe the keyboard from 1999 could be the reason with the odd blinking after the crashes and because usually I don’t have any keyboard or mouse attached to the server.

So I detached the old PS/2-keyboard from the server and the server has been running fine ever since for several days. The PS/2 -connector could somehow be faulty, too, but either way, I’ll use only USB-keyboards from this century/millennium from now on.

Not sure if I should blame Microsoft or IBM (who invented PS/2-port) for my problems. Of course I’m not the one to blame for using too old hardware! ;) Hopefully this post helps someone with similar symptoms.

This time I really had to think outside the box to solve the problem :D

Another busted myth


Windows Server 2008 – Upgrade tips

February 10, 2008

Windows Server 2008 -logo

Last night I finished upgrading Windows Server 2003 to the Windows Server 2008. Here are some tips to help those of you facing the same challenge. I had some problems along the way that I could have avoided with more careful planning, but live and learn.

As I use my server only for personal development purposes, it is not that critical as a real production server would be. Anyway, good preparation makes things easier. I chose to do a “clean” installation, as I wanted to install the Windows Server 2008 to a bigger volume.

This is a long post, but if some part helps someone even a bit, it serves its purpose. I’ll cover these tips:

  1. Make a checklist for yourself
  2. Backup and copy everything to a safe place
  3. Prepare post-installation setups
  4. Check your hardware compatibility
  5. Post installation tasks
  6. Installing and configuring applications

Disclaimer: Please remember, that I’m more of a developer/software architect kind of guy than an IT professional who maintains servers full time. I just admin my own servers and desktops when I need, so not all of my tips may be the best practices.

1. Make a checklist for yourself

Before getting your hands dirty, list all the things you have to take into consideration. I used Microsoft Office OneNote 2007 to take my notes. My server is a typical web server with SQL Server so this post mostly revolves around related things.

OneNote Checklist

In the checklist I listed things like:

  1. What should be backed up
  2. What sites and application pools I have in IIS6
  3. How do I migrate databases in SQL Server 2005
  4. What other applications I have and what should be reinstalled
  5. How should I backup and restore contents in the Windows SharePoint Services
  6. Screen captures from various settings pages (IP-settings, IIS, local users, file shares)

I should have checked these things, too:

  1. What hardware the server has and is it supported
  2. Get the latest drivers for Vista and Windows Server 2003, if there are no native Windows Server 2008 drivers.

2. Backup and copy everything to a safe place

After you have made at least some plan, execute it by copying all the settings, files, databases etc to a place that can be easily accessed after upgrade.

Also, if you have some external USB drive, copy them there. I had lazily put most of the backups and post-installation setups to the backup raid that required drivers to work. If I wouldn’t have been able to get it to work, I could have been in trouble. Separate USB disk would have been safer and compatible whatever happened.

Here are some detailed tips:

SQL Server 2005: I detached the databases and attached them after installation of the new Windows Server. There were only few important databases, so this was faster way than the backup/restore -way. If you want to move your logins, scheduled jobs and other database server wide-stuff, remember to backup at least master and msdb -databases. If you do it manually like me, make sure you know or can locate the passwords for the logins that your apps. may use (connection strings etc).

IIS6: There are some tools that help migrating the database, like the new MS Deploy -tool. I considered using it, but I couldn’t install it since it required .NET Framework 2.0 SP1 that wouldn’t install on my Windows Server 2003 for some reason. So I decided to manually copy everything and configure them in IIS7.

WSS: I only use Windows SharePoint Services v3 to sync my OneNote -notebooks between work and home, which is very handy (I’ll try to blog about it later). After checking the sites and their contents, I decided that again it is easier to copy the files manually and setup the few sites I have manually.

First I considered backing them up with the stsadm, but then I noticed that due to DNS/router configuration, I couldn’t actually access the WSS from the localhost and fixing it would have taken more time than manual way for that small amount of data.

DNS server: I just copied the %systemroot%\system32\dns -folder to safe place.

3. Prepare post-installation setups

Remember to think through the whole process. Backing up the data and installing the Windows Server 2008 is only half of the process and what follows is re-installing the applications you need.

This will be much easier and faster if you reserve all the setups, service packs and product keys to one place.

If you are going to install applications from an .iso-image, you’ll need some program that can access them from the Windows Server 2008. I have been a long time user of the Daemon Tools, but over the last few years I have liked it less and less (ad-ware, reboot during installation, problems in Vista etc). I decided to try the free MagicISO, which works fine for me in Windows Server 2008.

4. Check your hardware compatibility

This may sounds obvious, but actually I neglected to do this, since:

  • a) I haven’t had driver issues for a long time with Windows so I took it for granted that everything would just work
  • b) Installation on the virtual server went so smoothly – though on a different computer.

My server is built from old computer parts so it has actually some very old parts, now that I think about it. What was supported out of the box in Windows Server 2003 isn’t necessarily supported in the Windows Server 2008.

When troubleshooting my issues, I came across Windows Server catalog of tested products -site, where you can get some idea about supported hardware and software. Remember, many things have changed during the last 5 years and some of my components were old even then :D

Here is the hardware that caused problems for me:

  1. I had no DVD-drive on my server :D This hit me first as I hadn’t even considered it could be an issue. The server had some old SCSI CD-ROM drive but as the Windows Server 2008 comes on a DVD-image, it didn’t help much. Luckily I found some old IDE-DVD-ROM that worked fine.
  2. Windows Server 2008 didn’t recognize my Adaptec AHA-2940UW -SCSI adapter. This hit me when I got to the part in the setup where I was supposed to choose the hard disk – Setup didn’t find any :S Windows Server 2003 drivers didn’t work, but luckily Vista drivers worked. I put them on an external USB hard disk where it found them and I could continue.
  3. Finally, I have a backup mirror raid setup on Promise FastTrak TX2000 controller. It wasn’t recognized automatically, either, but after installation I got it to work through the Device Manager with Windows Server 2003 -drivers. Phew.

So, before starting the installation, take note of your hardware (especially legacy ones) and put the drivers to some easily accessible location, like some USB-disk or thumbdrive.

5. Post installation tasks

Except for the driver problems above, rest of the setup went without hitch. What happens next is the initial things to do after logging in.

First you should configure the computer name, domain/workgroup, IP-settings, virtual memory, users etc. This is easily done in the Initial Configuration Tasks -tool that collects everything together. Sweet. Changing of the computer name requires still rebooting, bummer. This was one place where the screen captures of IP-settings etc helped. I haven’t memorized my external DNS-addresses, for example.

Next you need to choose which server roles you want. This is subjective to your needs, but I decided to go with the following developer-oriented roles:

My server roles for Windows Server 2008

It is also a good idea to take captures of the settings, should you need them later, like in disaster recovery. After that you can choose which features to install.

Activating the Windows Server 2008

I like how you don’t need to enter the product key during the installation, but how it is done after the installation. It makes the installation experience much smoother and faster, as the awkward typing of the long key doesn’t cut the flow.

After the installation I tried to activate the Windows Server 2008, without first entering the product key. I was greeted with obscure “Activation Error – DNS Name does not exist” -error. If you get the same error, enter the product key first and then try activation again.

6. Installing and configuring applications

Finally, after you are satisfied with the configuration of the Windows Server 2008, it’s time to install the applications and updates.

After installing the MagicISO, I installed SQL Server 2005. Windows warns about the compatibility, but mentions that you’ll be fine if you install SQL Server 2005 SP2 afterwards.

To take advantage of all the sweetness that the .NET Framework 3.5 offers, I also installed that. You can download the full setup package from here. If you prefer the web install for some reason, it can be located from here.

IIS7 is one of the features I have waited most and after setting up the database server and accounts, it was time to configure the web server. As the GUI has changed a lot, it may take some time to get used to it, but eventually you’ll find the settings you need. IIS.net is a good place for hints.

I just made sure that I got all the most critical applications to work, but I have still some tasks left to do. Anyway, the hardest part is now behind and the fun is about to start as I can now concentrate on the new features offered by this great platform. I’m especially fascinated about the IIS7 extensibility and what it could be used for tuning the web apps, but that’s an another story.

I’d like to hear about your Windows Server 2008 experiences. Did you have any problems or do you have some tips to share?

kick it on DotNetKicks.com


Windows Server 2008 – first experiences in Virtual PC

February 8, 2008

I plan to upgrade my home/development server during the weekend from Windows Server 2003 to Windows Server 2008. Meanwhile I decided to install WS2008 on Virtual PC for future needs and to see how it looks and works.

I used the free Virtual PC 2007 for running the virtual machines on my work laptop. Here are the specs of the host, to put things in perspective:

image

First I installed Windows Server 2008 Standard and the setup was very simple: just language choices and which hard disk to install and that’s it!

After the setup is complete, you need to provide (a secure) password for the admin. After logging in, you can choose which server roles and features you need. This keeps the operating system in minimum and attack surface very small.

I was also surprised, how fast the setup was and the Windows Server 2008 booted really fast, even in the virtual machine.

Here is a screen shot quite soon after the install, with no added features or roles. Windows Server 2008 run smoothly with only about 1GB of dedicated memory and half of it was still free.

image

Next I wanted to install the Windows Server 2008 Core to practice and test what it could be used for. Maybe I could use it for running AD and DNS at home in a Virtual Server? Maybe to see how IIS7 could be used and extended in limited scenarios.

Anyway, here is a screen shot after installing the core on another virtual machine and login:

image

No GUI, just cmd.exe for user interface. It can be remote managed with MMC etc, but I’ll try and blog about it later. I dedicated about 600MB memory for the core and again WS2008 used about half. I’ll keep on testing, but I’m already convinced it is ready for production use.


Windows Server 2008 RTM x86 now available on TechNet/MSDN!

February 7, 2008

To my delight the 32-bit version (x86) of the Windows Server 2008 is finally available at the TechNet Subscriber downloads (and probably for MSDN Subscribers, too)! The 64-bit version has been available for few days already, but I still can’t move to that on every server at work or home.

What’s so great? Well, for one, I can install Team Foundation Server 2008 on the Windows Server 2008. TFS 2008 isn’t supported on the x64 yet, so it needs the x86-version. Once I get more experience with the TFS, I’ll blog thoughts/tips about it.

Finally IIS7 on server

IIS7 must be the greatest web server available. Finally it can be deployed in production and web applications can utilize it fully. It is completely modular and everything you don’t need can be disabled to make it safer and lighter. ASP.NET integration is more efficient out of the box as there are less layers between the web server and the web application.

Server Core is now an option

Windows Server 2008 can be installed without the GUI (“Server Core”) so it is possible to make a web server (among other roles) with minimum hardware requirements and attack surface.

The only downside is that the .NET can’t be installed on it so ASP.NET on the server core won’t work for now. Luckily Microsoft is working on it. By the way, Server Core has only 25% of the full Window Server 2008 installation + add-ons, which tells something about the footprint. It requires about 1-2GB of disk space. The Server Core blog is good place for tips.

While waiting for the ASP.NET-support, even now you can use the server core with the web server role to distribute static content. Say, if you have a site that deals with a lot of images, you could distribute the images (i.e. images.mydomain.com) through these light-weight web servers to share the load more evenly. Also, Server Core could be used for maintaining DNS and Active Directory.

Now I’ll go back staring at the progress bar… ;)


Windows Vista SP1 RTM maybe released today – Windows Server 2008 this week?

February 4, 2008

Update 18.3.2007: SP1 is now available for everybody!

Some rumors say that the final version of the Vista SP1 would be released today! At the time of posting this, the latest version in the TechNet Subscriber Downloads was still Release Candidate, but we’ll see.

Also, Windows Server 2008 RTM should be released very soon. This means that web sites can be soon deployed on IIS7 for production use (I’m referring to those of us who don’t run pre-RTM-releases)! :)

The SP1 of the Vista also updates the IIS7 to be equal with the IIS that comes with Windows Server 2008. There are some breaking changes that are described well in a IIS 7.0 -blog.

Update (4.2.2008, 16:00 GMT):

  1. Now details are getting official and here is the press release about the Vista SP1 and Windows Server 2008 RTM.
  2. This post from the Windows Vista Team Blog gives more information about the Vista SP1. Check all the related buzz from the Techmeme.
  3. Engadget reports that the general availability of the SP1 won’t happen before March (refers to the press release), but I’m sure it will be released much earlier through the MSDN/TechNet Subscriptions etc, since…
  4. “Windows Server 2008 Datacenter, Enterprise and Standard (x64)” is already available for download for TechNet Subscribers (DVD, 2542MB)! :) Windows Automated Installation Kit 1.1 and MUI (x64) are also available through the Top Downloads.
  5. There is also a readme about Windows Server 2008 which tells what’s coming:

Editions

Languages

Windows Server 2008 Datacenter, Enterprise and Standard (x86)

English, French, German, Japanese, Spanish

Windows Web Server 2008 (x86, x64)

English, French, German, Japanese, Spanish

Windows Server 2008 for Itanium-based Systems

English, French, German, Japanese

Windows Server 2008 Datacenter, Enterprise and Standard without Hyper-V (x86, x64)

English, French, German, Japanese, Spanish

Windows Server 2008 Multilingual User Interface Language Pack (x86, ia64)

English, French, German, Japanese, Spanish

I’m sure Vista SP1 will be soon available, as well.

Original source for this post, Techtree:

A Malaysian Web site that goes by the name, Tech ARP, has reportedly said that Microsoft Corp will be today releasing its Windows Vista Service Pack 1 (SP1).
Windows Vista SP1 will be released to manufacturing (RTM) today, while computer makers will get to install the updated operating system on new desktops and laptops only later this week.

And Vista SP1 will be released in two phases. The first phase is today with SP1 being released in five out of the 36 available language packs, which includes English, French, German, Japanese, and Spanish.
The second phase is scheduled for nearly one to two weeks later when Vista SP1 will be released in all 36 language packs.
Microsoft will also offer Windows Vista SP1 through Windows Update, Microsoft Update, and possibly Windows Server Update Services (WSUS).
Meanwhile, the last Windows Vista SP1 build was released on Jan 24, 2008 to a select group of around 15,000 testers.
If Microsoft indeed releases Windows Vista SP1 today, that’s what the company has been promising all along, saying that Windows Vista SP1 will go final sometime in the first quarter of this year which ends on March 31, 2008.
Apart from the Malaysian Web site, some other sources have said that Microsoft Windows Server 2008 will also release to manufacturing in the coming week.