Can anyone help me find an example of how to configure an Active Directory service account to work with a SQLServer database?
I have several JSP pages that are currently using a database level login to display read-only data. I need to switch this over to use the service account, rather than the direct database level login.
I have a jsp that is using a jdbc/odbc connection. The JSP passes connection information which currently is the sqlserver id/pw.
The only examples I am finding, pass the user’s identity on through to the database. In my case, I need the queries to just run with a standard windows id set up as a service account.
Doesn't that pass along the user's identity? In my case, the SqlServer database knows about the service account. I want the JSP to run as the service account Id, regardless of the authenticated user that calls it.
I assume you are running the application server as a service. Are you running it using the service account (you should be), or as SYSTEM? Then the JSP will be runnign as the service account and will use that account when it accesses SQL Server.