Category Archive: Small Business Server 2008 (SBS2008)

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.

Sep 20 2012

Disable password complexity on Server 2008 and Server 2011

Every single time I install a new server for a client I have to go through these steps to change or disable password complexity on server 2008 and server 2011. When you install the new server software, the default Password Policy is set to the following:

–          Enforce password history                                             24 passwords remembered

–          Maximum password age                                              42 days

–          Minimum password age                                               1 days

–          Password must meet complexity requirements       Enabled

–          Store passwords using reversible encryption           Disabled

Now don’t get me wrong, these settings as set by default by Microsoft is not a bad thing. These days you can’t have secure enough passwords anymore. I on the other hand like to set a password according to a password standard that we have in my company. The password is then set according to the client’s need together with my company password policy which include special characters and so on e.g. @@companyname@@001! (This is only an example and not the actual company password policy we use)

So when we then install the new server software, we change the Administrator password immediately according to what we want it.

Here is how to disable the password complexity on Server 2008 and Server 2011 so that you can put in the password that you want:

Go to START -> ADMINISTRATIVE TOOLS and open GROUP POLICY MANAGEMENT.

Disable password complexity on Server 2008 and Server 2011

Browse down in the FOREST until you get to DEFAULT DOMAIN POLICY under your network domain name.

Disable password complexity on Server 2008 and Server 2011

Right-click on DEFAUL DOMAIN POLICY and click EDIT.

Disable password complexity on Server 2008 and Server 2011

On the right hand side double-click on PASSWORD MUST MEET COMPLEXITY REQUIREMENTS.

Disable password complexity on Server 2008 and Server 2011

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In the next window, select DISABLE and click OK

Now you can go to Active Directory Users and Computers and change your Administrator Password to whatever you want to without any password restrictions.