Getting an error message "Cannot specify a column width on data type text" when trying to create a table in SQL server.

Text data type or nText data type does not support a "width" property, you can't specify column length. If you're creating the table via Kiwi, I believe that you can edit the SQL used to create the table and change the column definition.

Can you share, how this can be achieved?

When configuring Kiwi for SQL, the "Database type/field format" defaults to "MS Access".

Click the dropdown, select "Kiwi SQL format" and you should be good to go.