I get to work with SQL 2008! So, the laptop I was given for work already had SQL 2005 Express installed as the default instance. Why on Earth that was there, I don't know. While there is probably a better way to change that during the SQL 2008 install, I opted to remove it completely. So, with a lappy toppy clean of all SQL programs, I installed SQL 2008! Awesome stuff. Most of the install steps are intuitive. The one thing I always like to do is install my SQL server as the default instance and turn on mixed mode authentication. The other two things I ran accross during the install were the install wizard screen for setting a user account to the various SQL services, and setting the path for all the data folders. This seemed like a new feature that the SQL 2005 installer didn't have. Although I'm sure you could get in and change all the SQL 2005 services to run under specific user accounts if you wanted to. I decided to look for guidance on th eweb and found the following step by step install for SQL 2008 RC0. Which is still good in the full release.
http://sqlblog.com/blogs/andy_leonard/archive/2008/07/15/installing-sql-server-2008-rc0.aspx
So, under that guidance, I set up a new user account, put it in the Admin group, and setup a new Data folder at the root of C. Then because I fear the unknown, I went ahead and set security on the folder to full control for the new user account and for the Network Authority/Local Service account. What the heck, right? I would not recommend that exact setup on a production server, of course. The install wizard prompted for the Data folder path so I replaced the "Program Files/Microsoft SQL Server" part with "Data". This is an install I can feel all warm and fuzzy about. Now let's see if I hit any roadblocks later. :)
6ed49dc0-b640-4340-b0dd-a8883601e1a4|0|.0