SQL Server SSIS/VM with Azure SQL
Im running SQL Server 2012 (with SSIS) on an Azure vm. Is there any reason why I can't use Azure SQL as my source and destination
April 20th, 2015 1:23pm

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

Free Windows Admin Tool Kit Click here and download it now
April 20th, 2015 8:32pm

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

April 21st, 2015 12:29am

Hi, 

In order to use SSIS to connect to the Azure SQL database, you will need to add the SQL virtual machine's IP address to the list of Allowed IP Addresses of your Azure SQL database server (instructions are posted here).

It will probably be the easiest to run through these steps by accessing the Azure Portal through your VM. The Azure Portal is able to automatically populate the "Current Client IP Address". 

Please see this blog for more information. 

Hope this helps! 

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 12:29am

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

Other recent topics Other recent topics