SSL Certificates on MS Exchange 2007

I had to update the SSL Certificate on our Exchange 2007 server so Webaccess email would work properly. I have always struggled with SSL Certificates. We ended up getting our SSL Certificate through GlobalSign. They have 2 pages on their support section that did a good job of detailing the steps for installing SSL certificates on Exchange 2007.

Here are the links to the pages:
Generate a Certificate Signing Request (CSR) with MS Exchange 2007 - http://www.globalsign.com/support/csr/ex_2007.php

Install your Certificates in Microsoft Exchange 2007 - http://www.globalsign.com/support/install/ex_2007.php


One important thing to do, when you are purchasing the SSL certificate, DO NOT forget to register the name, autodiscover."YOUR SERVER". You will get a security pop up message if you don't.

SharePoint WSS 3.0 Searching Error

We are running WSS 3.0 and were having issues with Searching on the Site. We would recieve the following error when a search was performed:

"Your search cannot be completed because this site is not assigned to an indexer"

After digging around on the Central Administration site I was able to find a section that was not completely filled out:

• Goto Central Management
• Application Management
• Content Databases
• Click onto your main Database in the Database Name Column
• Towards the bottom of the screen you will see a section titled Seach Server. Use the dropdown and select you Sharepoint search server.
• Click OK

Depending how you have your search frequency setup, Search on your site should now be operational, or at the very least, you should no longer see the error message.

'Error Evaluating Check Constraint'

We had the need to change a column in an Access 2007 database from a number format to a text format. Once the change was made and somebody attempted to enter text into this field we would recieve the error 'Error Evaluating Check Constraint' After doing some digging around in the Field Properties I was able to find what was causing the problem.

In Field Properties verify the the Validation Rule is blank. Ours had a setting of >0. This was because the field was intially set as a number column that could not be 0.

Installing Windows 64bit on VMware ESX 3.5

I ran into a issue a while back when atttempting to install Windows 2003 x64 on VMware EXS 3.5. I ran into the following error:

"Windows failed to start. A recent hardware or software change might be the cause... File: \windows\system32\boot\winload.exe Status: 0xc000035a Info: Attempting to load a 64-bit application, however this CPU is not compatible with 64-bit mode."

The server was a Dell 2950 and I had Windows 2003 64x installed on it before I decided to to make is a VM Ware server. After digging a little bit I was able to find the issue.

In order to run a 64bit application on ESX 3.5 you must first enable VT extensions in the systems BIOS first.

• Power down the server and boot into BIOS mode.
• In BIOS go into Advanced Properties.
• Enable VT Extensions.
• Save your settings.
• Cold boot your system. (This is important. A warm boot does not put VT Extensions into effect).
• Go into VMware as usual and install your 64 bit OS.

Exchange 2007 Individual Mailbox Size Report

Here is an easy way of listing the mailbox sizes for everyone on your Exchange 2007 mail server. I have not run this on Exchange 2003 so I don't know if it works.

From the Exchange Management Shell run:

Get-Mailbox -server "Exchange Servername" get-mailboxstatistics select-object DisplayName,@{expression={$_.TotalItemSize.value.ToKB()}},Itemcount,ServerName

Be sure not to forget to change "Exchange Severname" the to your server name.

After running the command, I copied it to Excel to create a more user friendly report for distribution.