SQL Server 2005 Developer and AdventureWorks on Vista

I had a problem getting the AdventureWorks sample database that I installed to run under Vista RC1. SQL Server Management Studio kept reporting an error when I tried to access either the AdventureWorks or AdventureWorksDW databases. To get around this, I discovered that I needed to add my Windows user account to the sysadmin server role. After doing this, I was able to access both databases.

On a side note, I can't get SQL Server 2005 SP1 to install. It keeps prompting with a dialog box reading "Error performing inpage operation" regardless of whether or not I run the installer as administrator. Looks like I'm stuck waiting for SQL Server 2005 SP2 for this to work right.

Getting Virtual Server 2005 R2 to work under Vista

I found an excellent post discussing how to make Virtual Server 2005 work on Vista, but the key thing that helped me was changing the authentication on the VirtualServer virtual directory to Basic Authentication (it was originally Anonymous Authentication). This prevented me from having to run IE as an administrator.

Update 16 Oct: after moving my VMs back to my machine, I discovered that the basic auth enabled me to start the machines and use the virtual machine web site, but when I tried the ActiveX control to actually control the machines, it would not accept my user account when prompting for the remote control. Virtual Server 2005 R2 SP1 beta 2 did not help. I ended up going back to Windows integrated security for the VirtualServer virtual directory and doing a "Run as Administrator" on IE before browsing to the administration website.

Burning software for Vista?

Aargh, it seems to be pretty difficult to find any CD/DVD burning software for Vista. I had been using Nero 6 but it is marked as not compatible upon install (and I've read of other users having a problem with this). Any thoughts as to what I can use?

Early Windows Vista RC1 impressions

My hard drive died, so I rebuilt my laptop with Windows Vista RC1. Here are my initial impressions after a week living with Vista:

Good

• Backup is integrated and does scheduled backups with differentials
• Shore is purty
• New security features exist to allow 'sudo' when executing programs with elevated privilege needed
• BitLocker drive encryption (in Vista Ultimate) is native

Bad

• Trend AntiVirus does not install
• FreeMind
• Open dialog fails (but you can open mindmaps by drag-and-drop or double-click association)
• Save As dialog fails (so, you need to have a blank mindmap to copy for new maps); existing maps can be saved
• Uses a ton of HD space (~10GB just for Vista alone)
• Nero 6 doesn't work
  

Other Points of Interest

• .NET Framework 1.1 is not installed; have to install it and the SP1 patch for it to function