DECLARE @DATA NVARCHAR(4000);

SET @DATA = N'{

{"message":"Hi Shiv, To get access please find the credentials with given query"}

}';

SELECT JSON_QUERY(@DATA) AS 'Result';