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, 1548🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...