Which three actions should you perform?

You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template.
You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual
machine. The web app and the virtual machine will be on the same Azure virtual network.
You need to ensure that the web app can access the SQL Server database.
Which three actions should you perform? Each correct answer presents part of the solution.

You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template.
You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual
machine. The web app and the virtual machine will be on the same Azure virtual network.
You need to ensure that the web app can access the SQL Server database.
Which three actions should you perform? Each correct answer presents part of the solution.

A.
Change the SQL Server authentication to mixed mode.

B.
Use sp_configure to enable remote access.

C.
From the Azure portal, add an endpoint for TCP port 1434.

D.
Onthe virtual machine, enable the inbound connections on TCP port 1433 from Windows Firewall.

E.
Restart the SQL Server service.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

jml

jml

I think it is ADE.

Remote access in enabled by default and changing it does not require server restart.

https://msdn.microsoft.com/pl-pl/library/ms191464(v=sql.110).aspx

The remote access option controls the execution of stored procedures from local or remote servers on which instances of SQL Server are running. This default value for this option is 1.

Reply