File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JBoss/WildFly and the fly likes MS SQL SERVER for JBOSS 3.2.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "MS SQL SERVER for JBOSS 3.2.1" Watch "MS SQL SERVER for JBOSS 3.2.1" New topic


Fabian Schulcz

Joined: May 13, 2004
Posts: 2
Hi all!

I am trying to setup JBoss to use SQL-Server as default datasource.

I followed the JBOSS getting-started.pdf as well as a thread in this forum.
My files look like that:


<!-- remove this depends tag if you are not using the tcp connection url -->

in login-config.xml:

<!-- Security Domain for MS-SQL -->
<application-policy name = "MSSQLDbRealm">
<login-module code = ""
flag = "required">
<module-option name = "principal">x</module-option>
<module-option name = "userName">x</module-option>
<module-option name = "password">x</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MSSQLDS</module-option>

Still, what I get is this:

2004-05-13 12:59:13,970 ERROR [] The ConnectionManager mbean: jboss.jca:service=LocalTxCM,name=MSSQLDS specified in a ConfiguredIdentityLoginModule could not be found. ConnectionFactory will be unusable!
2004-05-13 12:59:13,985 ERROR [] Starting failed
java.lang.SecurityException: Invalid authentication attempt, principal=null
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getSubject(
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(

I understand that my datasource isn't local, right!?!
When try to use XaTxCM the error is the same

What do I miss, anyone knows ??

Help's appreciated a lot Fab
Fabian Schulcz

Joined: May 13, 2004
Posts: 2
N E V E R M I N D ! !
Shawn Perreault

Joined: Dec 23, 2008
Posts: 1
A perfect example of what NOT to do after you have figured out your issue...
Peter Johnson

Joined: May 14, 2008
Posts: 5852

Shawn, welcome to Java Ranch!

Also, are you by any chance hinting to Fabian that he should describe what he did wrong so that others can benefit? If so, I heartily agree.

JBoss In Action
I agree. Here's the link:
subject: MS SQL SERVER for JBOSS 3.2.1
It's not a secret anymore!