I m using SQL server 2005 express. My default logon mode setting is set to-SQL server authentication and I can logon to using SQL server management studio express always. I enabled TCP/IP from SQL server configuration manager. The sqljdbc.jar (
JDBC driver) is set correctly in classpath and 1433 port is allowed in windows firewall. YET, I can�t connect to sql server using the following code-
My host name is- Tanvir. So, in management studio express the server name is shown- TANVIR\SQLEXPRESS
When I run the code it says-The TCP/IP connection to the host has failed.
Java.net.connectException:Connection Refused: Connect
One more thing, though 1433 port is allowed in windows firewall, I can�t connect to that port using telnet (e.g. telnet <server_host> 1433).I even disabled firewall and tried but in vain. PLEASE help me any brother.