I have set up JBPM 3.3.0 with SQL Server 2005 & JBOSS 4.2.3 GA. I ran the SQL scripts that were part of the release under database folder in the JBPM 3.3.0 release version. I had to change the .hbm.xml files inside the location server\default\deploy\jbpm\jbpm-enterprise-bundle.ear to make it point to my defined schema.
Earlier I faced an error whenever I tried to deploy the process archive as it was calling the JBPM_PROCESSDEFINTION table directly without a schema name & rightly so. So I made changes in jbpm-identity.jar & jbpm-jpdl.jar to make it point to my defined schema eg <schema_name>.JBPM_PREOCESSDEFITNITION. & the process got deployed successfully.
Now when I try to login through the jbpm console, I can't enter since there is no corresponding table & data that is created in SQL Server 2005 for the same.
I found in some of the sites that there are some tables eg JBPM_ID_USER,JBPM_ID_MEMBERSHIP but I didn't find this as a part of the sql script with this release.
Where can I get the full set of JBPM 3.3.0 SQL scripts for SQL Server 2005?
There never have been a full set of sql scripts in de kits/suite/installer for populating the tables, just scripts for creating tables. Not sure why you had to change the .hbm.xml files and in jars unless you use a custom database setup, but that will always be the case then.
A script for populating the JBPM_ID_* tables is in the wiki