Verifying a Login Name with SQLCMD Tool in SQL Server

Q

How To Verify a Login name with SQLCMD Tool in SQL Server?

✍: FYIcenter.com

A

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.

 

Managing Security, Login and User in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-20, 378👍, 0💬