c# - authenticate using sql server logins -

Is a good practice to use SQL Server login? For example, in an application, ask for a username and password, and then try to connect to the database using those credentials? (Maybe to get user information), and then there is no need to store the user or password in the connection string like this in the same way, only server and database information. I know that I have to create a database user for each user and should login, what is the result of doing this like this?

I am not a country apologetic for my English, this is also my first post :)

Thank you.

IMO, there is no problem unless you have proper permission in the user Database server pre: application Northwind uses the database but the user does not have access or appropriate permission to access the Northwind database, users will see the exception. To work for this, we have to set the cloning to the right.

To build this, create the AD group and give proper permission to this group on the database. Now, when adding new users, add users to this group to reduce errors.