DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

Blogs

  • SBS 2008 Forefront Virus protection for e-mail Errors or Warnings - “At least one of the engines enabled for update has not been updated in the last week” – how to solve

    My SBS 2008 installation is pretty good, but one area I’ve noticed some problems was with ForeFront. I either had errors or at best warnings all the time about the scan engines. I would go and hit a manual update, but the bar would be 30-90% across and suddenly stop. When I looked in the event log I could see errors like these below. Searching the internet delivered me the KB article http://support.microsoft.com/kb/939411/en-us which talks about timeout issues, however even with the recommended change things did not resolve themselves. Source: GetEngineFiles Event ID: 6014 Level: Error Description: Microsoft Forefront Server Security encountered an error while performing a scan engine update. Scan Engine: AhnLab Update Path: http://forefrontdl.microsoft.com/server/scanengineupdate/x86/AhnLab Proxy Settings: Disabled Error Code: 0xC0001F58 Description: The operation timed out. Source: Microsoft Forefront Security Event ID: 7003 Level: Warning Description: Not all of the selected engines enabled for updates...
  • Internet Explorer security vulnerability fix now available – think of it as an early Christmas present… now about Firefox’s 3 issues this week…

    I think everyone knows that an urgent security issue has arisen in IE this week and Microsoft has taken the (wise) decision to publish a fix outside the normal 2nd Tuesday release cycle. Some have said switch browser because of this issue, but not only can that be complex, but most browsers suffer security issues so once again the only real protection is to wrap in cotton wool and hide. Or, use the built in features of Vista and IE7/8 which means protected mode and NOT running as admin. You might ask why a Christmas present? Well, if this continued un-patched then your information is seriously at risk and that would make for a very bad Christmas if your credit card information was stolen!! Either way, if you have IE on your systems then you will need to update your systems urgently. Of course, my Hyper-V server (or Windows Core for that matter) don’t have IE, so no updates for them!!! Just for completeness, here is the information from the Technet newsletter Internet Explorer Security Update I wanted to...
  • How to size the hardware required for SBS 2008

    This question has been asked many times and was once again asked today on an internal forum.  It is hard to come up with an explicit answer, but I feel I can give you some (personal, non-binding, your mileage may vary, please take with a pinch of salt and don’t sue me) opinions.  For SBS 2003 the non-scientific sizing appeared to go like this: “between 2 & 4GB of RAM, depending on number of users”.  I often saw a machine for around 25 users with 4GB of RAM and there was headroom. Disk – don’t buy 1.5TB disks, but don’t by 30GB either.  Buy largish and try to size data before you make the decision 1 CPU or 2, or perhaps more importantly, a box that can take 1 CPU or 2? The the time SBS 2008 arrived the difference in cost of a 2GB or 4GB box was trivial.  Now SBS 2008, if you want to be scientific about it would look something like this: Minimum specs are found at http://www.microsoft.com/sbs/en/us/system-requirements.aspx Think Windows Server 2008 for x users, plus Exchange sizing for...
  • Two more SQL 2005 to SQL 2008 issues fixed - Provider=SQLNCLI – Provider cannot be found error and Property Owner is not available for database

    So these are really quick snippets.  I hit an error where my Gateway monitoring software could not connect to the database.  All the errors were along the lines of “Provider cannot be found” and when I looked in the Connection String it stated “Provider=SQLNCLI” which is the SQL Native Client connector software. The fix that worked for me was very simple, to change the “Provider=SQLNCLI …..” to “Provider=SQLNCLI10 …..”.   The second issue was nothing that came about from the SQL 2005 to SQL 2008 conversion, but became an issue when I could not see the properties for the database.  The error I would see was that “Property Owner is not available for database”.  The fix can be found here - http://blog.dampee.be/post/2008/06/22/MSSQL-2005-error-message-quot3bProperty-Owner-is-not-available-for-Database-databaseNamequot3b.aspx .   ttfn David Technorati Tags: Microsoft , SQL Server , SQL Server 2008 , Tips
    Posted to David Overton's Blog by David Overton on Wed, Dec 10 2008
  • SQL 2005 to SQL 2008 forklift upgrade resulted in 50% cpu utilisation (& resolution) – aka SBS 2003 to SBS 2008 SQL Application Move

    I’ve recently moved the database behind DavidOverton.com (also uksbsguy.com) from a Windows Server 2003 system with SQL 2005 to Windows Server 2008 with SQL 2008.  This would be the same process if you were potentially performing a migration from SBS 2003 with SQL 2005 to SBS 2008 Premium with SQL 2008 (or SQL 2005, but the performance issue only happens with SQL 2008). The process was amazingly simple: Stop the database on the Windows 2003 system Copy the datafiles, errorlogs, logs etc to the new system Install SQL 2008 on the new system, creating an instance by the same name Modify the registry to point to my new files (details here ) Start SQL 2008 Obviously I had to do some IIS stuff (create a new site) and install and redirect my logging software (WhosOn), but overall it went very well. Or so I thought until I noticed that my normally nominal CPU utilisation had gone bananas.  One of the SQL 2008 new and improved features is the Server Activity History which makes it very easy to pinpoint problems...
  • Christmas season arrives at the Overton Home, except Yipp Productions for Channel 4 TV were there!

    This year, like all others for the last 10 years we’ve decorated our house with Christmas lights.  We have at least 3 different religious views in our house, which is amazing considering there are two adults and two children, aged 8 and 2, however we love the smiles the lights bring to ours and others' faces, so each year it gets a little grander (or kitch or tacky!). The pictures from this year can be found at http://davidoverton.com/media/g/doverton/tags/Christmas/Personal/default.aspx .  Below is what the outside of my study looks like! So, why Yipp for Channel 4 this year?  The house is “well lit up”, but not enough to make the news, however being a working dad who has had some trials and tribulations, and very much being in the right place at the right time meant I was asked if I would mind being filmed and having a chat about life.  Yipp recruited Martin Hampton to come along, ably assisted by Katie.  You should be able to hear about my life in a very short film clip next year...
    Posted to David Overton's Blog by David Overton on Mon, Dec 8 2008
    Filed under:
  • How to get an existing disk to be available inside Hyper-V, how to install RAID Management tools and how to shrink a non-Dynamic VHD

    Once I had built my Hyper-V Server I still had a few to resolve.  I thought I had better document the solutions I found to my 3 disk related problems from this entry . So the 3 issues covered are: How to get an existing disk to be available inside Hyper-V How to install RAID Management tools How to shrink a non-Dynamic VHD How to get an existing disk to be available inside Hyper-V (called a pass-through disk) Just to give you some background, I was moving a non-VM OS inside a Hyper-V system.  I had created the VM, but I could not get it to just “boot” from the old boot disk – the disk was not showing.  I’d read that this type of disk was a pass-through (or pass-thru) disk, but I could not find out how to configure it easily.  The solution turned out to be very simple.  Run DISKPART on the Hyper-V server, identify the disk and mark it offline.  It would then appear in the list of disks that could be installed.  What is more, if I ran out of disks I could install a SCSI controller...
  • How to change where SQL Server looks for it’s master datafiles (master.mdf)

    I’ve found myself moving datafiles around or backing up to new locations before enough that I need to change SQL to point to the new locations before it will start for me to do further work.  The process to get it up and running is to find the SQL instance in the registry and change 3 values. The magical location is: “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10. <instance> \MSSQLServer\Parameters” Under here you will file 3 arguments.  Notice the double backslashes “\\” which is required for each single backslash you want.  For example, for my site, I have changed them from the default instance pointers to: "SQLArg0"="-dD:\\databases\\Community Server\\master.mdf" "SQLArg1"="-eD:\\databases\\Community Server\\ERRORLOG" "SQLArg2"="-lD:\\database_logs\\Community Server\\mastlog.ldf" Change these to the location of your datafiles.  The “-d” is for the master database datafile, “–e” for the Error Log and finally...
  • Invalid certificate issued to localhost.localdomain when remotely access SBS 2008 from a Windows PC

    This is another question I was recently asked. One particular user noticed that the certificate they saw when accessing their server from the internet did not match that when accessing from the LAN. The certificate looked something like this: This was a little strange as when the system was accessed from the intranet, all things appeared fine. The culprit for them was the SBS 2003 self signed certificate on the same machine. By removing the certificate and then installing the correct new one things got better. To remove the old certificate, start MMC.exe and accept the UAC prompt. Now press Ctrl+M to add a new snap-in and select Certificates and when asked, add for the user account . The do the same again, but select Certificates and Computer Account and hit OK to accept the current computer. Now expand out Personal Certificates and remove any SBS 2003 self signed certificates. To load the new certificates open a browser inside your SBS 2008 network and point to http://companyweb/Lists/Announcements/DispForm.aspx...
  • How to resolve errors like "Cannot connect to the RPC service, make sure your RPC service is running" with Hyper-V Server and Hyper-V Manager

    In my last post on installing Hyper-V for my home setup I said I had a number of issues.  One was that the Hyper-V Manager kept on showing the error "Cannot connect to the RPC service, make sure your RPC service is running".  This turned out to be several issues. To start with my Hyper-V box is in a workgroup, so security is manually configured.  Then there is the connection ID security - by hand and finally there is the client setup too.  I spent a long time with John Howard's blog which got me the following commands for the Hyper-V server: netsh advfirewall set currentprofile settings remotemanagement enable netsh advfirewall firewall set rule group="Windows Management Instrumentation (WMI)" new enable=yes netsh advfirewall firewall set rule  name="Remote Administration (RPC-EPMAP)" new enable=yes profile=domain netsh advfirewall firewall set rule name="Remote Administration (NP-In)" new enable=yes profile=domain netsh advfirewall firewall...
  • Connect Manager for VPNs into SBS 2008 …er, not really, with CMAK information too

    [updated with “roll your own” information and how to make a 32-bit version of the exe file] I love it when people challenge me to solve a question and today’s prize goes to Simon (thank-you for the questions Simon) who asked me where Connection Manager was on SBS 2008? You remember Connection Manager right, to auto configure the VPNs… Well, the instructions in SBS 2008 are a little less simple. Rather than downloading a pre-configured tool you now need to roll your own. The reasoning, which is quite sound, is that you can access almost everything via the Remote Web Workplace, but for some things, you want a VPN and the way to get it can be found here - http://technet.microsoft.com/en-us/library/cc513974.aspx If you want to create a Connection Manager Install for SBS 2008 you need to add the CMAK to the SBS 2008 install. Go to Server Manager and click to add a feature. Install the CMAK by pressing Next. To start the kit, go to the Start Menu, Administrator Tools and then select Connection...
  • Get a RSS feed from Microsoft about what is new for partners (UK at the moment)

    I saw this RSS Hub and decided it had to be shared. Go to https://www.microsoft.com/uk/partner/rss/default.aspx . [updated with fixed url - thanks for the comments] It enables the following segmentation: What roles are you interested in? Management Sales and Marketing Technical What areas are you interested in? Partnering Events Programme Information Public Sector Sales and Marketing Small Business Specialist Training West Midlands Type of Business Hosting Independent Software Vendors System Integrators Web Solutions Products and Solutions Dynamics AX Dynamics CRM Dynamics GP Dynamics NAV Dynamics RMS Licensing Microsoft Financing Software-plus-Services Enjoy!! Thanks David Technorati Tags: Microsoft , Sales , Marketing , Technical , Community , RSS , Partner Program
    Posted to David Overton's Blog by David Overton on Thu, Nov 27 2008
  • I’m a PC and I’m a school governor

    Microsoft’s campaign now has David (UKSBSGUY) in it!! I love PC’s, I love freedom to choose between a PC, a MAC or anything else, but I CHOSE PC’s. I love SBS 2008 and I love small businesses that make the world go round. I also love my family and I’m amazed by the people at my local infants school, so I give back by being a school governor. If you want to know more about the school, go to http://www.yateley-inf.hants.sch.uk/index.html . David Technorati Tags: imapc , Personal , Microsoft , uksbsguy , Windows
  • London 2008 - SMB Nation – 5th December 2008

    It has been a while since I’ve spoken about Harry Brelsford, but he was one of the founding lights in SBS and partners.  I’ve attended and presented at several of his events and he is back in the UK on the 5th December.  If you have the time, given the cost is $200, so not a huge amount, come along. London 2008 SMB Nation Europe 2008 - Conference Information Featuring an ''independent'' Small Business Server 2008 event! Speakers: • Harry Brelsford (Bio at www.smbnation.com) • Jeff Middleton (Bio at www.sbsmigration.com) Location: Microsoft London (Cardinal Place) 100 Victoria Street London SW1E 5JL Delegate Registration HERE for SMB Nation Europe Agenda: December 5, 2008 – Microsoft Central London 8:30am-9:30am Delegate Registration 9:30am – 10:00am Microsoft Introduction 10am – Noon How SBS 2008 Saved The Economy (Brelsford) Noon – 1:30pm Lunch and HP (Essential Business Server, HP Partner Program) 1:30pm – 3:00pm Migration Techniques for 2008 (Middleton) 3:00-3:30 Come see how Autotask...
    Posted to David Overton's Blog by David Overton on Fri, Nov 21 2008
    Filed under: , , ,
  • Getting up and running with Microsoft Hyper-V Server 2008, including getting my external SATA drives working, adding network drivers, enabling the remote management tools

    [updated 7th Dec 2008 with links to more answers] It has been a while since I posted on the blog - I've been writing a book and installing and upgrading SBS 2008 a few times. I decided that rather than have a bundle of servers under my desk I would buy one large server (well, quad core anyway) and run my operating systems using Hyper-V server. Let's start with the ingredients that you will need: Download Hyper-V Server - http://www.microsoft.com/servers/hyper-v-server/how-to-get.mspx Hyper-V Configuration Guide - Microsoft Hyper-V Server 2008 Configuration Guide Hyper-V Getting Started Guide - http://www.microsoft.com/downloads/details.aspx?familyid=26426203-DE3C-4D74-851E-4E1388A81D5F&displaylang=en Download Management Tool (you probably only need one of the below) Vista 32-bit - Download the Update for Windows Vista (KB952627) package now Vista 64-bit - Download the Update for Windows Vista (KB952627) package now Server 2008 32-bit - Download the Update for Windows Server 2008 (KB950050), 32-bit...
    Posted to David Overton's Blog by David Overton on Thu, Nov 20 2008
  • Virtualisation Adoption Survey - if you are using virtualisation (from anyone), tell Virtualisation.info

    A Quick note - there has been lots of comments recently on who's virtualisation has what share of the market. I've just installed Microsoft Hyper-V server up and running with 3 VMs inside it (HomeServer, SBS 2008 and Windows Server 2003) and I expect a couple of small desktops too before long. Anyway, rather than just guessing, why not fill in Virtualization.info's survey? It took me about 45 seconds to complete at virtualization.info's Virtualization Adoption Surveys . I'll post on how I got everything working after I've got the next chapter of the book done. Should be 4 chapters done by the end of this weekend, although I'm behind a few pictures :-) ttfn David Technorati Tags: Hyper-V , Virtualisation , Virtualization , SBS 2008 , Survey , virtualization.info
  • Adding a Windows 2008 Server Core box as a Domain Controller into an SBS2003 domain

    We've installed a Server Core box into our network here so we can run Hyper-V as well as VMware ESX. We have also set it up as a DC and DNS server so that of our SBS box is offline things might continue to work a bit better than they have up until now :-) Instructions on how to do this are a bit sparse and my Technician got this information from the SBSC Newsgroups: From your description, I know that you want to add Windows Server 2008 Server Core to SBS domain. If that's not correct, please don't hesitate to let me know. Unfortunately there is no article talking about how to add Windows 2008 Core to SBS domain. You can add Windows 2008 Server Core to SBS domain with the steps below on the SBS server: 1. Open a Command Prompt window. To do this, Click Start, click Run, type cmd, and then click OK. 2. Perform the following commands in the sequence noted: Note In these instructions, "drive" represents the letter of your DVD drive on SBS server with Windows 2008 DVD inserted. 2. At the command...
  • Puzzle of the week......

    Why does it take so long to prepare the desktop on a Windows 2008 Core server when you RDP to it? I mean it's only a command prompt.....
  • Important Microsoft security update – update your machines now!

    DavidOverton.com rebooted today due to an emergency security update – an “out of band” release from the normal “patch Tuesday” process.  It is worth considering updating and reboot your computers and servers asap.   More information on this can be found at http://www.microsoft.com/technet/security/bulletin/MS08-067.mspx .  Impacted systems below:   Operating System Maximum Security Impact Aggregate Severity Rating Bulletins Replaced by this Update Microsoft Windows 2000 Service Pack 4 Remote Code Execution Critical MS06-040 Windows XP Service Pack 2 Remote Code Execution Critical MS06-040 Windows XP Service Pack 3 Remote Code Execution Critical None Windows XP Professional x64 Edition Remote Code Execution Critical MS06-040 Windows XP Professional x64 Edition Service Pack 2 Remote Code Execution Critical None Windows Server 2003 Service Pack 1 Remote Code Execution Critical MS06-040 Windows Server 2003 Service Pack 2 Remote Code Execution Critical None Windows Server 2003 x64 Edition Remote...
  • Nick King – Microsoft corp SBS God in the UK on 7th November!!

    Hopefully you have seen this elsewhere, but if not….. 7 th November 2008, Reading: TechNet Exclusive! Hear from the guy that brought you Microsoft’s enterprise computing to small and medium businesses An exclusive opportunity to meet Nicholas King, Technical Product Manager from Microsoft Corporation before the launch of the  Windows Essential server solutions offerings, Small Business Server 2008 and Essential Business Server 2008 on November 12 th . Hear Nicholas and Jamie Burgess  advise on why these solutions have been created and why it is still important to invest in solution infrastructure in  economic uncertainty. With the assistance of Jamie they will go into some technical detail around the two products that make up Windows essential server Solutions. 1. Windows Small Business Server (SBS) 2008 is an all-in-one server solution designed to help you keep your data more secure and your company more productive. It provides many of the features used by larger companies, such as e-mail, Internet...
  • Scripts for Windows Vista Magazine

    For this month's Windows Vista Magazine I discussed how to write a script to backup your documents folder and sending alert e-mails. While there are a lot of places to go for help (links below), you will need the following for the following script copies to your user directory (%userprofile). You can get to it by pressing start and literally typing %userprofile%. Create a file called backup_script.cmd with the following: @echo off REM @echo off stops you seeing the individual backup commands executing REM TITLE changes the title of the window REM echo prints the text on your screen REM the other commands are covered in the article TITLE Documents Backup Routine echo Do you want to do the backup – if not, press Ctrl-C pause RMDIR /s /q MD %userprofile%\docs_backups2 Move %userprofile%\docs_backups1 %userprofile%\docs_backups2 Move %userprofile%\docs_backups %userprofile%\docs_backups1 MKDIR %userprofile%\docs_backups Robocopy %userprofile%\documents %userprofile%\docs_backups /s /z exit That is the first...
    Posted to David Overton's Blog by David Overton on Sun, Oct 19 2008
  • SBS 2008 now available for download on MSDN

    Hi there folks, so following on from my recent post on the fact that SBS 2008 has released to manufacturing (which means it will be in the shops soon), I saw today that SBS 2008 is now available to download from MSDN : I did notice that there is currently a slight mis-print in that it appears there are two disks for the x86 Windows Server 2008 disk, where as the 2nd one is actually the x64 disk (as noted in the ISO number).   It is also worth stating that for SBS 2008, to remove any issues around “Compatibility”, for those applications that are fussy, simply run them on the premium server which is Server 2008, so runs anything that you could run on Server 2008.   Go grab if you can’t wait to get it any other way … note that you only need disk 1 to install, but the rest to understand recovery and Premium solutions.   Thanks David Technorati Tags: SBSC , SBS , Small Business Server 2008 , Small Business , Developer , MSDN , Partners , Microsoft , Download , SBS 2008
  • Just in case you missed it SBS 2008: Released to Manufacturing and date for launch set

    I know I am very, very, very behind the times on  this, but just in case you missed it …  This means that SBS Cougar is now completely done and now a 100% SBS 2008!! The Official SBS Blog : SBS 2008: Released to Manufacturing! On behalf of the SBS team, I am extremely pleased to announce that Windows Small Business Server 2008 software has been finalized! Today both SBS Standard and Premium are being released to manufacturing, which means we begin the process of finalizing international versions, creating media, building packaging, delivering the product to distribution channels and handing it off to our OEM partners, so it will be widely available by our November 12 launch. (More information about launch will come in the future.) <snipped> We invested in a number of different areas for this release; here’s the big picture of the themes and features in SBS 2008: For IT managers and technology consultants:  · Microsoft’s newest server technologies: Powerful and more secure infrastructure that...
    Posted to David Overton's Blog by David Overton on Tue, Sep 16 2008
  • How long is the grace period on SBS 2008 (how long can you evaluate SBS 2008 without entering a product key)

    I saw this one come up internally and externally, so I thought I would share the answer.  Remember that SBS 2008 is built on Windows Server 2008, Exchange 2007 and SQL 2008 (for the premium edition).  This means that you are bound by the limits of those products.  For SBS Standard this is Windows Server 2008, which is 60 days that can be extended to up to 240 days using the rearm process documented in the KB article http://support.microsoft.com/kb/948472 . SQL2008 has a trial period of 180 days, so if your evaluating SBS 2008 Premium edition you are limited by that.   ttfn   David Technorati Tags: SQL 2008 , Windows Server 2008 , SBS 2008 , SBSC , Partners , Microsoft , Eval , Evaluation , Trial
« First ... < Previous 5 6 7 8 9 Next > ... Last »

(c)David Overton 2006-23