How to use Windows Authentication to connect to Microsoft SQL Server with EAP or SOA-P
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.xmlrequires database information but Windows authentication must be used- Is manual update of all generated files to include
integratedSecurity=truerequired? - Is there a build script that can configure Windows authentication?
- Is manual update of all generated files to include
Environment
- JBoss Enterprise Application Platform (EAP)
- 7
- 6
- 5
- 4
- JBoss SOA-P
- 5
- 4
- Microsoft SQL Server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
