IntegratedSecurity Object

  • Article

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The IntegratedSecurity object exposes configurable parameters that affect all logins to Microsoft SQL Server regardless of the login authentication type.

SQL-DMO object model that shows the current object

Properties

AuditLevel Property

ImpersonateClient Property

DefaultDomain Property

SecurityMode Property (DistributionDatabase, IntegratedSecurity)

DefaultLogin Property

SetHostName Property

Methods

Refresh Method

 

Remarks

SQL Server implements two ways to control access to SQL Server data: Windows Authentication, implementing trusted connections, and SQL Server Authentication.

Properties of the IntegratedSecurity object that provide default domain naming are maintained for compatibility with previous versions of SQL Server and SQL Distributed Management Objects (SQL-DMO).

For more information about SQL Server 7.0 security and access control, see Securing Notification Services.