[dba-SQLServer] Help on Incorrect syntax near '‘'.

J- P jnatola at hotmail.com
Thu Jul 10 18:22:44 CDT 2014


So i'm trying to reset the BES password and this error keeps showing



Msg 102, Level 15, State 1, Line 13



Incorrect syntax near ''.



Msg 102, Level 15, State 1, Line 14



Incorrect syntax near ''.



Msg 102, Level 15, State 1, Line 15



Incorrect syntax near ''.



Msg 102, Level 15, State 1, Line 21



Incorrect syntax near ''.



Msg 102, Level 15, State 1, Line 23



Incorrect syntax near ''.



Msg 102, Level 15, State 1, Line 24



Incorrect syntax near ''.







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 = ’2951a982f568f15567b7c6e0e50990b9′ – 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

 EXEC SetUpBASorADAuthentication @DisplayName, @AuthenticatorTypeId, @AuthenticatorInstanceId, @ExternalAuthenticatorId, @EncryptedPassword

END
GO 


 Jean-Paul Natola 		 	   		  



More information about the dba-SQLServer mailing list