Login: [sa]

CollapseAll image

Collapse image Login properties


 Name   Value 
 Name   [sa] 
 Friendly name   English 
 Language   us_english 
 System 
 Default database   master 
 Deny Windows Security Authenticated Connections   
 Type   SQL Server standard login 
 Permissions to access the server  Explicit grant 
 Enabled  

Collapse image Roles with this login


Role
sysadmin

Collapse image SQL


CREATE LOGIN [sa] WITH
    PASSWORD = 'p@ssw0rd',
    SID = 0x01,
    DEFAULT_DATABASE = [master],
    DEFAULT_LANGUAGE = [us_english],
    CHECK_EXPIRATION = OFF,
    CHECK_POLICY = ON
GO

Collapse image See also


Logins