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 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.
2016-10-20, 1221👍, 0💬
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...