• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

how to mound a jdbc resource with an AD account

I am trying to use a jdbc resource to a MSSQL db which is SQL and Windows accounts enabled.
When using a windows domain account, it is rejected while using a SQL account, it works.
Is there a specific syntax for domain accounts? other than DOMAIN\account ?
db = MSSQL 2008 on w2003
client = vista pro
driver = sqljdbc4 (microsoft)
0
lesouef
Asked:
lesouef
1 Solution
 
Anthony PerkinsCommented:
So this is a web app, right?
0
 
lesouefAuthor Commented:
no, I am using a Java application (Servoy).
0
 
objectsCommented:
have you got integratedSecurity=true in your connection string?
appears you may need a dll installed as well
http://msdn.microsoft.com/en-us/library/ms378428.aspx
think you may also need to be logged in as that user
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
lesouefAuthor Commented:
bingo, you're the king.
extra one: how do you use this on a server where this will be used by a service? if I start the service with a specific account, will that be used as the current credentials by integrated auth.?
0
 
objectsCommented:
> will that be used as the current credentials by integrated auth.?

I think so
0
 
lesouefAuthor Commented:
not sure you need to dll actually, because once the integrated security string is specified, everything works for me.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, I can confirm that the server, started under a dedicated windows account, will work like that...
0
 
lesouefAuthor Commented:
good. thanks.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now