This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

example using service account

 
Jeff Downey
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thanks in advance for your assistance!
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Would using integrated authentication work for you? I think that this assumes that you are running your app server under an AD account and not the system account.
 
Jeff Downey
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Am I missing how it works?
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic