Deploying an application containing SQL Server database. Which authentication method?

Question

I'm just a beginner in SQL Server database development and was wondering which authentication method to use. My database needs to have the simplest protection there is.

If I choose Windows authentication, what username and password do I pass when connecting to the database? What will happen when another user installs the application on his computer with different credentials?

I'm real beginner, so please excuse me if I'm asking the obvious.

Answer 1

If I choose Windows authentication, what username and password do I pass when connecting to the database?

You use the domain login & password for the profile you wish to connect to the database as.

What will happen when another user installs the application on his computer with different credentials?

Depends on how you setup the domain account/role association with the SQL Server role/permissions. Assuming same AD groups, there shouldn't be an issue. This is why you should grant to a role, rather than specific users.