(New to IDEA, sorry if I'm missing something obvious.)
So far I'm unable to configure a data source successfully in IDEA 902/903.
Test Connection succeeds, and if I don't include a table name in the connection string, I get the list of all tables from master. However, providing the correct database name I get "java.sql.SQLException: Database 'mydbname' does not exist." I've tried the latest microsoft and jtds drivers, same behavior. This is SQL Server 2008.
Not sure if it's related, but with no db name I can get the master tables from the Data Source Properties dlg, but when I click OK and refresh the tables from the Data Sources pane, I get "Incorrect driver and/or connection setting specified", with the same settings that worked in the dlg.
Also possibly related, the db name has hyphens in it. Doubt it, but do those need to be escaped somehow in the connection string?
Specs I'm using for jtds are:
JDBC Driver Class: net.sourceforge.jtds.jdbc.Driver
Database URL: jdbc:jtds:sqlserver://localhost:1433
Or with a database name:
Database URL: jdbc:jtds:sqlserver://localhost:1433/mydbname
Any ideas? Is anyone having success connecting to SQL 2008?