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 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 security and access control, see Security and Protection (Database Engine).