#1 SQL install tip for everyone - Microsoft thinks you should use Windows authentication only, but just about every developer on the planet writes their apps to use mixed mode and authenticate the app with a sql server account, not a windows account. The install defaults to Windows authentication, and you have to choose mixed mode in beginning of the install.