I have SQL Server 2008 R2 Express installed on Azure VM Role (1 extra small instance)
Because of hosting very old banking system, which is not able to connect to SQL Azure. Data persistency is reached via Azure Storage Page Blob. I have written a Windows Service, which can mount VHD file and also can attach MDF database file to SQL Server.
My problem is that I need to SQL query from Azure Web Role to SQL Server hosted on Azure VM Role.
I tried nearly everything:
I have opened TCP 1433, UDP 1434, added SQL Browser to Windows Firewall.
I have enabled remote connection, SQL Server Browser, TCP/IP, Named Pipes on SQL Server.
I have changed TCP/IP port to 1433 and I have disabled dynamic port.
I have already read:
If you were so kind and wanted to help me, I would send you all the screenshot from my settings.
Are the VM role and the web role in the same azure service project or not? Different suggestion will be provided depending on this.
Basically, if you expose the SQL Service service via input endpoint, you may try connnecting to it using Microsoft SQL Server Management Studio from your machine. The server name is the same as the DNS name of your azure service project. And the definition
of the endpoint element will be:
If you expose it via internal endpoint, you may need to enable remote desktop for the web role and install Microsft SQL Server Management in a service instance to have a check. Since the IP addresses for internal conmmunication are dynamic, we need to use
the following code to get the IP address of the VM role.