I'm bringing up our first SQL Server 2005 production server. Does anybody have any advice as to what to watch out for, what not to do, what to do, etc...



I'm just nervous and want to make sure all my bases are covered... its 10 times harder to make changes once we release this server into production.



Thanks ;-)

Not really any gotchas... just make sure that you have the authentication option set right from the get go... i.e.: if you want SQL Server auth to be enabled (so you can use "sa" or whatever), then it's much easier to enable it through the install than it is once it's up (as you mentioned).  Other than that, we let pretty much everything stay at the default.