SQLEXPRESS in Windows7

[rogel]

Hi!

I installed SQLEXPRESS on Windows7 and trying to connect from Developer.
URL: jdbc:jtds:sqlserver://localhost/tsmseven;instance=SQLEXPRESS
Driver: net.sourceforge.jtds.jdbc.Driver

I get this error message:

Code: Select all

"Server localhost has no instance named SQLEXPRESS"

But when I open SQL Management Studio Express and query the servicename

Code: Select all

select SQL@@servicename

I get SQLEXPRESS

Thanks in advance.

[AlanBourke]

You might have to specify the port or something. I use this format which works:

Code: Select all

jdbc:jtds:sqlserver://mycomputer:61775/mydatabase;instanceName=SQLEXPRESS