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.
2016-10-20, 797👍, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...