SQL Server setup check list

What are the things I have to consider when I have to install SQL Server (2005/2008) on a new server?

  • Storage setup
  • TempDB
  • Security

What are some common mistakes made in that process?


Please see Brent Ozar's great post on the topic: http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/


I usually revoke the VIEW ANY DATABASE permission. By doing this each user can only see the databases they are able to access (it also helps simplifying the list in SQL Server Management Studio):

USE master
REVOKE VIEW ANY DATABASE FROM PUBLIC
GO