Sybase user authentication

Greetings experts,

I am running Sybase 12.5 applications, including a PB front end and several processes.  I am trying to authenticate each app using Windows authentication based on users in Active Directory.  I know that this is done in MS SQL.  Does anyone have any insight?

Thanks!
markv105Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe WoodhousePrincipal ConsultantCommented:
Is ASE also running on Windows?

If so, you can setup integrated security. It's documented in the ASE 12.5.x Configuration Guide for Windows.

If not, you're out of luck, sorry.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
grant300Commented:
You must be running ASE 12.5.2 or higher to use Active Directory but it can be done.

http://www.sybase.com/content/1026313/SYSD1039LDAP_WP.pdf

The above link points to a PDF that gives you pretty good information on how to set it up.

Best of luck,
Bill
0
Joe WoodhousePrincipal ConsultantCommented:
Bill,

We don't need Active Directory. Windows integrated security has been around for years, since ASE 11.5 at least. Windows LAN Manager, Directory Services and Active Directory are not required.

Windows logins and passwords can be used if ASE (on Windows) is setup for either "integrated" or "mixed" security modes.

Beware - by default most roles and permissions are assigned to default Windows groups, which is usually not what is wanted!
0
grant300Commented:
Yes, integrated security is a real easy route.

Markv105 asked specifically about Active Directory so I assumed his server was on a non-Windows platform.

He as both cases covered now :)

Bill
0
Joe WoodhousePrincipal ConsultantCommented:
8-) True!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.