MOVED:SQL 2005

[ddkdavid]

I have tried to configer jasper report to use the SQL 2005. It does not understand the drivers. I went trhough all these steps below but the JDBC drivers for SQL 2005 were not being recognised by Jasper server

What should i do to electify this issue

1. Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver
2. Extract to a good location. I chose c:\program files to extract to.
3. Copy the sqljdbc4.jar to your installation directory which by default is:
    c:\program files\jasperserver-pro-3.5.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib
4. Restart JasperServer (there is a shortcut in the start menu to restart it).
5. Log into JasperServer’s web site. http://YourServer:8080/jasperserver-pro
6. Go to View | Repository.
7. Click the second icon called Add Resource and select Data Source.
8. Choose JDBC Data Source and click next.
9. Provide any Name, Label, and Description.
10. For the driver put this:
     com.microsoft.sqlserver.jdbc.SQLServerDriver
11. For the URL put this:
     jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase;
12. Enter the username and password.
13. Select a time zone.
14. Click Test and it should succeed.