• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL server weird connection problem-Pls help

 
asda asda
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"asda asda"

Please review the JavaRanch Naming Policy and update your name to something more appropriate than you chose when you signed up.

-Scott
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic