I am trying to work out whether I should use windows or sql server authentication.
I have an access front end application that is connecting to sql server via odbc.
sql server authentication may be the easiest as when new windows users are created, they will not need to be setup in sql server. However, I am concerned abot having a hard coded userid and password.
What would other developers recommend - sql or windows authentication ?