No experience with MSSQL but for PostgreSQL it works by selecting the datatype serial and the index PrimaryKey. See screenshot.
I suspect the datatype should be identity with index PrimaryKey. See also this documentation.
Big StackExchange fan but you will have better chances getting a good answer on the Safe Software forum. Lots of knowledge and activity.