Change Server Configuration From SQL Server Authetication to Windows Authentication

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

authentication

asked 02.07.2014 at 10:27

ralfraeber
(suspended)
accept rate: 0%

One Answer:

active answers oldest newest most voted

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:

Download the full JTDS driver package: download site
Extract the downloaded ZIP
Navigate into the extracted system folder that matches your ivyServer environment. (e.g. x64 or x32)
Copy the ntlmauth.dll from the SSO folder (within the system folder). Into the ivyServers /jre/bin folder.
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)
Ensure that the USER NAME and PASSWORD field is empty.
Press the connect button, enjoy :-)!

This solution is inspired by a stack overflow question..

link

answered 02.07.2014 at 14:43

Reguel Werme... ♦♦
9.4k●3●19●58
accept rate: 70%

edited 02.07.2014 at 14:56

That was very helpful! THX

(02.07.2014 at 17:03) ralfraeber

Worked - thx

(06.08.2014 at 21:15) abr__

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

learn more about Markdown

Tags:

authentication ×16

Asked: 02.07.2014 at 10:27

Seen: 2,929 times

Last updated: 07.08.2014 at 08:38

Change Server Configuration From SQL Server Authetication to Windows Authentication

Follow this question

Related questions