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