What are the things I have to consider when I have to install SQL Server (2005/2008) on a new server?
- Storage setup
What are some common mistakes made in that process?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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/
If you want to install the Express version, here are some tips for the network connectivity configuration:
"Out of the box, SQL Server Express's network connectivity settings aren't enabled."
Talk about an understatement!