Connect JasperServer and Sql 2008
i tired these steps :
# Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver
# Extract to a good location. I chose c:program files to extract to.
# Copy the sqljdbc4.jar to your installation directory which by default is:
c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib
# Restart JasperServer (there is a shortcut in the start menu to restart it).
# Log into JasperServer’s web site. http://YourServer:8080/jasperserver-pro
# Go to View | Repository.
# Click the second icon called Add Resource and select Data Source.
# Choose JDBC Data Source and click next.
# Provide any Name, Label, and Description.
# For the driver put this:
com.microsoft.sqlserver.jdbc.SQLServerDriver
# For the URL put this:
jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase;
# Enter the username and password.
# Select a time zone.
# Click Test and it should succeed./reporting/jaspersoft/
But Connection test failed? ANyone can help me?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 1, 2010 4:03 AM
UPDATED:
September 1, 2010 5:39 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Did it give you an error message? Are you sure that the SQL Server is listening on port 1433? Are you sure that the server can resolve the name correctly? Can you telnet from the server to the SQL Server on port 1433?