Collections:
Verifying a Login Name with SQLCMD Tool in SQL Server
How To Verify a Login name with SQLCMD Tool in SQL Server?
✍: FYIcenter.com
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 following command:
C:\>SQLCMD -S LOCALHOST\SQLEXPRESS -U FYI_DBA -P ABD_IYF 1> PRINT Suser_Sname(); 2> GO FYI_DBA 1> QUIT C:\>
This shows FYI_DBA is a valid login and the password is correct. Now try this command:
C:\>SQLCMD -S LOCALHOST\SQLEXPRESS -U FYI_DEV -P ABD_IYF Msg 18456, Level 14, State 1, Server LOCALHOST\SQLEXPRESS, Line 1 Login failed for user 'FYI_DEV'. C:\>
This shows FYI_DEV is not a valid login or the password is incorrect.
⇒ sys.server_principals - Listing All Login Names in SQL Server
⇐ "CREATE LOGIN" - Creating a New Login Name in SQL Server
2016-10-20, 1641🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...