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

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.