/*+---------------------------------------------------------------------------
  *  Instructions for running script:
 * 1.  Backup database
 * 2.  Edit items under the editing section. (By default none required)
 *  3.  Run the script on the BES configuration database
 *+--------------------------------------------------------------------------*/

DECLARE 
        @DisplayName              VARCHAR(256),
        @Authentication           VARCHAR(256),
        @AuthenticatorTypeId      INT,
        @AuthenticatorInstanceId  INT,
        @ExternalAuthenticatorId  VARCHAR(255),
        @EncryptedPassword        VARCHAR(256)
 
/************************************************************
Start of editing required section
*************************************************************/

 
SET @DisplayName =               'System Administrator'                  -- Display name (Not always used)
SET @Authentication =            'BAS'                                   -- 'BAS' for BAS authentication
SET @EncryptedPassword =        '7B7ECF0DAF70D040345D8DD92607E274969F4BA5DFDFAEAC5DE775E5340CDF605D5762EC5D326498ADBE72E7434897025A8702D0237046F554DBCA5769B90154:7637B189'      -- Encrypted string of password 'blackberry'
 
 
/************************************************************
End of editing required section
*************************************************************/

 
IF @Authentication LIKE 'BAS'
BEGIN
        SET @AuthenticatorTypeId =      0                               -- Set to 0 for BAS
        SET @AuthenticatorInstanceId =   0                               -- Set to 0 for BAS
        SET @ExternalAuthenticatorId = NULL
 
      IF NOT EXISTS (SELECT * FROM BASUsers WHERE LoginName = 'admin')
             EXEC SetUpBASorADAuthentication @DisplayName, @AuthenticatorTypeId, @AuthenticatorInstanceId, @ExternalAuthenticatorId, @EncryptedPassword
        ELSE 
          UPDATE    BASUsers 
          SET       LoginPassword = @EncryptedPassword
          WHERE     (LoginName = 'admin')
 
END
GO