I agree,
SQL 2000 is going end of Life, very soon. GO with SQL 2005 much more feature rich. Set SA to a complex password as before and store it away, and don't give the vendor SA rights, DBO to there database or less is usually all they need to do the majority of there stuff, and be adamant on this. Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 ________________________________ From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 4:56 PM To: NT System Admin Issues Subject: RE: SQL 2k Install Don't install sql 2000. Sql 2005 MINIMUM. That being said, I always used "mixed", so I can have a separate 'sa' account. Without "mixed" sa is mapped to administrator. Regards, Michael B. Smith MCITP:SA,EMA/MCSE/Exchange MVP http://TheEssentialExchange.com From: Joseph L. Casale [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 4:47 PM To: NT System Admin Issues Subject: SQL 2k Install I have to install SQL 2000 for an ERP app, what is your recommended setup parameter with respect to Authentication Mode: Windows Only, or Mixed Mode with an SA account? What's the diff? Thanks! jlc ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
