secure default login

Summary information

Default value

0

Range of values

0 (followed by another parameter naming the default login)

Status

Dynamic

Display level

Intermediate

Required role

System Security Officer

secure default login specifies a default login for all users who are preauthenticated but who do not have a login in master..syslogins.

Establish the secure default login with:

sp_configure "secure default login", 0,
    default_login_name

where:

For example, to specify “dlogin” as the secure default login, type:

sp_configure "secure default login", 0, dlogin