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.”


WorldWide Telescope public beta available for download

May 13, 2008

wwt_icon1 Microsoft has just released a public beta of the WorldWide Telescope.

"The WorldWide Telescope (WWT) is a Web 2.0 visualization software environment that enables your computer to function as a virtual telescope—bringing together imagery from the best ground and space-based telescopes in the world for a seamless exploration of the universe."

You can download it from here for PC and Mac (with Boot Camp and Windows). Requires .NET 2.0 and DirectX.

First try

I tried the WWT very briefly and initial reaction was a bit "meh", but the more I played it, the more I liked the experience. I didn’t have  time to try all the features, but I like the intuitive navigation and "flying effect", when choosing destinations. It’s easy to find familiar destinations through collections and cool just to explore randomly.

It is a really nice experience for those interested in astronomy and a very good learning tool. There are many community options to share tours etc.

Here are some screens:

Orion Nebula Saturn Finder Scope (right-click)

Yes, this is the product that made Scoble cry :)


Windows Vista SP1 finally generally available

March 18, 2008

I just read from a reliable source that Windows Vista SP1 is finally available for download through the Download Center or Windows Update. There are both x86 and x64 -versions available.

I installed it a while ago and so far I haven’t had problems at home (Vista Ultimate) or work (Vista Business). Reserve some time for it, though.


Windows 7 aimed for 2010 release

March 14, 2008

I just read that Windows 7 possibly comes in 2010 or once it meets the quality bar for the release.

See related news/discussions from the Techmeme.

We’ll see, how that turns out. Whatever the timeline is, I’m sure Microsoft is this time much more careful before promising what features it will contain.

Anyway, developers on Microsoft-platform are not that tied to the operating system releases as they used to be. New .NET and Visual Studio -releases are much more exciting and they are not that dependent on the underlying Windows-version.

Windows Server 2008 was an exception though, as it is really good release, especially with IIS7 which makes it a great application server.


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 Vista SP1 installation experiences

February 16, 2008

Yesterday I downloaded Vista SP1 RTM from the TechNet Plus -subscription downloads.

Installing Vista Service Pack 1 on a Dell -laptop

First I installed it on my work laptop (Dell Latitude 830) and it went alright without problems. On the surface it is hard to see many big changes after installation, but haven’t explored much, anyway. At least waking up from the sleep seems faster and more reliable than it was before SP1. It is almost as fast as waking on our home laptop, MacBook Pro.

Anyway, no problems at all with the work laptop and all the apps (Visual Studio 2008, SQL Server 2005, Office applications etc) have worked just fine so far.

Installing Vista Service Pack on the home desktop

Today I wanted to install the SP1 on my home desktop and run into one problem because of a MUI language pack. I got this error, that said:

"Windows Vista Service Pack 1 cannot be installed on your computer because the language of Windows Vista you have installed is not supported or you have installed a language pack that is not supported. Windows Vista Service Pack 1 can only be installed on computers running the English, French, German, Japanese and Spanish versions of Windows Vista or computers running only those language packs."

Install Windows Vista Service Pack -error

I have Windows Vista Business at work and Ultimate at home. I don’t remember installing any language packs, but it could be that I have chosen some Finnish language pack from some Ultimate Extras -update. I always use English version, anyway, so not sure why I have done it.

Anyway, this was easy to fix and here are the instructions to those of you who run into the same problem. This will most likely affect many international users that have multiple languages. Other option is to wait until the SP1 support comes to your language pack of choice, but it could mean several months of more waiting.

First, go to the Control Panel / Regional and Language Options and check that you have some additonal language installed. I had "suomi" which means "Finnish":

Regional and Language Options -dialog in Vista

Then select the Install/uninstall languages … -button and you should see this dialog:

Install or Uninstall Display Languages -dialog in Vista

Select the language(s) you want to uninstall and Next and the uninstall begins:

Removing Languages from Vista

After the process is finished, you are required to reboot. Windows configures itself for a while and then you can restart the Vista SP1 installer:

Install Windows Vista Service Pack -welcome screen

The problem is gone, woo-hoo!

Windows Vista Service Pack 1 License Terms

Remember to read every word carefully ;)

Install Windows Vista Service Pack 1

Installing Windows Vista Service Pack 1

At this stage I could use the computer while the first progress bar went to the end. I spent the time writing this post ;) After that you have to use another computer or do something unrelated to computers *gasp* :D

After three stages of waiting and logging in you should be greeted with this message:

Windows Vista Service Pack 1 successful


Now downloading Vista SP1 RTM from the TechNet Plus…

February 15, 2008

Update 18.3.2007: SP1 is now available for everybody!

It has been hard to predict when the Vista SP1 RTM would be actually available. As it turns out, it is officially available at least to a bit wider audience than just OEM’s.

While browsing through usual list of RSS-feeds, I noticed through the TechNet Plus Blog that the Vista SP1 RTM is finally available for download for TechNet Plus Subscribers and MSDN Subscribers.

Unfortunately Vista SP1 RTM isn’t widely available for non-subscribers yet, but I’m sure everyone can find it with some looking from alternative channels…

For official general availability the dates posted here still apply (mid-March).

Update:
Some TechNet Plus subscribers have had problems finding the actual downloads. Read this, if you share the same problem.


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… ;)