Login:
[l_certSignSmDetach]
Login properties
| Name | Value |
| Name | [l_certSignSmDetach] |
| Friendly name | English |
| Language | us_english |
| System | |
| Default database | master |
| Deny Windows Security Authenticated Connections | |
| Type | Certificate-based SQL Server Logins |
| Permissions to access the server | Explicit grant |
| Enabled | ![]() |
Roles with this login
| Role |
| sysadmin |
SQL
CREATE LOGIN [l_certSignSmDetach] FROM CERTIFICATE [_##PDW_SmDetachSigningCertificate##] GO |
See also