Ive got a VPS running a web application where its performance is being slowed incredibly by the SQL Server that is installed alongside it. I want to use Azure SQL Server to host the database there and the Application on the VPS that is external to Azure.
Ive published the Database and its data to Azure nicely from the VPS, added the IP address of the VPS on the allowed connection list in the firewall, however when I go to use the connectionstring, I get the usual no permissions or Database does not exist..
Im relatively new to Azure services (Used visual studio to connect and configured virtual machines etc..)so what more do I need to do in order to allow this External VPS to connect and access the SQL Server on Azure?