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