DBaaS concept for SQL Server
Yes, of course it's possible. Microsoft's done it in their datacentres, you can do it in yours. It may take some time and effort however. :-)

There is not yet an Azure on-prem product. I've read rumours of one due in the next year or so. Either way, it will take a while to be fully functional and licensing not going to be cheap.

Best bet would be to roll out the DevOps toolkit. Infrastructure as code; desired state configuration; pre-speced VM images produced from a pick list; automated on-demand app deployment. All the bits are around and open source. Linking them will take a few dedicated months. Getting management approval, and educating users to take responsibility for their usage may take longer.



In July 2017 Microsoft announced Azure Stack, which makes their cloud management software available for on-premises deployment. Included in this is SQL databases.