http://timjacobs.blogspot.com/2008/06/sql-server-2005-express-edition-on.html

It’s copied here in case his blog ever goes away.  Thanks Tim!

While experimenting with the Microsoft App-V 4.5 Release Candidate (more on that soon), I decided to go for a full-blown installation on Windows 2008 x64. Since this is only on my home network, I don’t run a dedicated SQL server so I went for the natural choice of installing SQL Server 2005 Express Edition SP2 on my freshly installed Windows 2008 x64 App-V server.

This turned out to be less trivial than I thought. The short answer is: if you want to have a painless install of SQL Server 2005 Express Edition, take the download that includes the “Advanced Services” and simply don’t install them. The “smaller” download package does not include some necessary files for a successful x64 installation.

If you want to go the hard way and patch the setup for easier automated deployment (or just to be ‘1337 and be able to say that you fixed Microsoft’s SQL Server installer for 64-bit systems…), then follow these steps:

• First of all, you should know that SP2 is the first Vista/Windows 2008 certified edition (think UAC, think session zero hardening, think enhanced security). Secondly, SQL Server 2005 Express Edition SP2 is supported to run under WOW64. That is very comforting to know, and I hadn’t expected a true 64-bit edition for free. So why does it complain about installing a 32-bit version on a 64-bit machine then?

  
  “The installation package has a missing file, or you are running a 32-bit only Setup program on a 64-bit computer”

  Of course, what you don’t see is that SQL is first installing the SQL Native Client in the background (as a prerequisite) and the error message conveniently forgets to mention that this is in fact the installation that is not succeeding. The error message was indeed accurate, but the error was not that I was trying to run a 32-bit installer on a 64-bit machine, but that the 64-bit installer for the SQL Native Client is not included in the package! What’s even worse, some other essential x64 packages are also not included in the smallest SQL Express 2005 SP2 download.

• So you have to include the missing files manually:
  1. Download the “SQL Server 2005 Express Edition SP2 with Advanced Services” package.
  2. Run both the SQL Express installers with the /X switch to extract the setup files (to different directories):

     sqlexpr.exe /x
     sqlexpr_adv.exe /x
     

  3. Next, locate the 64-bit SQL Native Client (sqlncli_x64.msi) and 64-bit SQL VSS Writer (SqlWriter_x64.msi) from the Advanced Services setup and copy them to the “Setup” directory of the regular SQL Express installation.

Random Posts

• Get An Ingram Micro Account
• Whoever Contacts The Most Wins
• Computer Service Life
• Requiring Employee Education
• To Certify Or Not To Certify

It is, without question, the one thing that will be remembered and appreciated more than anything else you do. A cheap price comes and goes. Following-up properly will always be remembered.

If you don’t follow-up, your customer will feel like they are in the dark. Like they are not up-to-date on the status of a project or your work. The reality is that in a computer services business you work for them so make them number one. Keep them in the loop at all times.

Customers are always impressed by extra effort. Follow-up is both expected and appreciated. And, since most people don’t follow-up, they will be impressed as well.

It’s such an easy thing to do and it is also the easiest thing to forget to do.

Start remembering.

Zachary M Morvik

Random Posts

• Service Monitor - Updated
• Requiring Employee Education
• Are You Going For The Big Fish?
• You Comment, I Follow
• Contracts Required

http://support.microsoft.com/default.aspx?kbid=883380

Zachary M Morvik

Random Posts

• Tell Me More About Service Contracts
• You Comment, I Follow
• Commuting For Profits
• Whoever Contacts The Most Wins
• The Ultimate Computer Kit

Boom De Yada

Reminds me of what many great things in life.

Zachary M. Morvik

Random Posts

• Never Let Client Domains Expire…EVER
• Requiring Employee Education
• High Probability Selling
• Time is Money
• Computers Should Be Dated Like Cars

Take advantage of the new features in this release. If you are already a customer, download the latest version today. If not, consider purchasing this product!

New Features:

• Allow custom email subject
• If status of service is unknown, send an email and inform user to verify that the service account is a network administrative account
• Allow multiple SMTP servers
• Service sorting
• Modified editability of grid
• Allow for verbose or basic monitoring
• Allow setting and auto-truncate logs (default: 30 days)

Our customers love this product. It’s so simple and so effective. It can literally save your job!

Buy Here

Zachary M. Morvik

Random Posts

• Service Monitoring Software
• High Probability Selling
• Just Replace The Darn Thing
• RFP vs. Time
• Commuting For Profits

There are a million of YOU.

Don’t forget it.  You customer, while they may value the service you are providing, is keenly aware that just as they once found you, they can find another you.

It may take them a little time and have some associated hard / soft costs, but you are replaceable.  Do you know anyone who isn’t?

Keep this in mind the next time you start having crazy thoughts about who is  working for who.

Zachary M. Morvik

Random Posts

• Get An Ingram Micro Account
• RFP vs. Time
• Presentation is Key
• Service Monitoring Software
• Customer Surveys

If you think about it, this is really quite amazing.  The entire automotive industry is based around what year a car was produced.

Then I starting give this more thought and I wonder why computers aren’t the same way.  A computer lasts, or should last, roughly as long as most people keep a car.  That’s 3 to 5 years, give or take.

The customers that I have which adopted the 3 to 5 year rotation enjoy the least computer problems.  They are taking proactive measures to ensure that their business is always running smoothly and the rewards are massive.

It is, sometimes, very difficult for businesses to put a price on loss of productivity.  They don’t know what an hour of downtime costs them.  Or what an hour of downtime of just one person or a single department costs them.  However, they should spend the time and figure this out.  For most, the cost of a new computer every few years is one of the smallest expenses one could think of.  But costs are costs and it just isn’t viewed this way…yet.

So, to all the major computer manufacturers out there, here is my suggestion.  Start dating computers just like cars.  Right in the title.  Not only will you enjoy the same genius marketing benefits that automotive manufacturers have, but you will help solidify all aspects of the computer industry.

It’s a simple win-win.

Zachary M. Morvik

Random Posts

• Discovery Channel Commercial - Boom De Yada!
• Documentation: Minor Case In Point
• Services Monitor Screenshot
• GrandCentral - Intelligent Phone Use
• You Comment, I Follow

Since you are a reader of my blog, I want to offer you a special introductory price.  Here are the details:

1. Read about this software here on the blog
2. Don’t order using the order link on the right, your price is only $35 until the end of Monday. A 65% discount!
3. You can send the $35 to PayPal@ComputerServiceDude.com
4. This offer expires at Midnight at the end of Monday.
5. As it is a weekend, please allow 24 hours to receive the download link.

Thank you for your support.  If you were a beta tester, you are welcome to simply continue using the beta version of Services Monitor or you can download the latest version.  Beta testers do not need to pay to retain a license to use Services Monitor.

Zachary M. Morvik

Related Posts

• Services Monitor Software In Beta Test
• Service Monitoring Software

It’s coming today!

Zachary M. Morvik

Random Posts

• There Are A Million Of YOU
• Running A Computer Services Business
• Services Monitor 1.0.3 Released!
• Templates For Free
• Documentation

Hint hint, I expect the 24 hour special to happen within the next 24 hours.

Zachary M. Morvik

Related Posts

• Weekend Special: Services Monitor
• Service Monitoring Software