Can't get JDBC to connect to SQL Server Express

[burkejay]

I successfully got rid of the “not a trusted connection”
and “connection refused” error messages by configuring
a port number. The configuration didn’t match how I read to
do it, so I am concerned, but doing it this way got rid of
those two error messages.

Now, it tells me “login failed”. I login with that
username and password daily, so I don’t think
I have that wrong. It must be some other
configuration issue.

I am attaching the relevant screen captures.

Please help.

file://c:\config.jpg

config.JPG

exception.JPG

tcp.JPG

[burkejay]

More screen captures

dbs.JPG

remote connections.JPG

login.JPG

[Rain]

Dear burkejay,

Thanks for your message. By default the connection string in database configuration dialog is for SQL Server Authentication. For Window Authentication, can you try using the following connection string?

jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true;

Please let me know it helps or not. Thanks in advance!

Best regards,
Rain

[burkejay]

I just logged in using the sa account and that worked!

Thanks for the tip!

[Rain]

Dear burkejay,

You are welcome.

Best regards,
Rain