June 2005 - Posts
A quick update. Sorry I have been so quiet.
Tomorrow, I will see you at Microsoft Dublin, where I will be helping Harry Brelsford with the Q&A sessions on Small Business Server 2003.
More info here:
So, a newsflash!
My sister Amanda just won the overall best hairdresser and 2 Golds, 2 Silver medals in the European Hairdressing Championships! Now she will compete for the World chapionships :)
You have to love new products. Many sleepless hours.
Another issue that I have found with WSUS is that if you install it on a SBS2003 Box, that already has SQL installed (Premium Tech). Then the installer will get to the stage of setting up the MSDE instance, then start to roll back and fail.
The workaround for this is to download MSDE from the Microsoft site and install an instance manually. Then setup WSUS again and use that instance.
This may sound messy, and you are probably wondering why you would use MSDE when you have SQL already installed? Well the answer is simple for me. I am more than 400 miles away from the client in some situations, and setting up MSDE by downloading it is far far easier than trying to explain to my clients to put the correct SQL disk in the drive ;)
If I get a fix from MS, I will post it here.
So, for three days I have been trying to understand why my SBS Client machines were not showing up on the WSUS Console...
I have found that the answer is simple, but not clear (judging by the amount of posts on the subject on the web).
So here it is people:
You MUST, on a SBS2003 install of WSUS, set the update location on the clients to http://yourservername:8530
If you do not put the port name in (like I did until about 20 minutes ago) then it appears to work by giving you no errors on the WindowsUpdate.log file, but in fact does not work!
After doing this, stop the Automatic Updates on the client machine, then restart them. After that, type wuauclt /detectnow on the client Command Prompt and you will very shortly after have PC's showing up on the WSUS console.
Oh, by the way... the XPSP2 Firewall can safely remain on.
OK, there is a strange and wonderful issue with MSDE that I could not find a tech note on on microsoft.com, so before I go off to write one up, here is the problem and solution. This happened to me on a SBS2003 (No SP1) install, but I do not know if that is even relevant.
MSDE install rolls back, and you get no specific error except the default 11708 Error in the event viewer saying:
Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
However, if you enable verbose logging of the install, you will find something like the text below:
Unable to open service.
Unable to connect as the SQL service is not running.
Ending custom action UpgDetectBlankSaLogin().
Action ended 16:21:18: UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 3.
Action ended 16:21:18: INSTALL. Return value 3.
For an unknown reason (to me anyway) the installer will reject the SAPWD parameter on your command line install. However, all is not lost, you can do the following to get around the issue:
Instead of using the SAPWD="yourpasswordhere" replace that with BLANKSAPWD=1, which installs MSDE without a SA Password.
After you reboot the machine, start the SQL instance, then using the command prompt type:
osql -S (local)\YOURINSTANCENAME -U sa -P "" -Q "sp_password NULL,'Typeyourpasswordhere', 'sa'"
This will give you a "Password Changed" message, and you are good to go.
I have heard through the grapevine that tomorrow Dell will be releasing in Europe its first desktop x64 machine, the GX260. I understand that shipping of orders may not commence till mid June however.
As I understand it, the initial launch will have 32bit technology, but in late august 64bit technology. A fellow MVP Charlie Russel has a good writeup on this new technology here. Also, Microsoft have done a very cool thing recently with Windows XP x64 as previously reported by Chad Gross, they are giving free X64 upgrades to regular Windows XP users for free here.
All in all, this is good news. I personally can't wait for these new PC's, from a business perspective. Oh, and a gaming perspective ;) (I wonder out loud if FS10 will take advantage)