Error configuring a new datasource to SQLserver 2008 R2 with a named instance in Jasperserver

[jm_3]

Trying to configure a new datasource to SQLserver 2008 R2  with a named instance.

The URL is

jdbc:sqlserver://SQL01PROVSQL01:1433;databaseName=Navision

I've tried also

jdbc:sqlserver://SQL01:1433;instance=PROVSQL01;databaseName=Navision

I've got the message  "URL invalid"

Josep M

 

[bplummer]

Have you tried this:

jdbc:sqlserver://SQL01PROVSQL01;databaseName=Navision

When you use a named instance, don't include the port.  You will have to make your changes in the URL textbox, and let the Host and Port textboxes fill themselves in.

Just came across this old post, but hope it helps!