11

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?

splattne
  • 28,348
  • 19
  • 97
  • 147

4 Answers4

11

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/

Mark S. Rasmussen
  • 2,108
  • 2
  • 21
  • 31
  • 1
    WOW, dude, that's the first time I've ever seen somebody else quote my setup checklist. I'm flattered. I'm so used to going into these questions and copy/pasting my own link to my checklist - now somebody else is doing it for me. Love it! So of course I gotta upvote ya, heh. – Brent Ozar Apr 30 '09 at 12:07
  • Brent's list is very thorough, I would add: make sure anti-virus is configured to bypass sql database files either by location or extension. – SqlACID May 01 '09 at 12:08
  • SqlACID - great point, and I'll add that to the checklist. – Brent Ozar May 30 '09 at 23:41
3

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
troethom
  • 131
  • 3
2

Not offense to Brent Ozar, but Chad Boyd also has a very good series of SQL checklists:

The cluster checklists, in particular, are invaluable.

Portman
  • 5,263
  • 4
  • 27
  • 31
  • Links have been moved for this old answer, here you can find these http://www.mssqltips.com/sqlserverauthor/2/chad-boyd/ – icnivad Aug 07 '13 at 04:12
0

If you want to install the Express version, here are some tips for the network connectivity configuration:

SQL Server 2008 Express Installation Checklist

"Out of the box, SQL Server Express's network connectivity settings aren't enabled."

Talk about an understatement!

Community
  • 1
splattne
  • 28,348
  • 19
  • 97
  • 147