RSA Scripts

Generate logins and password

Generate logins and password. Executing the result of the script will generate all logins.

  1. Sql Server
  2. Login
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

USE master
GO
SET NOCOUNT ON
SELECT 'EXEC sp_addlogin @loginame = ''' + loginname + ''''+', @defdb = ''' + dbname + ''''+
       ', @deflanguage = ''' + language + ''''+', @encryptopt = ''skip_encryption'''+
       ', @passwd =', CAST(password AS varbinary(256)),
       ', @sid =', CAST(sid as varbinary(256)) 
  FROM syslogins
 WHERE name NOT IN ('sa')
   AND isntname = 0 
   AND password IS NOT NULL
 ORDER BY loginname  
 
 
SELECT 'EXEC sp_grantlogin @loginame = [' + loginname + ']'+
       ' EXEC sp_defaultdb @loginame = [' + loginname + ']'+', @defdb = [' + dbname + ']'
  FROM syslogins
 WHERE loginname NOT IN ('BUILTIN\Administrators','NT AUTHORITY\SYSTEM')
   AND isntname = 1
 ORDER BY loginname