MyEclipse Forums
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
support-tony
Post subject: [DB] Can I use Windows Auth wth the DB Explorer?  PostPosted: Mar 03, 2014 - 09:38 AM



Joined: Mar 09, 2011
Posts: 915

If you are connecting to a Microsoft SQL Server database and want to use Windows authentication, follow these steps:

1) Download the Microsoft JDBC Driver

2) Install it and place sqljdbc_auth.dll into the jre/bin folder under the MyEclipse JDK , which is in the binary directory of the MyEclipse installation directory.

3) Configure the Microsoft SQL Server Driver in MyEclipse using the downloaded sqljdbc.jar (or sqljdbc4.jar) in a new connection from the Database Explorer view.

4) Set the driver profile connection URL to be of the following format:
Code:

jdbc:sqlserver://servername\instance:1433;integratedSecurity=true


Where you replace "servername" with the proper name of your server and "instance" with the proper instance name of a running server.
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits