Problem in connecting to database

[Neeba Rebbaca]

i tried to connect database (sql server 2000) through servlet.But its giving me "[Microsoft][sqlserver jdbc driver] error establishing socket"

I have given correct Port number(1433) and server name...

Please help me solving this issue...


Even its not launching within the server...

 

String user = "sa";
            String pass = "sa";
            String cUrl = "jdbc:microsoft:sqlserver://testserver:1433;DatabaseName=scdm";
            theConnection = DriverManager.getConnection(cUrl, user, pass);
            Statement theStatement = theConnection.createStatement();
            ResultSet theResult;
            for(theResult = theStatement.executeQuery("select * from blocks_tmp"); theResult.next(); out.println("</tr>"))
            {
                out.println();
                out.println("<tr>");
                out.println((new StringBuilder()).append("<td>").append(theResult.getString(8)).append("</td>").toString());
                out.println((new StringBuilder()).append("<td>").append(theResult.getString(9)).append("</td>").toString());
                String s = theResult.getString(10);
                out.println((new StringBuilder()).append("<td><a >").append(s).append("</a></td>").toString());
            }

            theResult.close();
            theStatement.close();
            theConnection.close();

[Paul Sturrock]

Is your server configured to accept TCP/IP traffic? Is your server configured to allow SQL Server authentication? Is there any sort of firewall between your application and the server? Is the server running?

[Neeba Rebbaca]

My server is not in n/w.yes i allow sql authentication.

What you mean by firewall between application and server???

[Neeba Rebbaca]

Please help me with some solution....

[Paul Sturrock]

My server is not in n/w

I don't understand what "n/w" means.

yes i allow sql authentication.

OK, so is your server configured to accept TCP/IP traffic?

What you mean by firewall between application and server???

Just that - are these any firewalls between whatever machine your application runs on and whatever machine your SQL Server instance lives on.

Also, is your SQL Server 2000 instance patched to the latest version? Very (very!) early versions of SQL Server 2000 had issues with TCP/IP DLLs missbehaving.

[Neeba Rebbaca]

1. I have checked, both Server network utility and client network untility for TCP/IP port(its 1433).
2. I have turned off the wirefall.
3. Allowed exception for Port 1433(giving Name as "1433" , Port number as "1433" )
4. Now my server is not in Network , so i tried to launch the application from inside the server itself.


How to check whether it accepTCP/IP traffic?

[Neeba Rebbaca]

Any help please....

[Jan Cumps]

Neeba Rebbaca wrote:1...
4. Now my server is not in Network , so i tried to launch the application from inside the server itself.

In that case, try to replace 'testserver' by '127.0.0.1'.

[Neeba Rebbaca]

Yes, i tried... but still the same problem exists...