Forums → JasperServer →

Change db from mysql to sqlserver

Subscribe to Change db from mysql to sqlserver 2 post(s), 2 voice(s)

 
Oct 16, 2008 3:04pm
Avatar Axesys 2 post(s)

What i need to configure for change the db from mysql to sqlserver?
 
Oct 17, 2008 6:20pm
Avatar beltran Administrator 417 post(s)

Hi Axesys,

I do not know if JasperServer supports SQLServer but if you try it, the common steps are the following:

1. Download the java connector to SQLServer database and put into the apache-tomcat/lib folder. You can find for SQLserver 2005 at http://msdn.microsoft.com/en-us/data/aa937724.aspx

2. Create the database for jasper in your SQLServer and create an user for it.

3. Modify the apache-tomcat/webapps/jasperserver/META-INF/context.xml file with the new database name, user and password.

And I think that’s all.
Forums → JasperServer →