Windows authentication account to connect to sql server

Question

I have a wpf win forms application. I was using sql authentication to connect to the sql server, but recently discovered that the production server allows just windows authentication. I cannot provide access to all the users. Is there a way to provide to use windows authentication and connect to the db using a common windows account.

If I set integrated security=True;user id=abc;password=*** , it will still take the logged in users credentials. Is there a way to overrirde the login users credentials with the windows account details I am providing, in this case abc.

Dipna Div · Answer

i want to authenticate when the application starts. I dont have a login page. When the application starts I connect to the db and check if that user has access to the application. But I am not able to connect to the db now. I cannot use sql authentication. I need to connect to sql using windows authentication and using a common windows account. How can that be done?

Vithal Wadje · Answer

its depend on you when to authenticate user from windows credential or sql db credential before redirecting page from login to main