StrataFrame Forum » .NET Forums » General .NET Discussion » SQL Server 2005...

SQL Server 2005...

StarkMike — Thu, 12 Apr 2007 08:51:58 GMT

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 ;-)

RE: SQL Server 2005...

StrataFrame Team — Thu, 12 Apr 2007 08:51:58 GMT

Aye, good point, Keith... TCP/IP is not enabled by default on SQL Server Express. You have to go into the Configuration Manager, enable it, then restart the service. It is, however, enabled by default on the full version of SQL Server 2005 (Workgroup & up, the ones you have to pay for :)).

RE: SQL Server 2005...

Keith Chisarik — Tue, 10 Apr 2007 18:00:46 GMT

I have done a few SQL 2005 production deploys now and I agree to leave most of the defaults, that and don't forget to turn on TCP/IP (hehe I did that my first TWO times), LOL.

RE: SQL Server 2005...

StrataFrame Team — Mon, 09 Apr 2007 17:08:47 GMT

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.