MyEclipse :: View topic - [DB] Can I use Windows Auth wth the DB Explorer?

MyEclipse: [DB] Can I use Windows Auth wth the DB Explorer?

support-rkalla - Aug 28, 2006 - 06:58 PM
Post subject: [DB] Can I use Windows Auth wth the DB Explorer?

Submitted by Ted Devoe
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) Uncompress it and place sqljdbc_auth.dll into the Eclipse installation directory (e.g. C:\Program Files\Eclipse-3.2)

3) Configure the Microsoft SQL Server 2005 Driver in MyEclipse using the downloaded sqljdbc.jar (Driver is located at Window > Preferences > MyEclipse > Database Explorer > Drivers, then click "New..." and select the "Microsoft SQL Server 2005 Driver" template)

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

Code:

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

Where you replace "servername" with the proper name of your server.