Ireport: connection to SQL server refused
I am new at Java and especially ireport. I am running 3.7.1 version and I am trying to create a connection to a SQL server.
I downloaded the most recent driver, so in the JDBC Driver field I pass "MS SQLServer (net.sourceforge.jtds.jdbc.Driver)". In the JDBC URL field, which by default it is "jdbc:jtds:sqlserver://localhost/DATABASE", I change it to "jdbc:jtds:sqlserver://MY_SERVER'S_NAME/MY_DATABASE'S_NAME", I enter the right username and password but I get the error: "SQL problems: Network error IOException: Connection refused: connect".
What should I do?
Thank you in advance.