What exactly do I need to have on the Windows server to use integrated login? |
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:
And then the Windows user 'mywindowsuser' can login to the database by specifying INTEGRATED=YES (or INT=YES) in the connection string. E.g.
If the computer belongs to a Windows domain, then one more step must be performed:
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. |
Use the 'Login Mappings' feature to map a Windows user account to a database user account. |