Forum OpenACS Q&A: Re: Re: ANN: acs-kernel port to MS-SQL Server

yes, that's possible.
Plus you'll need to provide /sql/mssql/ package create files as well.