Saturday, October 31, 2009

SQL 2005 SP3 install error x80070643

A client needed SP3 installed for their line of business app. For some reason, the service pack failed and would not install. We found the solution in Microsoft’s forums as follows:

  • Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
  • Locate the "Resume" REG_DWORD and change the decimal value from 1 to 0
  • Reboot

This permitted the service pack to install properly.

Saturday, October 24, 2009

Increasing Rule Limits in Exchange

If you’re a heavy user of rules in Outlook, you may have hit Exchange 2003’s 32K quota limit. In Exchange 2007, the quota was increased to 64K as a default but can be changed to 256K.

To do this, open the Exchange Management Shell. To increase the quota for all users, enter the following:

get-mailbox | set-mailbox –rulesquota 256kb

To verify the setting for a mailbox, enter the following:

get-mailbox al | fl rulesquota

The response should indicate the quota for the user.

Thanks to Simon Page.

Saturday, October 17, 2009

Using Machine Names With Windows’ VPN – Revisited

Back in March, we posted about how machine names do not work over a Windows SBS 2008 VPN.

Evidently, we were not alone. This post from Nicholas Piasecki’s blog describes a work around:

  • Click Start > Administrative Tools > Routing and Remote Access.
  • In the tree view, drill down past the server name to IPV4 > General. Right-click the General option and choose “New Routing Protocol” and choose DHCP Relay Agent.
  • Now right-click the newly appended “DHCP Relay Agent” node and choose Properties. Add the IP address of your DHCP server (which is probably your SBS server itself), and click OK. Then click it again and choose “New Interface” and add the “Internal” interface.
  • Now if you connect through VPN, an ipconfig /all should show your domain name as a “Connection-specific DNS suffix” and pinging machines by their suffix-less computer names should work. (If it doesn’t, make sure your DHCP server is using that 015 DNS Domain Name option, which the SBS 2008 wizards set up by default.)

    Thanks, Nicholas!

  • Saturday, October 10, 2009

    Windows Virtual PC and XP Mode RTM’ed

    For those of you with TechNet and MSDN subscriptions, you can begin working with the RTM (release to manufacturing) versions of the new Windows Virtual PC and Windows XP Mode products.

    A few weeks ago, we posted about these companion products for Windows 7; they provide an excellent way for businesses to maintain Windows XP compatibility when moving up to a new PC with Windows 7.

    While we found no issues with older software, we ran into a few hardware driver issues with the prerelease version of XP Mode. We’re looking forward to testing this latest version and we’ll report back with our results.

    Saturday, October 3, 2009

    Cleaning Up Old IIS Log Files

    Older SBS servers with separate system partitions tend to run low on space when they’re not maintained regularly. A quick cleanup is to delete old IIS log files.

    Here’s a great script for keeping things tidy.