Saturday, November 4, 2017

Creating a SQL server Login in SSMS

Through SSMS object explorer: Expand security node-> Right click->New Login. Type user name in the Login name-> Click OK.
Through powershell: SQLCMD -S Computername
Through Query for windows authentication
USE DATABASE;
GO
CREATE LOGIN
[DOMAINNAME\USERNAME]
FROM WINDOWS;
GO
Through Query for sql server authentication
USE DATABASE;
GO
CREATE LOGIN
[DOMAINNAME\USERNAME]
WITH PASSWORD= N'PASSWORD';
GO
Through Query for sql server authentication and user changing password on next login
USE DATABASE;
GO
CREATE LOGIN
[DOMAINNAME\USERNAME]
WITH PASSWORD= N'PASSWORD'
MUST_CHANGE,
CHECK POLICY=ON,
CHECK EXPIRATION=ON;
GO

No comments:

Post a Comment

GEN AI

  Stay Tuned....