Connecting Java with SQL express

Question

I've designed a database management system using Java and MySQL. I used WAMP as the server. Everything was perfect with that..until now.. Now, I have to go for SQL Express instead of WAMP. I know nothing about SQL Express. I've installed it under defaults. However, now I can connect to the database in Microsoft SQL Server Management Studio with following selections, (`LORDXAX-PC` is my computer's name) But I need to connect the database with my Java program. (I've used JDBC successfully before, with WAMP) Need help to make this a success?? I've tried searching found certain things, but it gives errors. Can someone provide me with clean instructions.. Any help is appreciated. Thanks! EDIT (2) This is a complete code demonstrating the issue.. ``` package ExpressTest; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; public class MAIN { public static void main(String[] args) { new MAIN().start(); } private void start() { System.out.println("START"); St…

Accepted Answer

Though many answers are available. I would like to give one.

As you are using Window Authentication.

Change JTDS URL from

```
private String URL = "jdbc:jtds:sqlserver://localhost/brandix;instance=sqlexpress";
```

TO

```
private String URL = "jdbc:jtds:sqlserver://localhost/brandix;instance=sqlexpress;useNTLMv2=tru‌​e;domain=workgroup";
```

OR Another alternative is:

Download the [Microsoft JDBC driver][1]rather than JTDS. Add `sqljdbc4.jar` to your classpath.

Update your connection string (JDBC URL) for you server

Use `Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);`

URL : `jdbc:sqlserver://localhost;user=root;password=‌​123;"`

If still problem, persist. Check with,

Enable TCP/IP network protocol, which is disable by default, and set the TCP/IP port to 1433 which is again default port no.

Open the SQL Server Configuration Manager Start -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager

Then at the left hand tree. Select SQL Server 2005 Network Configuration-> Protocol for SQLEXPRESS-> TCP/IP.

Right click and enable it.

A window box appear on double click the TCP/IP. Click on the "IP Addresses" Tab

Set the TCP Port value to 1433 then click apply

Restart SQL Service.

Connecting Java with SQL express

Solution

Problem