Installing JasperServer (3.5.0-CE) on MSSQLServer?

[bmueller]

 Hello,

can someone give me a guide or scripts how to install JasperServer 3.5.0 -CE

on MS SQLServer 2005 / MS SQLServer 2008 / Express?

 

thanks

Benjamin

 

[bmueller]

 So, after a few hours a was able to create the ddl file. Still do not know how but i will figure out that too ;)

[bmueller]

When using this ddl you have to import users and other things yourself.

[coombsj]

Curious as to know how you did this, what all did you have to get it to work?

Are there any tutorials in interacting with MS SQL Server 2008?

[bmueller]

Here is my own Guide:

 

You need maven, jasperserver-<ver>-src.zip, jasperserver-<ver>-bin.zip

and the files in the installfiles-JasperServer-SQLServer.zip

 

Modify the files from my zip file as needed and include your jdbc driver.

(see the readme.txt files for details)

 

Create a database with the name you configured and than run these commands in <js-src>

jasperserverbuildomatic

 

js-ant build-ce

js-ant build-js-ddl-ce

js-ant init-js-db-ce

js-ant deploy-webapp-ce

All commands should be succesful

Now you need some users and roles, use the js-import tool to import your files.

This should work for every version of SQLServer that is supported by your JDBC driver.

 

Post Edited by bmueller at 07/22/2009 06:26

Post Edited by bmueller at 07/22/2009 06:28