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, 1815🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...