So i am upgrading our SBS box at the office to R2, sounds simple right... Well i have had some serious dramas.
After install the R2 updates i went to upgrade SQL from 2000 that comes with 2003 to the 2005 workgroup edition that is included with R2 premium.
I was previously running WSUS on this box, and it was actually pointing to a full blown SQL2000 database, and the R2 install picked up on this and just continued to use the SQL2000 database. So when i went to upgrade SQL, i couldnt. I had to uninstall R2, unistall WSUS, reinstall R2 with WSUS, then i could upgrade SQL. Am currently upgrading the Sharepoint instance to get the full Search features :D following Susan Bradleys guides http://msmvps.com/blogs/bradley/archive/2006/09/29/Things-Susan-learned-while-blowing-up-her-server-on-a-Friday-night.aspx So just like susan i had a long "entertaining" night upgrading to R2 but im hoping it will be worth it. Oh and i did follow her lead, i locked myself out :S