secure default login

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

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

Configuration group

Security Related

Establish the secure default login with:
sp_configure "secure default login", 0, default_login_name
where: