The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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...
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
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
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



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: 28 Aug '10, 16:59

question was seen: 1,524 times

last updated: 28 Aug '10, 17:57