Connect JasperServer and Sql 2008

5 pts.
Tags:
Jasper
JasperServer
JDBC
SQL
SQL 2008
SQL Server 2008
SQL Testing
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    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?
    66,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following