Hosting DB for Azure Iaas applications in Azure SQL(Paas)

We have Azure Iaas. In that we have web, app and DB servers(Virtual Machine) deployed in a VNet.

Can we have Azure SQL DB as PaaS to host DataBase for some of the applications hosted on Azure IaaS VM?

Its like can we have application hosted on Azure IaaS and its database hosted on Azure SQL PaaS?

September 8th, 2015 4:47am

To answer very shortly, YES it is very much possible. The only thing that would change is connection string. So today you might be using the connectionstring for SQL on IaaS as

"Server=<CloudServiceName>.cloudapp.net,<yourPublicPort>;Integrated Security=false;Database=<yourDBName>;User ID=<login_name>;Password=<your_password>"

That would change to  -

Server=tcp:<yourPaaSServerName>.database.windows.net,1433;Database=<YourDBName>;User ID=<YouruserName>@<yourPaaSservername>;Password=<YourPassword>;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;

Free Windows Admin Tool Kit Click here and download it now
September 8th, 2015 5:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics