locked
Windows Service Logged On User RRS feed

  • Question

  • We are accessing the database from the windows service. To make the connection string we are using the domain user.
    could you please let us know whether we can use the windows LogOn (this is also the domain user) as the user for the database connection
    Wednesday, July 1, 2009 11:23 AM

Answers

  • If you are using ODBC, you can include "Trusted_Connection=yes" in connection string.
    If you are using OLEDB, you can include "Integrated Security=SSPI" in connection string.
    More info please refer to http://www.connectionstrings.com/
    Wednesday, July 1, 2009 2:35 PM
    Answerer