How do I connect to SQL Server as a backend for Ionic mobile apps?
Typically one would create an HTTP API (most likely using REST) that would serve as the interface to the database. This API would be developed in a server side technology of choice: node, ASP.NET, php, etc. The API would connect and communicate with SQL Server by executing T-SQL queries or stored procedures.
Your API would be called by your angular application using the $http service provided by angular.
Additional reference materials: