You would have to create a new driver module to do this (say CGI::Session::MSSQL) you could start with a copy of CGI:Session::MySQL and alter it appropriately to work with an ODBC connection to SQL Server, this would entail altering the connection string as well as the SQL - in particular the application locking that MySQL provides and that will have to implemented for MS SQL Server.

/J\