SQL 2005 provisioning tool for Vista (oh yeah, and Windows 2008)

I think that I have setup SQL Server (6.5, 7.0, 2000 and 2005) about a thousand times.

Asides from a few minor things here and there, this install works really well and usually there isn't a problem.

Today I installed on Windows 2008, and after a few setup things as outlined in http://support.microsoft.com/kb/920201 the install worked perfectly. I then install SQL 2005 SP2 and was prompted for the SQL 2005 Provisioning Tool for Vista users at the end. I thought, this particular customer are all using Windows XP and besides that, they will not be accessing SQL directly, on through CRM, so I opted out of that.

So, when I tried to log into SQL Management Studio to verify everything was A-OK, I was surprised to see that I was not allowed to login. I was logged in with a domain administrator, and I cannot log in? I couldn't even use 'sa' because I installed windows authenticated mode as opposed to mixed.

After some digging around, I realized that Windows 2008, is, in its own way "Vista Server" so by not running the provisioning tool, I ended up locking myself out of SQL Server. Running that that tool got me in, hopefully this note will save some folks a lot of headaches!