Dipna Div

Dipna Div

  • NA
  • 3
  • 1k

Windows authentication account to connect to sql server

Jan 29 2015 1:15 PM
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.

Answers (2)