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

MyEclipse Forum Index » Frequently Asked Questions » FAQ - Databases

Author

Message

support-rkalla

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

Posted: Aug 28, 2006 - 06:58 PM

Moderator

Joined: Jan 06, 2004
Posts: 23307

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.