Hello How can I change the login method in the Server Configuration from SQL Server Authentication to a Windows Server Account? I tried in User Name Domain\user, user@Domain.wan and Domain.wan\user. Every Method was without success. Thank's for your help Ralf

alt text

asked 02.07.2014 at 10:27

ralfraeber's gravatar image

ralfraeber
(suspended)
accept rate: 0%


Yes it is possible to use windows authentication to connect to the Ms SQL server. But you need to copy the correspondent native library into the ivyServers JVM.

To activate windows authentication proceed as follows:

  1. Download the full JTDS driver package: download site
  2. Extract the downloaded ZIP
  3. Navigate into the extracted system folder that matches your ivyServer environment. (e.g. x64 or x32)
  4. Copy the ntlmauth.dll from the SSO folder (within the system folder). Into the ivyServers /jre/bin folder.
  5. Now start XpertIvyServerConfigC.exe with a windows profile that is allowed to connect to the server. (Maybe use the RUNAS command to run in another profile)
  6. Ensure that the USER NAME and PASSWORD field is empty.
  7. Press the connect button, enjoy :-)!DB connected by SSO

This solution is inspired by a stack overflow question..

link

answered 02.07.2014 at 14:43

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
9.4k31958
accept rate: 70%

edited 02.07.2014 at 14:56

That was very helpful! THX

(02.07.2014 at 17:03) ralfraeber ralfraeber's gravatar image

Worked - thx

(06.08.2014 at 21:15) abr__ abr__'s gravatar image

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×16

Asked: 02.07.2014 at 10:27

Seen: 2,929 times

Last updated: 07.08.2014 at 08:38