Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

4 Answers 4

up vote 11 down vote accepted

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/

share|improve this answer
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 1 '09 at 12:08
    
SqlACID - great point, and I'll add that to the checklist. –  Brent Ozar May 30 '09 at 23:41

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
share|improve this answer

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

The cluster checklists, in particular, are invaluable.

share|improve this answer
    
Links have been moved for this old answer, here you can find these mssqltips.com/sqlserverauthor/2/chad-boyd –  icnivad Aug 7 '13 at 4:12

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!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.