Cannot connect to sqlserver 2008 with JDBC

[alexander.s]

All I want to do here is to connect to the database.

So I've disabled my firewall, with the help of the sql server configuration manager I've enabled "VIA" and under tcp/ip->ip-addresses->IPAll. I've set tcp dynamic ports to 0 and the port to 1433. Those were the recommendations that I found from googling.

my MySQL connection worked straight away, this microsoft stuff is really a pain :(

Overlook:
The SQLserver2008 is located on my local machine
No firewall activated
Enabled VIA and the sqlserver should be listening on 1433
EDIT:
I'm using Netbeans 6.8 and I've added jtds-1.2.5 and sqljdbc4 to the project.
I've tried using both drivers with no luck.
EDIT nr2:
I forgot to mention that my sql server login account "sa" is activated and works fine, I can log with the sql server management studio with both the windows authentication and the sql server option.

EDIT nr3:
Apparently the server isn't listening on port 1433, that was the port number when I googled for sql server 2008. But mine listens on a high port number, I changed my java code and it works..for anyone else trying to make this work, open Microsoft SQL Server Mangement Studio click on Managment -> Sql Server Logs -> Current. Look around for a while and you'll find the line "Server is listening on <servername><port number>"

package javaapplication3;
import java.sql.*;

public class Main
{
    public static void main(String[] args)
    {
        DB db = new DB();
        db.dbConnect("jdbc:sqlserver://localhost\\servername/Databases/databasename:1433","sa","password");
    }
}

class DB
{
    public DB() {}

    public void dbConnect(String db_connect_string,
  String db_userid, String db_password)
    {
        try
        {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection conn = DriverManager.getConnection(
    db_connect_string, db_userid, db_password);
            System.out.println("connected");

        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
};

SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException:  The TCP/IP connection to the host localhost, port 1433 has failed. 
Error: "connect timed out. 
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

The code block above is the translation of the first part of the code block below.

[SIZE="2"]com.microsoft.sqlserver.jdbc.SQLServerException: TCP/IP-anslutningen till värddatorn localhost, port 1433 misslyckades. Fel: "Connection refused: connect. Kontrollera anslutningsegenskaperna, att en instans av SQL Server körs på värddatorn som accepterar TCP/IP-anslutningar på porten och att ingen brandvägg blockerar TCP-anslutningar till porten.".
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1049)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
        at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at javaapplication3.DB.dbConnect(Main.java:23)
        at javaapplication3.Main.main(Main.java:9)[/SIZE]

[Webuser]

Hold on )

To connect to MS SQL with Java you need to download some special connectors. MS SQL cannot be connected with MySQL connectors.
Please visit microsoft.com to download the latest MS SQL Server 2008 Java connectors (drivers).
I recommend this links
MS SQL 2005 JDBC Driver

And please read its tutorials because it is much differ thing as for MySQL

[ideyatech]

Import the driver file.

[aska]

hello programmers !
i'm new in this website,so it's my first topic

i have problem with ueing jdbc in my project
i know this steps but after that do know!

Download the newest driver from Microsoft: http://www.microsoft.com/downloads/d...7000d-68d0-453...
Unpack/unzip the downloaded file. For me, expanding the archive resulted in a folder called sqljdbc_3.0
Inside the expanded folder is another, called enu (or whatever language was selected with the download from step 1), which contains, among other items, a file called sqljdbc4.jar
Copy or move sqljdbc4.jar to your Railo 'install' folder (I use Railo on Tomcat and, for me, this is at /Developer/tomcat/railo) ... it'll be the folder that contains a railo.jar file :)
please some one tell me what must i do to use the driver?

[Fubarable]

Please don't hijack another's thread. I invite you to start your own thread on this and ask your question there. Locking this re-animated zombie thread.