How to use Windows Authentication to connect to Microsoft SQL Server with EAP or SOA-P

Solution Verified - Updated -

Issue

  • EAP/SOA-P is unable to connect to Microsoft SQL Server using Windows user account based authentication
    • EAP/SOA-P connection is successful when using native SQL authentication
    • Successful connection using SQL Server Management Studio with Windows authentication has been verified.
  • SOA jboss-as/tools/schema/build.xml requires database information but Windows authentication must be used
    • Is manual update of all generated files to include integratedSecurity=true required?
    • Is there a build script that can configure Windows authentication?

Environment

  • JBoss Enterprise Application Platform (EAP)
    • 6
    • 5
    • 4
  • JBoss SOA-P
    • 5
    • 4
  • Microsoft SQL Server

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In