SqlSetLSecure%

Sets the secure connection flag in a SQL Server login record.

Syntax

SqlSetLSecure% ( loginrec% )

where

loginrec%

A login record, which is passed as a parameter to SqlOpen%. The value of loginrec% is returned by SqlLogin%.

Returns

succeed (1) or fail (0).

Remarks

By setting the secure connection flag in a login record with SqlSetLSecure%, the application requests a secure or trusted connection to SQL Server. This means that SQL Server will use integrated login security to establish connections made (using SqlOpen%) with this login record, regardless of the current login security mode at the server. Any login ID or password supplied by SqlSetLUser% or SqlSetLPwd% is ignored.

To use SqlSetLSecure% and trusted connections, you must first use xp_grantlogin or SQL Security Manager to grant SQL Server system administrator or user privilege to the appropriate Windows NT - based groups or users. Use xp_revokelogin or SQL Security Manager to revoke SQL Server privileges and stop a user or group from using a trusted connection.

Note that SqlSetLSecure% enables trusted connections even when the server is in standard login security mode.

See Also

SqlLogin%, SqlOpen%, SqlSetLApp%, SqlSetLHost%, SqlSetLUser%