It depends on what the vendor requires. If you have the ability to choose, do you want layered security or integrated security. If you want to use a layered approach (which is required in some industries), you have to create an sa (system administrator) password, which you should document, and lock away. From there it is a matter of creating individual accounts for each user/process, and grant access to databases, just like you would with configuring domain accounts within EM.
It is easy enough to change at a later time if needed. Takes about 10 seconds and a restart of the SQL services. Klint Joseph L. Casale wrote: > > 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/> ~
