Visual Paradigm Logo
     Build Quality Applications Faster, Better and Cheaper
 
Home | Products | Download | Documentation | Support | Resources | Partners | Quick Tour | Shop | Company |  
 
   Visual Paradigm Discussion Forum
  Login   [ Register ] Email: Password: Log me on automatically I lost my password  
Advanced Search
Can't get JDBC to connect to SQL Server Express  
Forum Index -> Visual Paradigm for UML (VP-UML)
Author Message
burkejay


Joined: 2007/12/10
Messages: 3

Offline

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.

Attached Image : Description : config screen (63 kb)

Attached Image : Description : exception message (79 kb)

Attached Image : Description : port number config (41 kb)

 
burkejay


Joined: 2007/12/10
Messages: 3

Offline

More screen captures

Attached Image : Description : List of databases (69 kb)

Attached Image : Description : Remote is on (63 kb)

Attached Image : Description : lgin to SQL Server (34 kb)

 
Rain


Joined: 2005/04/29
Messages: 758

Offline

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


Joined: 2007/12/10
Messages: 3

Offline

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

Thanks for the tip!
 
Rain


Joined: 2005/04/29
Messages: 758

Offline

Dear burkejay,

You are welcome.

Best regards,
Rain
 
 
   Forum Index -> Visual Paradigm for UML (VP-UML)
Go to:   
Powered by JForum 2.1.4 © 2005 - Rafael Steil