Just out of curiosity did you try running "SQL Server 2005" after setting up the compatibility mode and granting it admin rights ?
I have a few programs that would not install or work until the compatibility mode and admin rights were granted.
That isn't a Windows 8 issue it's a user issue opting to use SQL Server 2005 on a system running updated code. I'm 100% confident you did not try compatibility mode which is the point of that feature.
"The second PC is a Home Theater PC. My monitor is a 72" HDTV. On that one I rely on the on-screen menu. Many times in Metro there is no way to bring up the keyboard when you need to enter text i.e. for the search function or to log in to my Microsoft account."
Really ? How about learning how to use shortcut keys first ?
Windows key + I
Windows key + c
Windows Key + q
Gives you full control.
The only reason I'm going around commenting is because I've been reading so many useless reviews and it's not right to bash a product based on lack of user experience. I almost didn't buy Windows 8 because of the false and over exaggerated negative reviews.