java swing gui application with sql server 2005 as backend using windows authentication

Question

i get this error when i execute my java application in netbeans 7.0 ide, any help regarding this will be appreciated.

SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host PRANAVVENKAT-PC, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

try {
             Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
       String connectionUrl = "jdbc:sqlserver://PRANAVVENKAT-PC\\SQLEXPRESS;"+"databaseName=CallCenter";
        Connection con = DriverManager.getConnection(connectionUrl);

        PreparedStatement stat = con.prepareStatement("insert into customer (name,password)values(?,?)");
     String name=jTextField1.getText();
     String password=jPasswordField1.getText();
      stat.setString(1, name);      
      stat.setString(2, password);
      stat.executeUpdate();

     } catch (SQLException e) {
      System.out.println("SQL Exception: "+ e.toString());
    } catch (ClassNotFoundException cE) {
       System.out.println("Class Not Found Exception: "+ cE.toString());
    }

jzd · Accepted Answer · 2011-06-07 17:29:44Z

0

Looks like your database is not running or something is blocking your path to it. Open up SQL Server Management Studio and verify the database is running and that you can connect to it from your machine.

Also, double check that your connection string is correct.

answered Jun 7, 2011 at 17:29

jzd

23.6k9 gold badges58 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GAMITG · Accepted Answer · 2016-01-27 13:17:04Z

0

Just go to SQL server configuration manager and and then click "protocols for MSSQL server" enable all the options which are disabled. now next go to the control panel and open "local service" this will show all the services local SQL server and double click it then it will show its status if it is shows "running" then good other wise click "restart", next go back to your sql server restart the server and then connect your server.

edited Jan 27, 2016 at 13:17

GAMITG

3,8187 gold badges35 silver badges51 bronze badges

answered Jan 27, 2016 at 13:12

user5846935

1

Collectives™ on Stack Overflow

java swing gui application with sql server 2005 as backend using windows authentication

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related