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 ServerLoginMode method returns the default login mode for the specified server.
ServerLoginMode returns one of these SQLDMO_SECURITY_TYPE values.
Allow Windows Authentication only
Allow Windows Authentication or SQL Server Authentication
Allow SQL Server Authentication only
Security type unknown
The ServerLoginMode method allows an application to determine the login mode of a server without logging in. Login information is stored in the registry, and is accessible remotely if Windows Registry Key Permissions is set to Enumerate Subkeys.
By calling ServerLoginMode, and application may be able to reduce the amount of time necessary to determine the login mode of a server. This can be useful in a situation where the application must overcome time-out issues.