Integrated Login

[Former Member]

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

[MarkCulp]

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.

[Former Member]

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