Pega (7.2.2) doesn't support Date type column in MS SQL. Because of this, you can't use SQL connector wizard to integrate with a table in MS SQL if it contains Date type column(s). Like DB2 and Oracle, this type should support for MS SQL too.
Current workaround is to create class, properties and Data-Admin-DB-Table instance manually.
***Updated by moderator: Lochan to add product enhancement details***
Thank you for submitting this enhancement. An enhancement request has been created on our internal portal. The request ID is attached to your post above (under Related Support Case Number field.) I will send you an email on details with accessing this on our internal portal.
For non-Pega employees who wish to seek the status of this enhancement - please contact your Pega account executive.