Unable to use MS SQL Server named instance in JBoss SOA Platform pre installation

Solution Verified - Updated -

Issue

  • I am attempting to connect a MS Sql Server named instance to JBoss SOA-P in our environment.
  • I am running the schema script and including the hostname of the instance as HOSTNAME\INSTANCE, however, the slash has been removed from the contents of the mssql-ds.xml file are as below.
  • Is specifying the server and instance separated by the slash the correct way to specify it?
  • I changed the mssql-ds.xml file and changed the connection as follows, however, on starting the server there are exceptions indicating that JBoss is still attempting to connect to HOSTNAMEINSTANCE:1433 (i.e. ignoring )
 <connection-url>jdbc:sqlserver://HOSTNAME\INSTANCE:1433;DatabaseName=soa</connection-url> 
  • Contents of mssql-ds.xml:
...
        <connection-url>jdbc:sqlserver://HOSTNAMEINSTANCE:1433;DatabaseName=soa</connection-url>
...
</datasources>

Environment

  • Red Hat JBoss SOA Platform (SOA-P) 5.3.0

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
Close

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