SQL Server - sys.server_principals - Listing All Login Names in SQL Server

sys.server_principals - Listing All Login Names in SQL Server

Q

How To List All Login Names on the Server in SQL Server?

✍: FYIcenter.com

A

If you want to see a list of all login names defined on the server, you can use the system view, sys.server_principals as shown in this tutorial exercise:

-- Login with sa

SELECT name, sid, type, type_desc FROM sys.server_principals
   WHERE type = 'S';
GO
name      sid                                 type type_desc
--------  ----------------------------------- ---- ---------
sa        0x01                                S    SQL_LOGIN
FYI_DBA   0x348AF32B3B58CB40B67A5F5B7086B96E  S    SQL_LOGIN
Fyi_Login 0x5EB8701EAEBAA74F86FCF5BD8E37B8C5  S    SQL_LOGIN

So you have two login names on the server at this moment.

⇒Managing Security, Login and User in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-20, 1702👍, 0💬

Verifying a Login Name with SQLCMD Tool in SQL Server
How To Verify a Login name with SQLCMD Tool in SQL Server? The quickest way to verify a login name on a SQL Server is probably to use the SQLCMD tool, which takes the server name, login name and password in a single command line. Here is how to try it yourself: Start a command window and enter the f... 2016-10-20, 553👍, 0💬

"ALTER LOGIN" - Changing the Password of a Login Name in SQL Server
How To Change the Password of a Login Name in SQL Server? If a developer lost the password of his or her login name, you can reset the password with the "ALTER LOGIN" statement as shown in this tutorial example: -- Login with sa ALTER LOGIN FYI_DBA WITH PASSWORD = 'fyicenter'; GO Command(s) complete... 2016-10-20, 528👍, 0💬

"CREATE LOGIN" - Creating a New Login Name in SQL Server
How To Create a New Login Name in SQL Server in SQL Server? In previous tutorials, it is assumed that you use the "sa" (System Administrator) login name to connect to your SQL Server. But that is not what a normal developer uses to connect to the server, since "sa" has the ALL permissions granted. Y... 2016-10-20, 491👍, 0💬

"ALTER LOGIN" - Changing a Login Name in SQL Server
How To Change a Login Name in SQL Server? If you want to change a login name, you can use the "ALTER LOGIN" statement as shown in this tutorial example: -- Login with "sa" -- Change login name ALTER LOGIN Fyi_Login WITH NAME = Dba_Login; GO -- View login names SELECT name, sid, type, type_desc FROM ... 2016-10-19, 480👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.