I am developing an windows application in c# with sql server as back end with windows authentication i want username and password for sequrity purpose can i set username and password without changing it to server authentication.
I tried to do something similar in the past but could only manage to get the windows identity of the current windows user and not the password. It might be better security purposes to get the user to create a new password different to the one they use to log into their work station.
to get the windows identity i did this:
then simply stored it in a users table in the SQL server DB with the password entered by the user on a registration form.