Can I use web2py with mssql?

Yes. web2py works with:

• sqlite3 (it comes with it)
• postgresql (recommended choice for serious projects)
• mysql
• mssql
• oracle
• firebird
• db2
• Informix
• Ingres