How do we configure this in the XML file? Currently our XML config file shows this:
< jndi-name >StatDataSource< /jndi-name >
< connection-url >jdbc:jtds:sqlserver://QUEST101:1433/STAT< /connection-url >
< driver-class >net.sourceforge.jtds.jdbc.Driver< /driver-class >
< connection-property name="instance" >QUEST101< /connection-property >
Since we moved to one central hostname without an instance name, how do we configure?
The instance line is not needed at all since your MS SQL database do not use instance name anymore, the line itself should have been deleted. During these moves, the Stat client is also needed to be changed (Stat.ini file).