Author Archive for KW

SBSMonitoring Database is nearing maximum size

Chances are, if you have an SBS 2008 server, it is running very well. But this may lead you to become complacent in managing the server. For example, it is important that you run the SBS 2008 Best Practices Analyzer on your server on a regular basis. Whether that is monthly, or quarterly, run it!

On a recent SBS 2008 server that has been chugging along quite nicely, I discovered that BPA had not been run in quite awhile. When I did, I was greeted with this warning:

The SBSMonitoring database is nearing maximum size
The SBSMonitoring database is currently 3762487296 bytes in size

image

Wow, that’s nice … except for the fact that the warning message doesn’t tell you what to do to fix it or clean it up. It doesn’t even point you to a KB article.

The rest of this blog post identifies three different solutions to this problem.

 

Solution 1: KB 981939

If you do your due diligence in searching the web, you will come across Microsoft KB 981939. You can read through the KB article for the details, and you may want to give it a try.

When you run their PowerShell script, you may get an error about the execution of scripts. If so, simply type the following command at the PS> prompt:

Set-executionpolicy remotesigned and press Enter

But, wait — there’s a second solution!

 

Solution 2: Replace SBSMonitoring Database

If solution 1 fails, and you go back to search the Internet, you will discover a blog post from Third Tier titled: SBS 2008 Monitoring Database Fills to Capacity.

This solution has you replacing the current SBSMonitoring database with a new clean one. Only one problem: how many people keep a clean copy of their Monitoring database around???

No problem, there’s a third solution, which is the best!

 

Solution 3: Recreate the SBSMonitoring Database

Check out the SBS Blog site for How to Recreate the SBSMonitoring Database.

Simply download the provided zip file, extract the PowerShell script, start up an administrative PowerShell session, and run the script. Voila! It’s finished almost immediately.

image

All that is left is to rerun the BPA and verify that the warning message no longer appears!

Cheers!

Install Exchange 2010 SP3 on SBS 2011

Carl Gray (“Oxford SBS Guy”) has a very good, step by step blog on installing Exchange 2010 SP3 on SBS2011, including screen shots. So, there’s no need for me to replicate what he has already posted.

However, there are two critical steps he did not include:

    1. Before you start the SP3 upgrade, please go into Services and stop the Windows SBS Manager service.
    2. Please make sure that you DO NOT have Windows Management Framework (WMF) 3.0 installed on the server. Look for KB2506143. You will need to uninstall this patch and then reboot the server before you install the SP3 upgrade.

Susan Bradley has previously posted on both of these issues (see Stop SBS Manager and Uninstall WMF 3.0)

I also offer some additional advice to add to his process, which you may find helpful:

  1. When downloading the Exchange2010-SP3-x64.exe file, put it into an empty temp folder (say ..\Downloads\E2010SP3temp). Then when you double click on the .exe to extract all the files, it will extract the files to this same temp folder. Once the SP3 upgrade is completed, all you need to do for cleanup is to delete this one temp folder.
  2. I highly recommend that you make sure that you have a full, recent backup of your server before you start.
  3. I also recommend that you reboot the server BEFORE starting the upgrade process.
  4. If you are installing SP3 remotely (using RWA), be aware that you will lose your remote connection during this process. DO NOT PANIC. The SP3 upgrade will stop the RDP/Gateway service. Just be patient. Give the upgrade about 30-40 minutes to complete. Eventually you will be able to connect back in via RWA, and when you do, you should find that the upgrade has completed.
  5. If SP3 has been installed successfully, I would suggest rebooting the server again. It doesn’t hurt, and in some cases, it may help!
  6. Finally, Carl says to check that the version of Exchange is correct. Here is how I perform that step:
    1. Open up Exchange Management Shell
    2. Type the following: get-exchangeserver | fl name,edition,admindisplayversion
      image
    3. The build number for Exchange 2010 SP3 is: 14.3.123.4

Memorial Holiday 2013

I sent the following email to all my business clients and friends today:image

I hope each of you may be able to enjoy time with your family and friends this Memorial weekend. It’s also a time to pause and give thanks to all the men and women who have given their lives to protect us. I feel blessed and honored to know so many who have served in the military. My own father was a WWII veteran, and was there on the initial landing at Iwo Jima. I still cannot fathom their sacrifice.

Please enjoy the weekend and drive safe if you are traveling.

SBS and Essentials Build Docs

For several years the SBS MVP’s have been maintaining several Wiki-type “build” documents for the SBS and Essential server platforms, including SBS 2008, SBS 2011 Standard/Essentials, Windows 2012 Essentials and Storage Server 2008 R2 Essentials!

image

These documents contain a wealth of real-world and time-tested hints and recommendations, collected from MVPs around the world. They contain information you need to know before, during, and after installing SBS or Essentials.

This link below will take you to the main page with links to each individual build document.

http://social.technet.microsoft.com/wiki/contents/articles/1710.small-business-server-documentation.aspx

Enjoy!

Extend Keyboard and Mouse with Synergy

Last August I wrote about a utility called Mouse Without Borders, developed in Microsoft’s “The Garage”, that allows you to use one keyboard and mouse to control multiple computers. And the utility works very great.

That is, unless you also have Linux or Mac OS X computers which you also want to control with a single keyboard and mouse.

So, here comes Synergy which offers to extend your mouse and keyboard to all three environments. And did I say that it is FREE??

image

I decided to take it for a spin today, and I was quite surprised at how easy it was to install and run it. For this first effort, I only installed it on two Windows computers. At a later date I will post my efforts to include a Linux or Mac workstation.

My scenario: I have a Windows 7 x86 workstation with three monitors, and a Windows 2008R2 x64 server, running Hyper-V.

INSTALL/SETUP FIRST WORKSTATION

My mouse and keyboard that I wish to use is on my Win7 workstation. So I first downloaded the Windows 32-bit version of Synergy and installed it. I designate this as my Synergy “server”.

image

It then asks what type on encryption I wish to use. That’s a really nice feature as it does provide some protection from anyone trying to intercept your keystrokes. You have a choice of four (4) different encryption modes, or you can disable encryption. For purposes of testing, I chose to not enable encryption.

image   image

The only other step to do is to click on the Configure Server… button. You will have a screen where you can describe your setup, indicating in which direction the monitor for each of the other workstation(s) is located.

image   image   image

 

INSTALL/SETUP ON NEXT WORKSTATION

In this case, my second workstation (which Synergy refers to as a client) is running Windows Server 2008 R2 x64. I am also running Hyper-V manager on this server, so I decided to install the Synergy client to the Hyper-V parent, so I can control all of my Hyper-V guests.

So I download and install the 64 bit version of Synergy, and install it. This time, when it asks Server or Client, I’ll select “Client”. Then you need to tell the Synergy client the name of the computer that is the “Synergy “server”.

image   image

I thought I was all done, but my mouse would not move over to the monitor attached to my server. At first I thought it was a firewall issue, but turning off the firewall on the W2K8R2 server did not fix it. In fact, if you check the firewall settings, you will find that Synergy had automatically added the proper Inbound TCP and UDP rules.

image

I then checked Services, and discovered that the Synergy service had not yet been started.

image

After doing so, I immediately saw that Synergy was communicating between the two computers, and my single mouse and keyboard was now controlling both computers!

image

Space Monger is still alive!

A good (I.T.) friend of mine reminded me of a utility from the past called SpaceMonger.

What is Space Monger? It’s a free tool that gives you a graphical picture of your entire disk, with larger files and folders easily identified. The nice thing is that Space Monger does not need to be installed. The executable can be run from a thumb drive!

Here are two screen snapshots from my drive:

image     image

You can download Space Monger from my web site. The zip file includes the free version 1.4 executable and the ReadMe file.

The trick to using it, I was told is:

  • Run it with elevated permission (Run as administrator)
  • Always open the folders, and not any applications from within it.

If you’re looking for something a bit fancier, but still free, check out WinDirStat!

View Hidden Devices in Device Manager

By default, Device Manager (devmgmt.msc) does not provide the option to “Show Hidden Devices”. You’ve probably know the steps to enable this option:

  1. Open a command prompt in (Run as) administrator mode
  2. Type the following two commands:
    set devmgr_show_nonpresent_devices=1
    start devmgmt.msc
  3. Once Device Manager starts up, you can click View –> Show Hidden Devices
    image

But if your working on a server and need to review the full list of devices, doing the above steps is not very productive. THere’s a way to set this option permanently, entering it as a system variable. Here are the steps for Windows 2008 R2, but the same variable can be created in other versions of Windows.

  1. Click Start
  2. Right click on Computer, then click Properties
  3. Click on the Advanced System Settings in the left frame
  4. Under the Advanced tab, click on Environment Variables…
  5. Click New
    For the Variable name, type:  devmgr_show_nonpresent_devices
    For the Variable value, type: 1
  6. Click OK

That’s it! Here’s a screen shot of the above process:

image

Now, any time you access Device Manager on this server, the Show Hidden Options will be available from the View options

Possible Gmail Interruption?

This morning I my Outlook 2010 program had a pop-up windows asking my to enter my Gmail credentials:

image

I did, but I still was not receiving my Gmail messages. I was, however, sending and receiving email properly through Outlook 2010 for all my other email accounts. I also checked and verified that I log into Gmail’s web site properly and access my email that way.

I’ve contacted some of my peers, and they say they have received calls from some of their customers with the same issue.

So I suspect there is either a temporary outage or issue or possibly an upgrade with Gmail’s service. Not sure how widespread it is, but one person in London told me that his smartphone popped up requesting his login credentials.

Ongoing WordPress Security Attacks

This is for anyone who creates or maintain WordPress sites. It comes from one of the WordPress 3rd party theme developers (iThemes) that I regularly use, and I thought I would share it. Original post dated April 15, 2013:

“Ongoing WordPress Security Attacks, The Details and Solutions:
There is a very real, very large ongoing attack against WordPress sites. It has been going on for a while now, but it severely escalated last week…”

http://ithemes.com/2013/04/15/ongoing-wordpress-attacks-details-and-solutions/

image

DISM for Windows Server 2008 R2 (64 Bit)

DISM is a command-line Microsoft tool for Windows 7/8/2008/2012. DISM stands for ‘Deployment Image Servicing and Management’. If you do a search for dism.exe you will find many posts of people using it to reduce the size of their WinSxS folder, especially after installing SP1. There is a 32-bit and a 64-bit version of this tool.

The actual command to do this cleanup is: dism.exe /online /cleanup-image /spsuperseded

So, you are sitting at the console of a Windows 2008 R2 x64 server, and you want to run this utility. Chances are, you will try to use the dism.exe that is listed inside the c:\Windows\SysWow64 folder.

However, if you do so, you may encounter the following error message: Error: 11 You cannot service a running 64-bit operating system with a 32-bit version of DISM. Please use the version of DISM that corresponds to your computer’s architecture.

image

In order to run this properly, you need to go directly to the native system folder to run this tool on a 64 bit system. Here are the steps:

  • Open command prompt window as administrator (‘Run as’).
  • Change directory by typing: cd \windows\system32
  • Run the command: dism.exe /online /cleanup-image /spsuperseded

This will take about ten minutes to run. Please note that even after the progress bar reaches 100.0%, the tool has not finished running. Do NOT close the command prompt window until you get the message “The operation completed successfully”.

image

What is the result of running this tool? I ran this on a Windows 2008 R2/SBS 2011 server, and it reduced the size of the WinSxS folder from 10.8GB to 7.37GB.

image   image

Not very drastic if you ask me. Not with today’s disk sizes. However, if you are running out of disk space on your server system drive, this might buy you some needed room!