Tuesday, 29 July 2008

DNS Update is an absolute requirement

Lately, we have seen a lot of news on the wire and in the blogosphere about vulnerabilities in our DNS setup.

The news is such that Microsoft has reissued a Microsoft Security Advisory (956187).

The threat is immanent, and we should be patching all of our client systems.

From the above Security Advisory:
Microsoft released Microsoft Security Bulletin MS08-037 on July 8, 2008, offering security updates to protect customers against Windows Domain Name System (DNS) spoofing attacks. Microsoft released this update in coordination with other DNS vendors who were also similarly impacted. Since the coordinated release of these updates, the threat to DNS systems has increased due to a greater public understanding of the attacks, as well as detailed exploit code being published on the Internet.Microsoft is not currently aware of active attacks utilizing this exploit code or of customer impact at this time. However, attacks are likely imminent due to the publicly posted proof of concept and Microsoft is actively monitoring this situation to keep customers informed and to provide customer guidance as necessary.

Microsoft’s investigation of this exploit code has verified that it does not affect Microsoft customers who have installed the updates detailed in Microsoft Security Bulletin MS08-037. Microsoft continues to recommend that customers apply the updates to the affected products by enabling the Automatic Updates feature in Windows.
Threat Level has some good background information on the who/what/where/when: A little work is in store for those of us who have not patched yet. :)

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Monday, 28 July 2008

Trend Email Hosted Reputation Services now InterScan Messaging Hosted Security

While we have been implementing Trend Micro's AntiVirus solution at our client sites, a few of them have also expressed an interest in the spam filtering offered by Trend.

Our first client was setup using the Email Hosted Reputation Services (EHRS). The service did help to reduce spam over the Exchange IMF setup.

Recently, Trend went through an update of their antivirus products and the hosted spam filtering. The new filtering is called InterScan Messaging Hosted Security (IMHS).

We switched one of our existing clients over to the new IMHS service and unfortunately have been having nothing but grief since. Spam that was not coming through before is now coming through in spades.

We waited the obligatory 48-72 hours to make sure the MX record changes had taken, and still things have not improved.

The straw that broke the camel's back: A bounce message forwarded by one of their clients saying that the attachment size was too large ... at 4MB ... with Trend's server name listed as the culprit.

Since this client is one of our key clients, we are not about to go any further with the service.

Since the previous EHRS services will no longer be in effect, we will default back to the Exchange IMF for now.

For the most part, things were working fine before EHRS, worked a bit better with EHRS, but have taken a big step back with IMHS.

While we are relatively happy with Trend's A/V, we will no longer be selling what is now the Worry-Free Business Security Advanced which includes IMHS. We will stick with the Worry-Free Business Security product for now.

The other side to this pickle: With the advent of SBS 2008, which will include ForeFront and Windows Live OneCare 120 day trials out of the box, if we choose to install them, we may look at going Microsoft on the entire platform. This reduces our install and configuration time too.

Since we are selling 100% Open Value Agreements to all of our clients, and have been for quite a while now, adding ForeFront and OneCare to our client's Open Value Agreements when it comes time to upgrade their refreshed hardware will be a small step.

We shall see ...

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

SBS - Companyweb and Office 2007 Documents

When there is a need to setup document libraries for Office 2007 documents, the current SBS SharePoint V2 Companyweb site does not know what to do with them.

To get that fixed, David Overton has an excellent post: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007.

Take note that one will need to run the following on each workstation, XP or Vista, that will access the Office 2007 documents on Companyweb:
reg add HKCU\Software\Microsoft\Office\12.0\Common\Internet /v OpenDocumentsReadWriteWhileBrowsing /t REG_DWORD /d 01
This command is via David's post, but must be emphasized as the Office 2007 documents will always open in Read Only mode without it.

As per David's post which links to the following Knowledgebase article: KB 870853: Office 2003 and 2007 Office documents open read-only in Internet Explorer.

David, thanks for sharing that. It has come in very handy!

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Friday, 25 July 2008

Payment for services - Honour and our Word

A while back we were brought in to help a fellow IT company owner by one of our local suppliers that we have been dealing with for years.

The IT shop had an older SBS setup that had a choked SMTP queue.

As we do with all drop-in situations, we outlined our hourly charges, resolution or not, and made sure that the business owner agreed to them ... which he did. We also have the local admin person create a user and password with domain admin privileges as a precautionary measure. That way they can delete that user when the job was finished.

Well, it is now almost four months later, and they are refusing to pay us for our time.

The SBS box was not setup properly. The wizards were not used and the Exchange box was an open relay. While we worked hard to get things right, the plugged queue just kept growing ... so the suggestion was made to swing to new hardware ... to which the business owner indicated they wanted things worked out instead.

Eventually, the owner decided to take over themselves, wipe the box, and let us go. We set our invoice and indicated we would reduced our time billed (bad mistake - never devalue our own time), and he agreed.

Where does the perception come from in our industry that if the task at hand could not be accomplished that our time is worth nothing?

Take a car into a shop to be worked on and try to get it back without paying ... even if the shop did not find a resolution to the problem. That just will not happen.

Then why is it an acceptable practice to not pay us for our time on the job no matter what the problem status at the end of the day?

We are professionals, and just as mechanics we know that some situations cannot be resolved at the drop of a hat. Usually, that means that after a half an hour to an hour of scoping out the situation we are already providing feedback to the client or customer (they are different) that we may not be able to "fix" the problem.

We begin to offer options to either work out the problem, with no guarantees, or we are saying it may be a lot more expedient to move on to other options.

It is a sad day when we encounter a situation where a handshake is not honoured. It is even sadder one when the person we shook hands with is in our own industry. Not honouring one's commitments says a lot about the character of the business owner and their employees who may be shaking hands on their behalf.

One of the key ways that we establish long term client relationships, in our case we have some spanning 10 years now, is by honouring our word. Our commitments are our gold. If we cannot honour our commitments with our clients and with others in our respective industry, we cannot expect to build our business up.

We are in the relationship building business ... I.T. just happens to be the vehicle we are using to get there.

When we have realized that, then we will be hiring people on who will be open to fostering those business relationships and to being formed into the type of I.T. Professional that can be counted on to follow through on their commitments.

The customer may always be right, but the client knows their options and our professional opinion on the direction they should proceed in. That is the difference between them.

Working together, we the I.T. support firm and our clients, along with the strong supplier and vendor relationships we have built, create and maintain a long term technology infrastructure and user skills vision. Along the way, we make sure to form our employees in that vision.

So, now we are in the awkward position of needing to collect on the aforementioned debt. In our five+ years of business, we have only had one payment situation go bad. It is unfortunate that this situation is turning out to be our second. :(

UPDATE 2008-08-11: It seems that paying a personal visit to the I.T. company in question did the trick. A technician appeared from the back, acknowleged my request, and called the owner to indicate that I was there. A cheque soon followed.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Thursday, 24 July 2008

SBS 2003 to EBS 2008 Migration Guide

A new migration guide has been released for those who support clients that have grown close to the transition phase of the SBS lifecycle and are looking at EBS as the possible direction: Migrating from Windows Small Business Server 2003 to Windows Essential Business Server.

The document comes in three flavours: The methodology looks to be similar to the process we would use to insert a new SBS server into an existing Windows domain.

The document gives a good overview with the required steps to complete for the migration.

Courtesy of the MS Download Center RSS Feed.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Wednesday, 23 July 2008

Royal Bank of Canada - Banner Ads while online banking?!?

Recently, it seems that the Royal Bank of Canada has decided that they need to banner ad some of their products and services while we are doing our online banking:

RBC Product Banner Ad

The above banner ad appeared after completing a bill payment online. That banner ad was also present when completing a personal transaction. Note the banner's URL it is pointing to is outside the RBC secure online environment.

This practice is just plain wrong in so many ways.

It took the banking industry a long time to overcome the overwhelmingly negative psychology of doing our banking online. In my case, it took one of my former employers over a year to convince me just to try it.

Yes, once online, I was hooked. However, for the right or wrong reasons, it was very difficult to get me to that point.

To me, this is like depositing a product salesman into my living room without my permission to sell me something.

That "living room" experience for my online banking was one of the keys to getting comfortable with doing my banking online.

Perhaps for many that are used to having banner ads in their lives in virtually any online experience this may not be a problem.

But, our online banking is tied to our entire livelihoods. Any mistake on the part of the bank or a flaw in a browser that allows someone to somehow compromise my online session should be avoided.

And, for Pete's sake, I see banner ads everywhere! Do I have to see them while I conduct my personal and business online banking?!?

Again, I may be totally off base since I am not a browser coder or Internet security guru. However, perception is 80% of the battle...

The other aspect of this that really gets me: We are paying for our online banking service.

To put it another way: We are now paying the bank to advertise to us ... much in the way the movie theaters realized that they could get away with 10 minute mini commercials prior to the movie starting.

We pay for the online banking service through our business. We pay a flat fee to the bank for our personal online service.

If the bank wants to sell us something, do so through the company's regular Web site.

Next stop: Letter to RBC's President and CEO Gordon M. Nixon, Barbara Stymiest COO, and the RBC Office of the Ombudsman.

There are some things in life that should be left alone ... and our online banking experience is one of them.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

SBS - Trend Worry Free Business Security Event ID 537

Over all, we have been quite happy with the Trend Micro Client/Server/Messaging SMB product.

It installs fairly smooth on the server and relatively smooth to the clients.

In one case, we have upgraded our client's SBS server and the client machines to the new version of the product called Worry Free Business Security.

This is the first SBS box that we have done this on with others to follow.

Since the upgrade, we are seeing the following in the morning reports:

Security Event ID 537: An error occurred during logon.

Notice that there are a lot of them.

The only indication that we are dealing with a Trend problem is from the Microsoft SBS newsgroup here: Failure Audit 537 in Event Log. Our circumstances are identical to the newsgroup poster.

So, we too have opened a trouble ticket with Trend to further investigate the problem.

For now, we will not be upgrading any further SBS boxes.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Tuesday, 22 July 2008

The General Gets Our Vote - HHR SS Panel Arrives in 6-8 Weeks!

I love cars. :D

I started working on them in my late teens, and grew attached to the smells, sounds, and speed of 350 horsepower small blocks, 400-500 big blocks, and later the multi-valve small displacement engines pulling all sorts of cars into all sorts of crazy speeds.

For the last 6 years or more, I have owned a 1997 Ford Taurus V8 SHO.

It has been a very reliable, very fast, and very maneuverable mode of transport. For both street and track I could ask for nothing better for my money.

But, at 10 years, the reliability ratio to the age of the car is starting to equalize. No serious repairs done to date ... yet. So, do we want to spend any money on a 10 year old car versus putting that money into a new one?

From a business perspective the answer is a resounding no!

On the hunt for a replacement in the last year or so, there were many contenders to replace the SHO. But, none really stood out from the pack.

The key elements that needed to carry forward from the SHO:
  • Reasonable power (200bhp+).
    • Too many times in this city the power is required to escape others concentrating on other things.
    • The power is important for highway travelling which we do a fair amount of for our business.
  • Reasonable fuel consumption (when not into the throttle).
    • SHO gets 340KM on 60 litres consistently for years in the city.
  • Handling must be on par or vary close to the SHO's Semi Active Ride Control.
  • Better product carrying capabilities than the trunk or back seat of the SHO.
While doing an install at a client site, the phone system technician was in working on setting up the phone system integration into the SBS network with me. He had an Chevrolet HHR Panel as his company transport.

What caught my eye was the lack of glass in the rear passenger doors. Right away, the element of security came to mind for any system or component contents that may be in the vehicle while parked.

The other thing that struck me were the lines. On the Wikipedia entry for the HHR (Heritage High Roof), the styling cues pull from the 1940's era Chevy Suburban 2 door. Neat.

This last weekend the dealer provided an HHR SS that was the standard 4 door layout for me to scoot about with on errands and to take Monique for a spin.

What a lot of fun that drive was. The vehicle is stable at any speed, in corners, into twists and turns, and flat out a blast from "not to 60" in a shade over 6 seconds.

GM's quality, fit, and finish have come a long way over the last couple of decades ... and that really shows through in the HHR I got to play with.

So, we signed on the dotted line for one. We should see it in about 6 to 8 weeks.

Anyone looking for an excellent second car, or primary get-about, that has power to spare, the Taurus SHO is now available. ;)

Any suggestions for logos and the like for the sides and back? The HHR SS Panel will be black with an ebony interior.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Monday, 21 July 2008

Time to walk away ...

When is it that time?

We hear many different ways of describing our clients.

The main categorization that seems to stick in our minds here:
  1. Class A: Trusted Advisor Relationship.
    • Do what needs to be done.
  2. Class B: Consultant building towards Trusted Advisor.
    • Let's talk about what needs to be done and then do it.
  3. Class C: Other.
    • New prospects, occasional clients, others.
So, when we come across a situation where the prospective client, or even a relatively new client, does not seek to build a business relationship with us, what do we do?

We take the time to fully evaluate our communications and prospective relationship building with that new client.

If the "spider sense" is tingling (this is where really good communication with the techs and others in contact with that client pays off), or there is a clear "expecting something for nothing" flag, or anything along those lines, then it is fairly clear where we need to go:
Mr./Ms. Client,

Thank you very much for taking the time to approach MPECS Inc. with your current SBS and I.T. infrastructure needs.

However, due to a number of new and ongoing I.T. infrastructure projects, our technicians are now booked well into the late Fall time frame.

Thus, we will not be able to help you out at this time.

Thank you again for approaching us.

Philip Elder President & CEO
MPECS Inc.
Maintaining a simple and polite brevity is of import here. An apology is not needed as we have done nothing to offend by politely declining their business.

No matter what the financial status of our own company is, whether we are in Feast or Famine mode (not so applicable for us anymore due to our hybrid managed services setup), we must always keep in mind that our business' integrity comes before our need for cash flow.

Allowing a company, or person, to take advantage of us for our skills and abilities in order to make some cash flow happen benefits no one. And, in the long run it can establish a pattern of business behaviour in us that may end up destroying us and our company.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Friday, 18 July 2008

Hyper-V Gadget for Windows Vista Sidebar

We manage a number of internal Server Core Hyper-V servers as well as client based Hyper-V servers.

Up to now, we have been using the Remote Server Administrator Tools (RSAT x86 and RSAT x64) on Windows Vista SP1 to manage them.

One of the things that was missing with RSAT was an at-a-glance setup for our Hyper-V systems.

We now have one: the Hyper-V Monitor Gadget for Windows Sidebar by Tore Lervik.

Windows Vista Hyper-v Monitor

We have the ability to add all of our Hyper-V instances to the monitor, configure the user that will authenticate to them, as well as perform some basic VM management like turning them on and off.

This is an excellent little gadget to have.

Thanks to the Virtual PC Guy for the tip: Hyper-V Sidebar Gadget.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

SBS on Dell with PERC5i drive failure and DIY

We were invited into one of our neighbour's office to have a look at an SBS box that was not doing too good.

The setup was put together by the business owner with a little assistance from Dell.

By the time we were done, we had spent 10 hours at the location to get things setup correctly.

The server was headless, so we needed to walk back to the shop and pick up a small LCD monitor, a keyboard, and a mouse.

The business owner took care of plugging in the keyboard and mouse on the front of the server while we worked at connecting the monitor at the back.

Once logged into the server, we began the process of bringing the setup online.

The straw that broke the proverbial camels back: The owner had purchased a Linksys wireless N router and could not get it to setup properly. So, they called Linksys. Apparently Linksys had them disable DHCP on the server manually, enable it on the router, and get the wireless setup for access.

Keep in mind that none of the SBS 2003 R2 Standard key features were being used. Remote Web Workplace was not being used, SharePoint, and more. The R2 Technologies disk had not been installed as well, so no WSUS or integrated WSUS management or Exchange SP2.

The owner was connecting to the server via 3389 along with anyone else who needed bookkeeping and other application access. Do we all know what permission levels those users had?!? Yep: domain admin rights.

We essentially needed to run through our SBS 2003 R2 Setup Checklist (previous blog post) to make sure we made the necessary changes.

Once we had the server running stable, we needed to go to the client computers and work on getting them correctly connected to the SBS network. The ConnectComputer wizard was not used.

While working on the Setup Checklist, a trip back into the shop area where the little server cabinet held the 2650 caused a bit of a panic: Both the status light and the activity light were blinking yellow in unison on one of the two drives in the RAID 1 array.

Eriq Neale blogged about this situation last year:
The PERC 5/i has no audible alarm on it.

The business owner in this case, had no backups in place!

So, for who knows how long, their business was hanging by a thread ... their whole livelihood was on one hard disk that could have followed its partner.

Once this situation was discovered, we immediately grabbed our ShadowProtect I.T. Edition disk and a USB hard drive, rebooted the server into the ShadowProtect Recovery Environment, and created a full system snapshot.

Dell had us download a utility to run tests on the system which turned up all positive. This was a bit on the strange side. So, the technician had us pull the "defective" drive and reseat it. Sure enough, the array started to rebuild.

The Dell technician assured us that this was a "common" support call problem that they deal with. Apparently things like power outages, as explained by our Dell technician, can knock one of the drives, or even both, out of the RAID array.

This particular SBS server had an APC ES series 750VA for a UPS, but no protection on the ADSL telephone or Ethernet setup. The UPS was not tested while we were there.

This explanation by the Dell technician came as quite a surprise as the drive failures we have experienced have been extremely rare relative to the number of servers we have at production sites. And, those drive failures tended to be just that: Drive failures.

By the end of the day, we had a fully functionally SBS 2003 R2 Standard box, DNS and DHCP on a proper IP range and functional, Remote Web Workplace and all its features, desktops reasonably connected to the SBS network, and email Exchange integrated.

Some further training will be required to get the users up to the task of utilizing the full compliment of SBS features.

This situation really causes us to pause when it comes to the Do It Yourself (DIY) type of setup. We have encountered so many situations where the SBS setup was done by the business owner or a friend of the business owner where things were precariously close to total loss or there was no security on the Internet facing services.

There is a reason why a certified professional with actual experience with the SBS product should be driving it. And this example is but one where things are very clear that a Small Business Specialist company with experienced SBS technicians should be on the job.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Thursday, 17 July 2008

Intel SR1560SFHS + SRCSASRB USB HDD lockup

One of the last things we do before putting a server into production is blow it away and restore it from the backup we create just before.

In this case, we are dealing with the ShadowProtect image of the new server that served as a replacement for this crashed server (previous blog post).

There are two particular purposes for this recovery:
  1. Test restore of the production server. We provide this service on a quarterly basis for most of our clients with some opting in on a monthly recovery test.
  2. Work with an exact replica of the production Exchange Information Store database as it is not behaving.
Since we managed to salvage the Exchange store from the somewhat corrupted ShadowProtect image, the store will mount, but it will not do so on its own. After a reboot, the store needs to be manually mounted via the Services.msc console.

We ran into a bit of a peculiarity in that the server we are restoring is the soon to be production server at another client that is identically configured.

After booting the ShadowProtect Windows Vista Recovery Environment, loading the SRCSASRB drivers and running the first volume's recovery the system was locking up. No matter what we tried, even going so far as to remove the hard drive from the Thermaltake Silver River Duo enclosure and connecting it via a Thermaltake BlacX SE USB hard drive connector, the system still locked up.

A couple presses of the Num Lock key on the keyboard would bring about a red trouble light on the front of the SR1560SFHS chassis.

The firmware on the motherboard, FRU, and SDR were up to date. But, as it turns out the firmware on the SRCSASRB RAID controller has a new update this last week.

After running the update for the RAID controller and rebooting back into the ShadowProtect Vista Recovery Environment, we were able to initiate a successful series of recoveries for the three volumes on this array.

Links to previous posts on the above crashed server: More to come on the Exchange issue.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Wednesday, 16 July 2008

My very first magazine article is published! :D

One of the neat things to come out of my trip to Toronto for the SMB Nation event there was an invitation from Harry Brelsford of SMB Nation to write a technical article for the SMB Nation Magazine: SMB Partner Community Magazine.

The article is focused on Small Business Server 2008 and is now available at the above link!

If you register on the SMB Nation site, if you have not done so already, you can receive a free mailed copy of the magazine anywhere in North America.

Thanks again for all of your support and encouragement folks! :)

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

Some thoughts on Microsoft's new SBS Support Policy

There have been a number of articles written by various SMB or key technology folks over the last while indicating that the solo shop or fly by the seat of the pants consultant should see the writing on the wall.

Some links:
With the upcoming changes that Microsoft is implementing for business critical support for SBS products, the consultant calls in for that support creates an incident and will receive a call-back from Microsoft Product Support Services to work on the problem.

When Microsoft announced the changes to the Business Critical Support (BCS) policy, there was a lot comments on the "fact" that charging for BCS was a bad idea.

This begs the question: Why is it a bad idea?

We operate an I.T. business that generates its revenues via providing implementation and support services for a variety of manufacturer's products. In most cases, we may have a FAQ, forum, or knowledgebase (Live search), or other such support mechanism provided by the manufacturer.

The key here is that we provide products and services for a fee. We do not provide them for free. We may make small allowances for our clients that spend a good portion of their I.T. budget with us, but we ultimately charge for our services.

While there are manufacturers that do provide some sort of free technical support for their partners, things can get out of hand. Just ask Vlad here: Things that piss Vlad off: SMB Enterprise White Paper, and here: Hacking OWN Support: DRaaS Encyclopedia, and here: Should free content creators be commercially compensated for giving away things for free? Check out his blog for more: Vladville.com (Live search for RTFM).

Microsoft is no different than us as far as providing products and services for a fee.

Yes, we are supporting Microsoft products ... but with the understanding from our client's perspective that we are trained on those products.

This bears repeating: We are supposed to be Professionals. Essentially that means that we are thoroughly knowledgeable in the intricacies of the solutions we design, implement, and support.

We have taken the time to pay for training, certification, technical books, technical mentorship, and business mentorship to build up our product and business knowledge as well as the product and business knowledge of those that work for us.

Coming back to Microsoft and their support policy for those of us that support the SMB with a specific focus on SBS: It is in Microsoft's best interest to charge for that service.

While the $8,000 a year support policy that enables one to get front line support might be a little high for those of us with a one or two person shop, we can certainly pay $4-5,000 a year for the service.

That $4-5K a year is an insurance policy for those times where there is absolutely nowhere to turn when things go sideways. That fee would weed out most of the calls that have absolutely no right to be in the BCS queue. Having that fee would eliminate the need to outsource ... giving us the assurance that the person on the other end of the phone will indeed know their stuff.

Ultimately, it would give Microsoft the opportunity to recognize those Partners that were willing to invest in their own and Microsoft's business presence ... and perhaps focus their partner building with them.

If Microsoft does offer such a support policy oriented to the SMB/SBS Partners, we would be first in line to sign up.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.

SBS 2003 Premium - KB948110 SQL2K MS08-040 Caveat

One of our SBS 2K3 Premium servers stalled while running the security update for SQL 2000 KB948110: MS08-040: Description of the security update for SQL Server 2000 GDR and MSDE 2000: July 8, 2008.

We made sure to run the server updates first, then the Exchange ones, then we went to the SQL 2005 update for Service Pack 2.

After that, we ran the above update leaving WSUS V3 SP1 for last.

Susan makes a good point about SQL patching in her blog post: The Mess of SQL Patches. Essentially we can leave them lie for the most part.

Since we were here at the client site to talk about their upcoming server refresh, we also brought their backup drives to rotate out too.

Both servers needed updates so we ran them incrementally on both. We have the SBS 2K3 Premium SP1 with Windows Server 2003 SP2 installed and a Windows Server 2003 R2 Standard acting as a data mirror and second DC.

The Server 2003 R2 box took its updates with no issues.

The SBS 2K3 box hung up during the SQL 2000 update at the point of extracting the files. At least, that is the file process that came up when we tried to cancel the task and subsequently End Task on MSIEXEC when things had not changed 10 minutes later.

We ran an update to ShadowProtect to version 3.2 which also requires a reboot.

So, we rebooted the box and ran the WSUS SP1 update successfully.

For those running SBS 2K3 Premium and Standard there are caveats for this particular SQL 2000 update:
  • SharePoint users who upgraded from SQL Server 2000 Desktop Engine (WMSDE) to any other edition of SQL Server 2000 (for example, SQL Server 2000 Standard Edition) may be incorrectly offered a WMSDE update for this security release. This problem can occur if the SQL Server 2000 edition is not patched correctly with SQL Server 2000 Service Pack 4 after the upgrade from WMSDE. The WMSDE update may cause SharePoint to stop working. To resolve this problem if this occurs, follow these steps to restore SharePoint functionality...
  • Microsoft Internet Security and Acceleration (ISA) Server 2004 and ISA Server 2006 could be affected by this update in the following ways:
    • The MSSQL$MSFW service is stopped and then restarted when the associated database instances are updated. This action occurs if Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is installed on the computer that is running ISA Server. This action also stops the Microsoft Firewall service. Therefore, the SQL Server installer tries to return the Microsoft Firewall service to the same state that it was in before the update was started. Because the update installer cannot control services on a remote server, you must monitor and possibly restart the Microsoft Firewall service and the dependent services if ISA Server is configured for remote SQL Server logging.
  • ISA Server 2006 installs MSDE 2000 together with SQL Server 2000 SP4.
Take note of these issues prior to installing. Make sure to have a good backup ... just in case.

Links: Philip Elder
MPECS Inc.
Microsoft Small Business Specialists

*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.