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
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