SQL Server Authentication
E277020
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.
All labels observed (1)
| Label | Occurrences |
|---|---|
| SQL Server Authentication canonical | 2 |
How this entity was disambiguated
This entity first appeared as the object of triple T2556239 — 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 Authentication Context triple: [SQL Server Management Studio, supportsAuthentication, SQL Server Authentication]
-
A.
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.
-
B.
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.
-
C.
Azure SQL Database
Azure SQL Database is Microsoft’s fully managed, cloud-based relational database service built on SQL Server technology for scalable, secure data storage and processing.
-
D.
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed, cloud-based deployment option in Microsoft Azure that provides near 100% compatibility with on-premises SQL Server while offering automated management, scaling, and high availability.
-
E.
SQL Server Data Tools
SQL Server Data Tools is an integrated development environment within Visual Studio for designing, developing, debugging, and deploying SQL Server and Azure SQL databases and related business intelligence solutions.
- 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 Authentication Target entity description: 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.
-
A.
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.
-
B.
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.
-
C.
Azure SQL Database
Azure SQL Database is Microsoft’s fully managed, cloud-based relational database service built on SQL Server technology for scalable, secure data storage and processing.
-
D.
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed, cloud-based deployment option in Microsoft Azure that provides near 100% compatibility with on-premises SQL Server while offering automated management, scaling, and high availability.
-
E.
SQL Server Data Tools
SQL Server Data Tools is an integrated development environment within Visual Studio for designing, developing, debugging, and deploying SQL Server and Azure SQL databases and related business intelligence solutions.
- F. None of above. chosen
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server login method
ⓘ
database authentication mechanism ⓘ |
| authenticates | SQL Server logins ⓘ |
| canBeAuditedBy |
SQL Server Audit
ⓘ
login auditing ⓘ |
| canBeCreatedBy | CREATE LOGIN statement ⓘ |
| canBeEnabledIn | SQL Server instance properties ⓘ |
| canBeManagedBy | ALTER LOGIN statement ⓘ |
| canBeRestrictedBy |
database roles
ⓘ
server roles ⓘ |
| canBeUsedOver |
encrypted connections
ⓘ
unencrypted connections ⓘ |
| canBeUsedWith | contained database users with passwords ⓘ |
| configuredVia |
SQL Server Management Studio
ⓘ
sp_configure ⓘ |
| consideredLessSecureThan |
Windows Authentication
ⓘ
linked to:
Active Directory
|
| contrastedWith |
Integrated Security
ⓘ
Windows Authentication ⓘ
linked to:
Active Directory
|
| credentialScope | SQL Server instance level ⓘ |
| defaultState | disabled on new secure installations (Windows-only mode) ⓘ |
| doesNotRequire | Windows account ⓘ |
| loginInformationStoredIn |
sys.server_principals
ⓘ
sys.sql_logins ⓘ |
| notRecommendedFor | environments where Windows Authentication is possible ⓘ |
| passwordHashingAlgorithm |
SHA-1 (older versions)
ⓘ
SHA-512 (newer versions) ⓘ |
| recommendedFor | legacy applications that require SQL logins ⓘ |
| requires | enabling SQL Server and Windows Authentication mode ⓘ |
| securityRisk |
password exposure over network if not encrypted
ⓘ
password reuse across applications ⓘ |
| storesCredentialsIn |
SQL Server system catalog
ⓘ
linked to:
SQL Server
|
| storesPasswordAs | hash ⓘ |
| subjectTo |
SQL Server password policy enforcement options
ⓘ
password policy settings at the Windows level when enforced ⓘ |
| supports |
application connection strings with user id and password
ⓘ
mixed mode authentication ⓘ |
| supportsEncryptionWith | TLS ⓘ |
| supportsFeature |
account lockout
ⓘ
password complexity requirements ⓘ password expiration ⓘ password policies ⓘ |
| usedBy |
Microsoft SQL Server
ⓘ
linked to:
SQL Server
|
| usedFor |
applications that cannot use Windows Authentication
ⓘ
cross-platform applications ⓘ non-domain clients ⓘ |
| usedIn | connection strings with Integrated Security set to false ⓘ |
| uses |
login name
ⓘ
password ⓘ |
| validatedBy |
SQL Server Database Engine
ⓘ
linked to:
SQL Server
|
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 Authentication Description of subject: 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.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.