USE [master]; GO CREATE LOGIN username WITH PASSWORD = N'password', CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF; GO EXEC sp_addsrvrolemember @loginame = N'username', @rolename = N'sysadmin';