SQL Server logins

E937643

SQL Server security principal authentication credential

SQL Server logins are security principals that represent individual users or applications allowed to connect to a SQL Server instance and access its databases.

Try in SPARQL Jump to: Surface forms Disambiguation Statements Elicitation Referenced by

All labels observed (3)

Label	Occurrences
SQL Server logins canonical	1
SQL Server security model	1
sys.sql_logins catalog view	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 ⓘ linked to: SQL Server
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 ⓘ linked to: SQL Server logins
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 ⓘ linked to: SQL Server

How these facts were elicited

Referenced by (3)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server Authentication → authenticates → SQL Server logins ⓘ

SQL Server Data Quality Services databases → securedBy → SQL Server security model ⓘ

linked to: SQL Server logins

SQL Server login → hasMetadataIn → sys.sql_logins catalog view ⓘ

subject linked to: SQL Server logins