Unable to write data to value stream

I have TWX 8.5 with MS SQL server as persistent (model and data) provider. Created a VS with MSSQL persistentprovider. Created a thing with 2 integer properties with logged option, data change type as Always.

I tried to add property values, but the message in log is seen as below:

######################################################

2019-11-02 17:24:48.658+0530 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: pool-3-thread-1] Unable to write entry in stream [VS] from source [TestVSThing] at 2019-11-02T17:24:20.236+05:30 [com.thingworx.common.exceptions.DataAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.]

#########################################################

Please let me know if I missed any configuration for VS with MS SQL as persistent provider