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

Home Forums MyEclipse IDE FAQ – Development [DB] Can I use Windows Auth wth the DB Explorer?

This topic contains 0 replies, has 1 voice, and was last updated by Profile photo of support-tony support-tony 1 year, 4 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #347672
    Profile photo of support-tony
    support-tony
    Keymaster

    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:

    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.

Viewing 1 post (of 1 total)

The topic ‘[DB] Can I use Windows Auth wth the DB Explorer?’ is closed to new replies.