Share via

ServerLoginMode Method

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The ServerLoginMode method returns the default login mode for the specified server.

구문

object
.ServerLoginMode(
ServerName 
)
as
SQLDMO_SECURITY_TYPE

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • ServerName
    String that specifies the server name.

Prototype (C/C++)

HRESULT ServerLoginMode(
SQLDMO_LPCSTR ServerName, 
SQLDMO_SECURITY_TYPE *pRetVal);

Returns

ServerLoginMode returns one of these SQLDMO_SECURITY_TYPE values.

Constant Value Description

SQLDMOSecurity_Integrated

1

Allow Windows Authentication only

SQLDMOSecurity_Mixed

2

Allow Windows Authentication or SQL Server Authentication

SQLDMOSecurity_Normal

0

Allow SQL Server Authentication only

SQLDMOSecurity_Unknown

9

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.

[!참고] ServerLoginMode can be used with SQL Server 7.0, and Microsoft SQL Server 2000 or later.

Applies To:

SQLServer2 Object