SQL Server – URL for DBEdit2

sql server

There is a cool program out there called DBEdit2, which can be used for SQL Server. Here is where you can get it free:

http://dbedit2.sourceforge.net/

The problem is that I can't make it work! It gives me the following error (conf info crossed out):

enter image description here

This is what I put in the login details:

enter image description here

And this is what I get if I click details:

enter image description here

Any ideas at all? Can anyone else make this program work?

I've made sure that I have my SQL Server set to allow both SQL Server and Windows authentication mode.

I've ensured that the server is running and that I have browser running.

I don't know.

Best Answer

As @a_horse_with_no_name points out, your connection string is incorrect. The java jdbc driver needs to know the instance name ( it doesn't play well with the backslash notation ), which will be overridden if you're specifying the port ( 1433 is the default instance port - you might not have to specify the instance name at all if that's what you're trying to connect to ).

Try something along the lines of this instead for your connection string:

jdbc:jtds:sqlserver://JT__428/j___test_db;instance=J__MS14

Related Question