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

This topic contains 0 replies, has 1 voice, and was last updated by  support-tony 5 years, 2 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #347672 Reply

    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)
Reply To: [DB] Can I use Windows Auth wth the DB Explorer?

This topic is marked as closed to new replies, however your posting capabilities still allow you to do so.

You must be logged in to post in the forum log in