Bart's Weblog

Just a blog…

Archive for the ‘SBS’ Category

Configure DNSCredentials

Posted by bartvdw on 0606/1010/2008

If you run DHCP & DNS on 1 and same server, Microsoft recommends to use DNSCredentials for secure updates. For this, create a dedicated user account with a very difficult password set, but make sure the password is set to ‘Never expires’! No special group membership is needed for this user.

The run following command (command-line): netsh dhcp server set dnscredentials %USER% %DOMAIN% *

Note: the * sign at the end of the command enables prompt for password. When prompted, enter the password of the user.

Read the article below for more information.

Event ID 1056 Is Logged After Installing DHCP
http://support.microsoft.com/kb/282001

Advertisements

Posted in SBS, Windows | Leave a Comment »

Antivirus software exclusions

Posted by bartvdw on 1313/0808/2008

When you configure antivirus software for servers, you need to take exclusions into account. And for MS products, they are fairly good documented. If you don’t add these exclusions, you could get trouble/errors. For applications not listed here (MS or third party), always verify if you need to exclude something to make sure your antivirus software does not affect your application!

Below a summary of such exclusions and references to MS articles describing these exclusions. I will update this post in case I have additional information.

Note: In the list below, default file locations are used. If you have change the location of the files (ex. Ntds.dit), you need to use the altered path obviously!!

General exclusions Windows Server 2003, Windows 2000, Windows XP, or Windows Vista:

  • %windir%\ntfrs
  • %windir%\SoftwareDistribution\Datastore\Datastore.edb
  • %windir%\SoftwareDistribution\Datastore\Logs\Edb*.log
  • %windir%\SoftwareDistribution\Datastore\Logs\Res1.log
  • %windir%\SoftwareDistribution\Datastore\Logs\Res2.log
  • %windir%\SoftwareDistribution\Datastore\Logs\Edb.chk
  • %windir%\SoftwareDistribution\Datastore\Logs\Tmp.edb
  • For Windows 2000 & 2003 DC’s
    • %windir%\ntds\Ntds.dit
    • %windir%\ntds\Ntds.pat
    • %windir%\ntds\EDB*.log
    • %windir%\ntds\Res1.log
    • %windir%\ntds\Res2.log
    • %windir%\ntds\Temp.edb
    • %windir%\ntds\Edb.chk
    • %systemroot%\sysvol (only this folder, not all subfolders!!!)
    • %systemroot%\sysvol\domain\DO_NOT_REMOVE_NtFrs_PreInstall_Directory
    • %systemroot%\sysvol\staging
    • %systemroot%\sysvol\staging areas
    • %systemroot%\sysvol\sysvol
  • Clusters:
    • %windir%\Cluster
    • Q:\ (quorum)
  • DHCP: %windir%\system32\dhcp
  • DNS: %windir%\system32\dns
  • WINS: %windir%\system32\wins

Exchange Server:

  • Cdb.exe
  • Cidaemon.exe
  • Store.exe
  • Emsmta.exe
  • Mad.exe
  • Mssearch.exe
  • Inetinfo.exe
  • W3wp.exe
  • Exchsrvr\Conndata
  • Exchsrvr\Mailroot
  • Exchsrvr\Mdbdata
  • Exchsrvr\Mtadata
  • Exchsrvr\server_name.log
  • Exchsrvr\Srsdata
  • %systemroot%\IIS Temporary Compressed Files
  • %SystemRoot%\System32\Inetsrv
  • All .edb; .stm (on Exchange 2000 Server); .log Exchange files
  • M: drive (on Exchange 2000 Server)
  • SBS:
    • C:\Program Files\Microsoft Windows Small Business Server\Networking\POP3\Failed Mail
    • C:\Program Files\Microsoft Windows Small Business Server\Networking\POP3\Incoming Mail

SQL Server: SQL Server data files that have the .mdf extension, the .ldf extension, and the .ndf extension

WSUS: MSSQL$WSUS and WSUS content directory

References:

Virus scanning recommendations for computers that are running Windows Server 2003, Windows 2000, Windows XP, or Windows Vista
http://support.microsoft.com/kb/822158

Overview of Exchange Server 2003 and antivirus software
http://support.microsoft.com/kb/823166

Guidelines for choosing antivirus software to run on the computers that are running SQL Server
http://support.microsoft.com/kb/309422

Recommended Forefront Client Security file and folder exclusions for Microsoft products
http://support.microsoft.com/kb/943556

Multiple symptoms occur if an antivirus scan occurs while the Wsusscan.cab file or the Wsusscn2.cab file is copied
http://support.microsoft.com/kb/900638

Posted in Exchange, McAfee, SBS, Security, SQL, Windows | 3 Comments »

POP3 Connector: How to troubleshoot

Posted by bartvdw on 2727/0101/2008

How to troubleshoot the POP3 Connector in Windows Small Business Server 2003
http://support.microsoft.com/kb/885685

Posted in Exchange, SBS | Leave a Comment »

POP3 Connector: Important fixes

Posted by bartvdw on 2727/0101/2008

Here are some very important hotfixes for POP3 Connector in SBS. I have seen the issues several times.

Many unexpected outbound e-mail messages appear in the SMTP queue in Small Business Server 2003
http://support.microsoft.com/kb/835734

Download link: http://www.microsoft.com/downloads/details.aspx?familyid=7B1FF109-092E-4418-AA37-A53AF7B8F6FC&displaylang=en

Scheduled POP3 connector e-mail message downloads may not occur on your Windows Small Business Server 2003-based computer
http://support.microsoft.com/kb/833992

Download link: http://www.microsoft.com/downloads/details.aspx?familyid=206e4e32-1e37-4836-b4f7-8d6a543a7c7f&displaylang=en

Posted in Exchange, SBS | Leave a Comment »

Allocated memory issue: sqlservr.exe

Posted by bartvdw on 2626/0101/2008

Recently I found on a SBS 2003 box a memory issue. After a quick look in my Task Manager I found that the process was called sqlservr.exe

Next step was finding the service linked to the process. “tlist.exe -s” (included in Debugging Tools for Windows) gave me the information needed: MSSQL$SBSMONITORING

What to do about that? Well after searching a little bit, I found this solution:

  • Open cmd
  • osql -E -S YOURSERVERNAME\sbsmonitoring [hit enter]
  • sp_configure ‘show advanced options’,1 [hit enter]
  • reconfigure with override [hit enter]
  • go [hit enter]
  • sp_configure ‘max server memory’, 70 [hit enter] (based on the information I found, this is OK)
  • reconfigure with override [hit enter]
  • go [hit enter]

Note: mind the quotes used! I have problems with publishing them correctly, so if you receive an error pointing into that direction, correct them manually in your syntax.

Cool link that helped me a lot:
http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx

 

Update

Troubleshooting High Memory Usage by a MSDE Instance.
http://blogs.technet.com/asksbs/archive/2008/07/05/troubleshooting-high-memory-usage-by-a-msde-instance.aspx

Adjusting SQL embedded instances
http://msmvps.com/blogs/bradley/archive/2007/12/25/adjusting-sql-embedded-instances.aspx

Thanks again Susan for the great post on this subject !!!

Posted in SBS, SQL | 1 Comment »