Login:
[sa]
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 |
Roles with this login
| Role |
| sysadmin |
SQL
CREATE LOGIN [sa] WITH PASSWORD = 'p@ssw0rd', SID = 0x01, DEFAULT_DATABASE = [master], DEFAULT_LANGUAGE = [us_english], CHECK_EXPIRATION = OFF, CHECK_POLICY = ON GO |
See also