In the default persistence.properties (in %/JBOSS_HOME%/server/yourconfig/deploy/ejb3.deployer/META-INF), you set the dialect with HSQLDB.
You should remove this line. Hibernate has a dialect auto detection mechanism that worlk on the main DBs (HSQLDB SQL Server, Oracle), setting the dialect prevent this mechanism to work.