Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Does version 12x support using active directory to log a user in ? I have looked into integrated passwords, but the issue is passwords are changed every 30 days. Seems pretty inefficent to have to change the users password to match the new ad password everytime. Perhaps I am miss reading this, any thoughts or ideas would be appreciated. Currently we are on version 10.x, I have both 11.x and 12.x in house looking to upgrade. Running 32bit version on a 64bit Windows machine.

asked 24 Aug '11, 14:26

trexco's gravatar image

accept rate: 0%

No, SA does not support LDAP user authentication, but it is on our list of "enhancements to consider for a future release".

However, you do not need to change the user's password in SA to match the AD password. The SA user account needs to have a password, but it does not need to match the one used by integrated login.

permanent link

answered 24 Aug '11, 15:22

Graeme%20Perrow's gravatar image

Graeme Perrow
accept rate: 54%

Thanks Graeme, the error I was making was not putting in a password for the user in the database. Once I deleted the user and recreated them with a password that was different than the AD password and created the login mapping I was able to connect using the integrated option.

(24 Aug '11, 15:35) trexco

Depending on your requirements, the integrated logins may work for you:

This allows the Windows username/password to be used to authenticate to an account on the database server. You can also setup a "guest" account for authentication of users who do not have an account mapping on the database server.

The username and password are authenticated against the server you specify. The only caveat is that you don't actually have to type the username/password to login to the database; only the current user logged in on the system is authenticated (and this means the user may also be required to login to the necessary domain rather than a local account to their machine).

permanent link

answered 24 Aug '11, 15:01

Tyson%20Lewis's gravatar image

Tyson Lewis
accept rate: 22%

perhaps I am not understanding the documentation correctly. I have created a new 11 database. I have set the login to integrated and standard. I have set the domain controler for the database. The user has been created in the database with the same id as the user logged onto the domain. The only way I can get the connection to automatically connect is to make sure that the user in the database is set up with the same password as in the domain. If this is the case than every 30 days when my users are required to change their domain password, the password in the database would also have to change to keep them in sync.

Is this correct or am I just missing some part of the picture here ?

(24 Aug '11, 15:27) trexco
Replies hidden

You should be able to connect without making the passwords match. Perhaps you could test doing the "Guest" account only to see if the integrated login works. The guest account itself is used if an integrated login does not exist, it allows it to default to "Guest"; considering this, many users will have different passwords so the one stored in the database need not match.

Apart from that, are you still supplying username/password in the connection string and/or are you using the INTEGRATED=YES option?

(24 Aug '11, 15:37) Tyson Lewis

Thanks Tyson, You are correct I was finally able to make the connection with non matching passwords. Thanks for the help.

(24 Aug '11, 15:44) trexco
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 24 Aug '11, 14:26

question was seen: 2,699 times

last updated: 24 Aug '11, 15:44