Unanswered: SQL Server 2k Security Setup on Application Server
If i wanted to set up my SQL Server DB to run in an Application Server environment (i.e. clients connecting to a remote server)
would i be required to give every user a WINDOWS SERVER logon as well as a SQL Server logon or would i only need to setup just a SQL Server logon for them?
(obviously using SQL Server Security opposed to NT Integrated Security)
you could give them a single sql login that all users can use
you could give each collection of users a single login defined by their organizaion
you could give each individual user a independent sql login
the choice is yours.
your best scenario would be to use windows authentication because you would have one user and one account through the os and auditing and the ability to use os groups as logins instead of individual users.
the advantages of using windows authentication greatly outweigh almost any cons you might present.