This forum is no longer active. Please post your questions to our new community site

Change db from mysql to sqlserver

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

 
Avatar Axesys 2 post(s)

What i need to configure for change the db from mysql to sqlserver?

 
Avatar Beltrán Rueda Administrator 3,714 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.