14 lines
287 B
SQL
14 lines
287 B
SQL
--
|
|
select principal_id,[sid],name
|
|
from sys.server_principals;
|
|
|
|
--
|
|
CREATE LOGIN <login_name>
|
|
WITH PASSWORD = '<use_a_strong_password_here>',
|
|
SID = <SID>;
|
|
|
|
--
|
|
ALTER USER <user_name> WITH Login = <login_name>;
|
|
|
|
--
|
|
ALTER LOGIN <login_name> WITH PASSWORD = '<enterStrongPasswordHere>'; |