Ireport: connection to SQL server refused

[kolonaki]

Hello there.

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.

[iluxa]

check that
- server name is correct
- port number is correct (you should be using jdbc:jtds:sqlserver://SERVER:PORT/DATABASE)
- server is configured to accept TCP/IP connections
- there isn't a firewall blocking connections

[kolonaki]

I also use .NET for some other applications, so when I connect to the same database through .NET, I have no problems. So, no firewall blocks my connection and my server is configured to accept TCP/IP connections.

My database is in the folder SERVER_NAME/SOME_FOLDER/DATABASE_NAME

When I run Microsoft SQL Server Management Studio Express, I see that path for my database.

I tried "jdbc:jtds:sqlserver://SERVER_NAME/SOME_FOLDER:1344/DATABASE_NAME", "jdbc:jtds:sqlserver://SERVER_NAME:1344/SOME_FOLDER/DATABASE_NAME" but had the same message as above.

Now what? :-(