What exactly do I need to have on the Windows server to use integrated login?

asked 28 Aug '10, 16:59

Integrated%20Login's gravatar image

Integrated L...
106344
accept rate: 0%


There is nothing special that you need to do on the Windows server in order to use Integrated Login provided that the user has logged in to Windows as a local user.

The basic idea is that you:

  • enable integrated login in the database by setting the public login_mode option. E.g.

    SET OPTION PUBLIC.login_mode = 'Standard,Integrated';

  • create a mapping from a database user (or group) to a Windows user (or group). E.g.

    GRANT INTEGRATED LOGIN TO mywindowsuser AS USER mydatabaseuser;

And then the Windows user 'mywindowsuser' can login to the database by specifying INTEGRATED=YES (or INT=YES) in the connection string. E.g.

dbping -d -c servername=myserver;dbn=mydb;integrated=yes;...other-parameters...

If the computer belongs to a Windows domain, then one more step must be performed:

  • If the Windows computer and logged in user belongs to a Windows domain, then you must also set the integrated_server_name public option in the database:

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

You can read about Integrated Login in the 12.0.0 docs. If you are using a previous version, the 12.0.0 docs should still apply since nothing has changed w.r.t. Integrated Login in many years/versions.

permanent link

answered 28 Aug '10, 17:57

Mark%20Culp's gravatar image

Mark Culp
22.9k9129269
accept rate: 40%

Use the 'Login Mappings' feature to map a Windows user account to a database user account.

permanent link

answered 28 Aug '10, 17:46

Calvin%20Allen's gravatar image

Calvin Allen
1.5k232638
accept rate: 25%

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:

×13
×2

question asked: 28 Aug '10, 16:59

question was seen: 1,601 times

last updated: 28 Aug '10, 17:57