Windows Server/Framework7/node.js/Microsoft SQL

I’ve been tasked with building a web app to access a clients existing data on a Microsoft sql server.

The webserver is a windows 2016 server. Looks like you can install node.js on a windows server? This would be the first node.js site I’ve built. So just having some questions prior to setup. Am I able to setup node.js on windows server and still be able to attach to the Microsoft SQL data? There are probably cloud services for node.js setup that would be easier, but owner will want data to stay in house.

I wanted to try framework7 on a web based app? Is that advisable? Or should I stick with bootstrap?

Thanks for any guidance…
Baub