Tag Archive: 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.

Oct 26 2012

Remove Companyweb as default Internet Explorer Home Page

When installing Windows Small Business Server 2008/2011 you will notice that part of the SharePoint Foundation is a CompanyWeb webpage that can be used as your intranet, folder sharing and other internal company functions.

The CompanyWeb is forced by Group Policies by default onto the client PC’s, so as soon as you join a PC to the domain it will set the CompanyWeb (http://companyweb) as your default home page in Internet Explorer. You can then change the default home page in IE and as soon as you log off and log back on, the CompanyWeb page is back as your home page.

So what do you do if you don’t want it as your default home page?

–   Go to START -> ADMINISTRATIVE TOOLS -> GROUP POLICY MANAGEMENT

–   In Group Policy Management, browse down to WINDOWS SBS USER POLICY

–   On the right of the window click on SETTINGS on top and click on URL’s / IMPORTANT URL’s

Remove Companyweb as default Internet Explorer Home Page

 

 

 

 

 

 

 

 

 

–   Right click on URL’s / IMPORTANT URL’s and click EDIT

Remove Companyweb as default Internet Explorer Home Page

 

 

 

 

 

 

 

 

 

–   The GROUP POLICY MANAGEMENT EDITOR will open

–   Under USER CONFIGURATION, browse to URL’s and double click on IMPORTANT URL’s on the right.

Remove Companyweb as default Internet Explorer Home Page

 

 

 

 

 

 

 

 

Change the HOME PAGE URL to the website that you want to enforce to every user. If you want every user to be able to set his own Home Page, leave the HOME PAGE URL blank and un-tick the CUSTOM HOME PAGE URL and save your setting.

Hope this helps to remove Companyweb as default Internet Explorer Home Page.