SQL Server logins
E937643
SQL Server logins are security principals that represent individual users or applications allowed to connect to a SQL Server instance and access its databases.
All labels observed (1)
| Label | Occurrences |
|---|---|
| SQL Server logins canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T11656367 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: SQL Server logins Context triple: [SQL Server Authentication, authenticates, SQL Server logins]
-
A.
SQL Server Authentication
SQL Server Authentication is a SQL Server login method that uses credentials stored and validated by the database engine itself rather than relying on Windows accounts.
-
B.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
C.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
-
D.
MSIServer
MSIServer is the Windows service that manages installation, modification, and removal of software using the Windows Installer technology.
-
E.
SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: SQL Server logins Target entity description: SQL Server logins are security principals that represent individual users or applications allowed to connect to a SQL Server instance and access its databases.
-
A.
SQL Server Authentication
SQL Server Authentication is a SQL Server login method that uses credentials stored and validated by the database engine itself rather than relying on Windows accounts.
-
B.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
C.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
-
D.
MSIServer
MSIServer is the Windows service that manages installation, modification, and removal of software using the Windows Installer technology.
-
E.
SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
- F. None of above. chosen
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server security principal
ⓘ
authentication credential ⓘ |
| allows | connection to SQL Server instance ⓘ |
| alteredWith | ALTER LOGIN statement ⓘ |
| authenticatedBy | SQL Server Database Engine NERFINISHED ⓘ |
| canBe |
SQL Server Agent proxy owner
ⓘ
credential owner ⓘ disabled ⓘ enabled ⓘ endpoint owner ⓘ |
| canBelongTo | server role ⓘ |
| canBeMemberOf |
bulkadmin fixed server role
ⓘ
dbcreator fixed server role ⓘ diskadmin fixed server role ⓘ processadmin fixed server role ⓘ securityadmin fixed server role ⓘ serveradmin fixed server role ⓘ setupadmin fixed server role ⓘ sysadmin fixed server role ⓘ |
| canUse | contained database authentication (via contained users, not login) ⓘ |
| controls | access to SQL Server databases ⓘ |
| createdWith | CREATE LOGIN statement ⓘ |
| droppedWith | DROP LOGIN statement ⓘ |
| grants | server-level access ⓘ |
| hasMetadataIn | sys.sql_logins catalog view NERFINISHED ⓘ |
| hasProperty |
check expiration
ⓘ
check policy ⓘ default database ⓘ default language ⓘ enforce password expiration ⓘ enforce password policy ⓘ is disabled flag ⓘ must change password at next login ⓘ name ⓘ password (for SQL logins) ⓘ password policy settings ⓘ |
| hasType |
Azure Active Directory authentication login
ⓘ
SQL authentication login ⓘ Windows authentication login ⓘ |
| identifiedBy | SID ⓘ |
| isRequiredFor | non-contained database access ⓘ |
| listedIn | sys.server_principals catalog view ⓘ |
| mappedTo | database user ⓘ |
| represents |
application
ⓘ
user ⓘ |
| storedIn | master database ⓘ |
| supports |
login auditing
ⓘ
password complexity enforcement ⓘ password hashing ⓘ |
| usedIn | Microsoft SQL Server NERFINISHED ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: SQL Server logins Description of subject: SQL Server logins are security principals that represent individual users or applications allowed to connect to a SQL Server instance and access its databases.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.