Web Scraping, Serializing and Deserializing in Python
PEP8 names
All of these variables:
def __init__(self, Date, DocumentType, Procedure, NoOfPages):
    self.Date = Date
    self.DocumentType = DocumentType
    self.Procedure = Procedure
    self.NoOfPages = NoOfPages

should be lower_snake_case.
Data classes
Replace JsonClass with a @dataclass that uses an implicit __init__.
Connection
First note that there's no point in separating out your connection parameters like
'Driver={SQL Server};' 'Server=xyz-PAVILION;'

since they will be implicitly concatenated to
'Driver={SQL Server};Server=xyz-PAVILION;'

Beyond that, the documentation states that kwargs are converted to a formatted conn string, so you're better off writing
pyodbc.connect(
    Driver='{SQL Server}',
    Server='xyz-PAVILION',
    Database='jsondata',
    Trusted_Connect='yes',
)

Context management
Use a with on your connection and cursor objects; read
https://github.com/mkleehammer/pyodbc/wiki/Connection#context-manager
Exception interference
Don't convert exceptions to booleans, as in
except pyodbc.Error as error:
    print('Error : %s' % error)
    return False
except:
    print('Operation Failed')
    return False
conn.close()
return True

Deal with the exceptions, potentially wrapping them in your own exception types, and catching them at an upper level.
Double serialization
Don't do this:
with open('html_to_json.json', 'w') as file_out:
    json.dump(dict_list, file_out, indent=4)  # Serializing dict_list and writing in  .json file
return json.dumps(dict_list)

Hold onto the result of dumps and write that string to the file.
Print helpers
Move this code:
    print('Date : ' + i.Date)
    print('DocumentType : ' + i.DocumentType)
    print('Procedure : ' + i.Procedure)
    print('NoOfPages : ' + i.NoOfPages)

to a method of JsonClass.
Hard-coded paths
my_file = open(&quot;C:/Users/xyz/Downloads/sample.htm&quot;, 'r')

should not be hard-coded. Set it as some kind of parameter - a command-line argument maybe.
Dict literals
    record = dict()
    date_obj = datetime.datetime.strptime(column[1], '%d.%m.%Y')
    record['Date'] = date_obj.date().isoformat()
    record['DocumentType'] = column[2]
    record['Procedure'] = column[3].replace('\u00a0/\u00a0', '/').replace('\u00a0', '/')
    record['NoOfPages'] = column[4]

should not call dict(), should not individually index keys, and should instead use a dict {} literal.