I read all the treads on this issue and I followed the suggestions and still have a problem.
I made sure the TCP port of sqlserver is 1433 (I ran regedit).
I ran 'telnet MySQLServer 1433' in command prompt and got:
Connection to MySQLServer ... Could not open connection to the host, on port 23: Connect failed"
java.sql.SQLException: Network error IOException: Connection refused: connect
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.sql.SQLException: Unable to get information from SQL Server: localhost.
Unable to get information from SQL Server: localhost.
I will very much appreciate any help. I really don't know what else to try..
Thanks a lot,
If you have downloaded SQL 2005 Express, you need to run the MSSQL Surface Area Reduction tool (its called something like that, Im not positive). By default when you install SQL Server 2005, it does not enable the TCP/IP interface to the engine for security reasons. You must use this tool to explicitly enable communication over TCP/IP. Besides that then, you just have to check your connection.url and ensure you don't have firewall software blocking requests. It's going to be something incredibly simple- becuase certainly this is the most common operation to perform with jTDS
Thanks a lot for your reply.
I already checked and made sure the TCP/IP is enabled.
I tried it also with instance 'mssql'. I downloaded SQL Server 2000, and I have the tools such as Enterprise Manager and Query Analyzer.
You can see in example 1 above that when I don't specify any instance I get a different error. It was just me trying to find what is missing in the url so I took this one from one of the threads. I wanted to provide all the information I have in order to provide the full picture of my problem.
Thanks again for your help,
Also- are you sure the instance is SQLExpress? You explicitly set up your sql server as this instead of the default instance?