You can run your application on an SQL Server, both locally and elsewhere, by going to the Project Settings and adding or changing a configuration and setting the database type on SQL Server. Just fill in the location and username/password of the server you have running.
As far as I know in version 3 the model database can only be the HSQL. In 2.5 this was also MSSQL or postgresql.