Category Archive: Microsoft Server

Nov 16 2013

How to move Exchange 2010 Mailbox Database

Emails has become one of the main business communication tools these days. Because of the amount of the emails that we send and receive, our email database size keeps increasing. This means that your Exchange Server might run out of storage space sooner than later. In this article I will explain the two methods how to move Exchange 2010 Mailbox Database to another drive or partition.

Always try to move Exchange Database using Exchange Management Console first before you try moving the database manually. This is the safest and easiest.

Move Exchange Mailbox Database using Exchange Management Console:

Open Exchange Management Console and navigate to ORGANIZATION CONFIGURATION and MAILBOX in the console tree on the left.

Then in the DATABASE MANAGEMENT tab, select the database you would like to move.

In the Actions pane, click on MOVE DATABASE PATH

How to move Exchange 2010 Mailbox Database

 

 

 

 

 

 

 

 

 

 

When the wizard opens make sure that the DATABASE NAME is the correct database that you want to move.
Under DATABASE PATHS, enter the new path where you want to move Exchange 2010 Mailbox Database to. Usually the Log Folder Path is the same as the Database File Path.

How to move Exchange 2010 Mailbox Database

 

 

 

 

 

 

 

 

 

 

 

 

 

Click on MOVE and Exchange will start to move the Mailbox Database for you. Moving the database might take a long time depending on the size of your Mailbox Database, so be patient.
On the COMPLETION PAGE the status should show as COMPLETED. This means that the wizard has completed the task successfully. Then click on FINISH.

In the case where the status on the COMPLETION PAGE shows FAILED, you can go ahead and try to move Exchange 2010 Mailbox Database manually by following the steps below.

Move Exchange 2010 Mailbox Database manually:

Open Exchange Management Console and navigate to ORGANIZATION CONFIGURATION and MAILBOX in the console tree on the left. Then in the Actions pane click on DISMOUND DATABASE.

Then manually copy all the file in the Mailbox Database folder to the new location. You can create any folder in the new location e.g. D:\Exchange Database. The default location of the Exchange 2010 Mailbox Database is C:\Program Files\Microsoft\Exchange Server\V14\Mailbox\Mailbox Database 1234567890. You need to copy the whole “Mailbox Database 1234567890” folder.

Then change the Path location for .edb, Logs and .chk file path by using ADSIEdit.

msExchEDBFile = D:\Exchange Database\Mailbox Database 1234567890.edb
msExchESEParamLogFilePath = D:\Exchange Database\Logs
msExchESEParamSystemPath = D:\Exchange Database\Logs

Open Exchange Management Console and MOUNT the Mailbox Database.

Ensure that your Exchange Server is working correctly before deleting the folders in the old database location.

Aug 12 2013

Increase Rules Quota Limit in Exchange 2010

Lots of users use Rules in Outlook to organize their emails or move it to specific folder. They will then setup a list of Rules and then either set it to run when the email arrives in the Inbox, or the user run it manually say once a month to move the emails to its specific folder. When you create too many Rules, Outlook will give you an error that you can’t create anymore rules. In this article I will show you how to Increase Rules Quota Limit in Exchange 2010.

Exchange 2010 and all previous versions had a default Rules Limit of 32kb so when you create a new mailbox the user will be allocated 32kb of space to create Rules. In previous versions of Exchange Server you are not allowed to change the mailbox rules limit, but Microsoft change this in Exchange 2010.

 

Increase Rules Limit in Exchange 2010

How to Increase Rules Quota Limit:

Open Exchange Management Shell and use the following command.
The Set-Mailbox cmdlet is used to change the Rules Limit on a specific mailbox.

Set-Mailbox –RulesQuota

Now here is an example where we want to change the user “Dave” to 256kb Rules Limit using Set-Mailbox cmdlet.

Set-Mailbox dave –RulesQuota:256KB

Press enter and you had successfully Increase Rules Quote Limit in Exchange 2010 from 32kb to 256kb.

Mar 25 2013

Renew Exchange 2010 Self Signed Certificate with GoDaddy Standard UCC SSL Certificate

In this article I will show you how to renew Exchange 2010 Self Signed Certificate.  I normally use GoDaddy’s Standard UCC SSL Certificates as they are very cost affective. This process can sometimes be a very time consuming job as you will typically do this once a year or even more, then each time you have to figure it out from scratch again.

There are 4 parts that you need to do:

 

  1. Create a New Exchange 2010 Certificate request
  2. Renew/buy and setup your GoDaddy UCC SLL Certificate
  3. Complete the Exchange 2010 Pending Certificate request
  4. Assign the Exchange 2010 Services to the Certificate

Create a New Exchange 2010 Certificate request

Open EXCHANGE MANAGEMENT CONSOLE.

Expand MICROSOFT EXCHANGE On-Premises and click on SERVER CONFIGURATION.

Click on NEW EXCHANGE CERTIFICATE in the action bar on the right-hand side.

When the NEW EXCHANGE CERTIFICATE windows opens, type in a description of your certificate. (This can be anything, as this is only to identify the certificate if you have more than one)

Exchange 2010 New Exchange Certificate

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Then click NEXT

On the next windows, if you use a wildcard certificate, tick the ENABLE WILDCARD CERTIFICATE and type in your wildcard domain name (e.g. *.yourdomian). Mostly you will leave this blank for a single site and domain.

Exchange 2010 Domain Scope

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click NEXT

Now you need to configure the services that this certificate will be used for. Use the drop down arrows to select the services that will be used, e.g. Outlook Web App, Exchange ActiveSync and POP/SMTP). Also make sure that domain names are the primary one you used/will be using in your certificate for example remote.yourdomian.com.

Exchange 2010 Exchange Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click NEXT

The next window will ask to review your certificate domains. Make sure you have your primary domain name for the certificate and the domain name added to the list. Make sure your primary domain name is SET AS COMMON NAME.

Example:

remote.yourdomain.com (Common Name)

yourdomain.com

Exchange 2010 Certificate Domains

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click NEXT

The next window asks for the Organization details and Location details. Complete all the details as requested.

Right at the bottom, click on BROWSE and select a folder and file name for your Exchange Certificate Request. (The file name can be anything as long as you know what it is.)

Exchange 2010 Organization Location

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click NEXT

A configuration summary will be shown. Check that everything is correct.

Exchange 2010 Certificate Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click NEXT

Exchange 2010 will then create the Certificate Request and also the Certificate Request File.

Exchange 2010 Completion Summary

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click FINISH

Under EXCHANGE CERTIFICATES you will you will see a new Certificate Name added to the list and the SELF SIGNED column will show as TRUE.

Exchange Management Console Exchange Certificates

 

 

 

 

Now we need to go do GoDaddy, which is your certificate authority to create the certificate.

 

Renew/buy and setup your GoDaddy UCC SLL Certificate

These images are taken from the renewal process in Godaddy, but if you buy a new certificate, the process will be very similar.

First you will pay for the next period your certificate will be active, e.g. 1 year or 3 year or whatever you can afford at the moment. (I normally do this on a yearly basis)

During the payment process you will be asked to configure your certificate.

On the first screen (HOSTING), select THIRD PARTY, OR DEDICATED SERVER.

Then tick the box next to USE PREVIOUS CSR.

GoDaddy SSL certificate renewal

 

 

 

 

 

 

 

 

 

 

 

 

Go to your Certificate Request File that you just saved from the Exchange 2010 Server and open it with NOTEPAD. Copy and Paste everything in the file to the box where it states that you need to ENTER YOUR CERTIFICATE SIGNING REQUEST (CSR)

It should look something similar to this:

—–BEGIN NEW CERTIFICATE REQUEST—–
MIIEjDCCA3QCAQAwgacxIjAgBgNVBAMMGXJlbW90ZS5waHN0ZWxsZW5ib3NjaC5j
b20xIjAgBgNVBAsMGVByb3RlYSBIb3RlbCBTdGVsbGVuYm9zY2gxIjAgBgNVBAoM
GVByb3RlYSBIb3RlbCBTdGVsbGVuYm9zY2gxFTATBgNVBAcMDFN0ZWxsZW5ib3Nj
aDEVMBMGA1UECAwMV2VzdGVybiBDYXBlMQswCQYDVQQGEwJaQTCCASIwDQYJKoZI
hvcNAQEBBQADggEPADCCAQoCggEBANowibjpqAvtlPIgqhw/Sm65m92x5jQL/Cl/
YRbS+EmCpReMUNKbcQwPZ9EE1M50mFRLwf+XKEGIhx8sMsJkmMv0DWGbNJWb0eGa
BzaTmRoK//3Zri6dUlLq2foMJBuEvHBlYF2PMiZN1i3ESh/vczjDRccG+BIqHK15
wCdKfU7x0OeTaDb6g2zIwZeqPoWP8HQhSSQbUcSW8JqATnHUlXLg0Vjzkd/8PBO8
rkL/kM8ccZHiWZxCjHVrUyJgDt3E21vUMwk1flO+2EYm3TBjPcUIprZdS7yqI9OO
S1iLhJvlkVdDYG7ERa31YbYHGqklUgMEI4DJvQVTilN0b+2a0IkCAwEAAaCCAZ0w
GgYKKwYBBAGCNw0CAzEMFgo2LjAuNjAwMi4yMF8GCSsGAQQBgjcVFDFSMFACAQUM
FVBIU1RFTDAzLnBoc3RlbC5sb2NhbAwQUEhTVEVMXFBIU1RFTDAzJAwiTWljcm9z
b2Z0LkV4Y2hhbmdlLlNlcnZpY2VIb3N0LmV4ZTByBgorBgEEAYI3DQICMWQwYgIB
AR5aAE0AaQBjAHIAbwBzAG8AZgB0ACAAUgBTAEEAIABTAEMAaABhAG4AbgBlAGwA
IABDAHIAeQBwAHQAbwBnAHIAYQBwAGgAaQBjACAAUAByAG8AdgBpAGQAZQByAwEA
MIGpBgkqhkiG9w0BCQ4xgZswgZgwDgYDVR0PAQH/BAQDAgWgMFkGA1UdEQRSMFCC
GXJlbW90ZS5waHN0ZWxsZW5ib3NjaC5jb22CEnBoc3RlbGxlbmJvc2NoLmNvbYIf
2hCNN3B9JDOrDudbt4pBpCYYGBpOvb4CUKlHrRS2Yi5dXVqsaXUr37/OgS2yyQTI
zazdE1tX9S//FG3rRQZioAqtTxH50Tlsx/soeq/LCbMFxjYy8wwvVUEyx1V4rpBn
wB37FhmMCCEUWr31hlKC/T9CPU0JNNuYD7Gv0xiLwyAzwfLYqwELGftA3+XL9wvu
6+8X0yjUA5NR+V4Pt0p2RLKSgq/v2Dpadne/z0chEkpLpHMDYTMWGzwmFc+rQF9m
oK1GyLdxBBdpjfzkaSAD+2oFL1PWnq5EpuRRrjt5P5vGnH6RrsUsgwS2xGx3iwXd
YHyiM7dS1XNfxdkjj7Hx9A==

—–END NEW CERTIFICATE REQUEST—–

When that is done, make sure your SUBJECT ALT NAMES is correct.

I normally use the following:

remote.yourdomain.com (Primary domain name)

autodiscover.yourdomain.com (Sub alt name)

mail.yourdomain.com (Sub alt name)

servername (Sub alt name)

servername.yourlocaldomain.local (sub alt name)

Then select GoDaddy as your CERTIFICATE ISSUING ORGANIZATION.

Click NEXT

On the next window, confirm all your settings and click NEXT.

GoDaddy SSL certificate renewal

 

 

 

 

 

 

 

 

 

The next window will show that your certificate will be issued shortly. Click FINISHED.

GoDaddy SSL certificate renewal

 

 

 

 

 

 

 

 

 

Launch the SECURE CERTIFICATE SERVICE from your control panel in GoDaddy.

You will see that there is a PENDING REQUEST. GoDaddy will send an email to the domain administrator and account holder of the GoDaddy Account to verify that the Certificate is correctly acquired by you, the domain owner/administrator. Click on the link in the email to verify. Shortly after that the new certificate will appear under the CERTIFICATES folder in the SECURE CERTIFICATE SERVICE.

GoDaddy SSL certificate renewal

 

 

 

 

GoDaddy SSL certificate renewal

 

 

 

 

 

 

 

 

 

 

 

Select the certificate and click on the DOWNLOAD option above it. In the Download Certificate windows, select EXCHANGE 2010 from the drop down and click DOWNLOAD. A ZIP file will be downloaded to your server. Extract the ZIP file and save the certificates on your server.

Renew Exchange 2010 Self Signed Certificate pending request

Now go back to your EXCHANGE MANAGEMENT CONSOLE. Go to SERVER CONFIGURATION.

Right-click on the new certificate request you created and select COMPLETE PENDING REQUEST.

Click BROWSE and browse to the folder where you saved the content of the ZIP file.

Change the file type to *.*

From the two files that was in the ZIP file, select the .cer file and click COMPLETE

When the process is done, you will notice that your new certificate will show as SELF SIGNED = FALSE.

Assign the Exchange 2010 Services to the Certificate

Right-click on your new certificate again and select ASSIGN SERVICES TO CERTIFICATE.

On the window that opens, you need to add your EXCHANGE 2010 servers. (In my case there were only one server)

Exchange 2010 Assign Services to Certificate

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click NEXT

Then select all the services that your certificate will be used for.

Exchange 2010 Assign Services to Certificate Select Services

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click NEXT

Make sure your configuration summary is correct and click ASSIGN.

Exchange 2010 Assign Services to Certificate Summary

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You have just completed the process of renewing your GoDaddy UCC SSL Certificate on an EXCHANGE 2010 SERVER.

Make sure that the expiry date is correct and that it shows a blue correction mark next to your certificate. Everything should be good to go!

Mar 16 2013

Sqlservr.exe high memory usage on SBS2008

You will sometimes find that your Windows Small Business Server 2008 will become slow and even sometimes reboot or hang. This can be caused by SQL Server that plays an important part in reporting and other functions on the SBS2008 server and that the Sqlservr.exe high memory usage will cause slow and unresponsive functions.

If you look in the Task Manager you will see that the Sqlservr.exe process will accumulate memory as long as there are still memory available. This is because by default there is no limit on the amount of memory that SQL Server is allowed to use.

I will show you how to change this. These settings will not have any effect on the reporting services and other software that is using SQL Server. It might speed up your SBS2008 and also might resolve your server rebooting or hanging from time to time.

Here is how to change your SQL Server memory usage limit to 512kb. I normally change this to either 512kb or 1024mb depending on the amount of memory your server has installed.

–          Open an COMMAND PROMPT (Make sure you have full Administrator rights)

–          Type: osql -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

–          At the SQL Prompt type the following:

1> sp_configure ‘show advanced options’,1
2> reconfigure with override
3> go

–          The following message will be displayed:

Configuration option ‘show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.

–          Then type the following:

1> sp_configure ‘max server memory’, 512
2> go

–          The following message will be displayed:

Configuration option ‘max server memory (MB)’ changed from 2147483647 to 512. Run the RECONFIGURE statement to install.

–          Then type:

1>  exit

Reboot the SBS2008 server and your Sqlservr.exe will be more stable and the high memory usage problem will be resolved.

Mar 15 2013

How to fix 80072EFD Error on Windows Small Business Server 2008

I recently had a Windows Small Business Server 2008 (SBS2008) that for some reason just don’t want to install any updates. When you run Windows Updates it will show “Windows can’t connect to update…” error 80072efd. I will show you how to fix 80072EFD error on Windows Small Business Server 2008

After further investigation I found that the Windows Server Update Services or WSUS was disabled and not working. This was done probably to save disk space as Windows Server Update Services store all the Windows Updates locally on the server. This caused the AUTHORITY\NETWORK SEVICE entry in the registry to be 0 instead of 1.

Because of this meltdown of WSUS that uses http://servername:8530 to communicate with Windows Update Server locally. If the server can’t find that address or any updates it will respond with the 80072efd error.

After doing some research I found a workaround for this. I uninstalled WSUS and edited the Windows Update entry in the registry.

How to fix 80072EFD error on Windows Small Business Server:

–          Click START -> RUN and type REGEDIT and press ENTER

–          Navigate to HKLM\Software\Policies\Microsoft\Windows\WindowsUpdate

–          In the folder, look for the following keys:

           “WUServer”=”http://SERVERNAME:8530”

           “WUStatusServer”=”http://SERVERNAME:8530″

(if these keys are in your WindowsUpdate folder, SBS2008 is trying to updates locally on the server.)

–          Delete the “WindowsUpdate” key from the registry.

(Always remember to export the folder first before you delete it, just for safety)

–          Restart the Windows Update Service

(Go to START -> RUN -> type “service.msc” and stop and start the service.)

This instantly solved my problem and I was able to install all Windows Updates via Automatic Updates.

Hope this will work for you too.

Page 1 of 212