Connecting Ireports to sql 2005 server

[mmedici]

 I am having a very hard time connecting my ireports to a new sql2005 server.  If i use an odbc connection it tests fine.

ODBC Connection Settings:

Which sql server do you want to connect to? servername\x3

logon ID/password: PROD/password

change default database to x3v5

tests successfully

 

if i go to create a JDBC connection in ireports i try the following

jdbc driver: i have tried both ms sqlserver (2005) (com.microsoft.sqlserver.jdbc.sqlserverdriver) and (net.sourceforge.jtds.jdbc.driver)

for the settings

Server address: IP address of server, and servername\x3

database: x3v5

username: PROD

password: password

 

I always get an error of:

SQL problems: network error IOexception: connection refused: connect jdbc:jtds:sqlserver://servername/x3v5

or

sql problems: the tcp/ip connection to the host servername, port 1433 has failed.  error: connection refused: connect. Verify the connection properties, check that an instance of sql server is running and accepting tcp/ip connections at the port, and that no firewalls is blocking tcp connections to the port

 

can anyone shed some light on this for me?

[mmedici]

 i fixed the issue

 open SQL Server Configuration Manager -> Protocols for SQL SQLEXPRESS, select Properties of TCP/IP. In the tab IP Addresses, set the TCPPort in section IPAll to 1433.