I have an SQLA 16.0.1324 database running on a Linux server.

Users connect via an application installed on their Windows desktops and those desktops are part of a Windows Domain.

I tried setting up Integrated Logins and specified the following option to specifically identify the domain controller:

SET OPTION PUBLIC.integrated_server_name = '\\DCServer';

When attempting an integrated login I get an error message -130 regarding UserID '' (seems to think the UserID was passed as an empty string).

Checking the ConnectFailed event parameters though, it shows the correct username in appdata as OSUSER=SigerMatt.

Is it possible to use Integrated Login against a Windows Active Directory if the database server is running on Linux?

Any help or advice would be appreciated.

asked 10 Aug '16, 17:06

Siger%20Matt's gravatar image

Siger Matt
3.3k5672101
accept rate: 15%

edited 10 Aug '16, 17:13


Windows Integrated Logins is a feature of the Windows OS and requires both the clients and the server to be running on a Microsoft Windows OS. Having the OSUSER alone is not sufficient to make the verification work; some Windows OS-specific functions need to be available to the server.

That is the reason your Linux database server is expecting a UID and a PWD will be supplied.

There are other authentication mechanisms that may be of interest. Those include LDAP and KERBEROS but both are different from Windows Integrated Logins and may not be available in your environment or may not be what you are looking for. Version 17 also introduces support for the Unix/Linux-only PAMUA if that is of any interest.

permanent link

answered 10 Aug '16, 18:08

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 32%

Thanks for the help Nick!

(12 Aug '16, 18:42) Siger Matt
Your answer
toggle preview

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

Question tags:

×260
×68
×8

question asked: 10 Aug '16, 17:06

question was seen: 1,999 times

last updated: 12 Aug '16, 18:42