I am writing a java code to connect with MS SQL Server 2005. MS SQL Server is on Remote server windows server 2003. I am trying the following code but i am unable to establish a connection:<\/p>\n
import java.*;\n\npublic class Connect {\n private java.sql.Connection con = null;\n private final String url = \"jdbc:sqlserver:\/\/\";\n private final String serverName=\"xxx.xxx.xxx.xxx\"; \n private final String portNumber = \"1433\";\n private final String databaseName=\"myDb\"; \n private final String userName =\"user1\";\n private final String password = \"xxxx\"; \n private final String selectMethod = \"cursor\";\n\n \/\/ Constructor\n public Connect() {}\n\n private String getConnectionUrl() {\n return url+serverName+\":\"+portNumber+\";databaseName=\"+databaseName+\";selectMethod=\"+selectMethod+\";\";\n }\n\n private java.sql.Connection getConnection() {\n try {\n Class.forName(\"com.microsoft.sqlserver.jdbc.SQLServerDriver\");\n con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);\n if(con!=null) System.out.println(\"Connection Successful!\");\n } catch(Exception e) {\n e.printStackTrace();\n System.out.println(\"Error Trace in getConnection() : \" + e.getMessage());\n }\n return con;\n }\n\n \/*\n Display the driver properties, database details\n *\/\n\n public void displayDbProperties() {\n System.out.println(\"Perform Operations \");\n\n }\n\n private void closeConnection() {\n try{\n if(con!=null)\n con.close();\n con=null;\n }catch(Exception e){\n e.printStackTrace();\n }\n }\n public static void main(String[] args) throws Exception {\n Connect myDbTest = new Connect();\n \/\/ myDbTest.displayDbProperties();\n }\n}\n<\/code><\/pre>\nBut I am getting following exceptions:<\/p>\n
\ncom.microsoft.sqlserver.jdbc.SQLServerException: The TCP\/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect\n at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)\nError Trace in getConnection() : The TCP\/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect\nError: No active Connection\n<\/pre>\nI am not getting where is the problem in the above code or do i need to do some setting to connect to remote server.<\/p>\n
Please give me your valuable suggestion which can help me to overcome with this problem.<\/p>\n
\n- \n
IMHO “Connection refused” means your database server is not visible from your application server.<\/p>\n
\n- Check IP address and port.<\/li>\n
- Check database connectivity directly from your database server (to avoid firewalls).<\/li>\n
- Check database connectivity from your application server.<\/li>\n<\/ul>\n
Hope this will help you<\/p>\n<\/li>\n
- \n
Make sure that your SQL Server is configured to use TCP\/IP. Enable it from SQL Server’s Network Utility app. Also check there that the SQL Server is using port 1433 (IP Addresses – IPAll – TCP Port).<\/p>\n
Try to use “telnet 1433”. If it doesn’t connect you will not be able to establish a connection.<\/p>\n<\/li>\n
- \n
ALLOW THE CONNECTION FIRST IN WHICH PC YOUR SQL SERVER IS RUNNING… GO TO CONTROL PANEL–>ADMIN. TOOLS—>Windows Firewall with Advanced Security–>Inbounded rules–>new rule–>select port radio button –>next–>enter port 3306–>click next –>finally give the rule name like conn any…click finish<\/p>\n<\/li>\n<\/ol>\n
Originally posted 2013-12-02 20:57:23. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
I am writing a java code to connect with MS SQL Server 2005. MS SQL Server is on Remote server windows server 2003. I am trying the following code but i am unable to establish a connection: import java.*; public class Connect { private java.sql.Connection con = null; private final String url = “jdbc:sqlserver:\/\/”; private […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1840","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1840"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1840\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}