When you create a new database SQL Azure, you can enter client IP addresses in the Azure Portal, allowing you to connect from SQL Server Management Studio (or the Azure db web client) on any computer.

But this appears to work on some machines, but not on others. How do you get this to work from all authorized client machines?

When you whitelist an IP address in SQL Server, you may not have entered the "correct" IP address that Azure is seeing you connect from. Using tools such as "ipconfig" or a web-based "what is my ip?" tool may give you different results.

To identify the client IP address that Azure is seeing, simply attempt to connect using SQL Server Management Studio, and keep an eye on the detailed connection error message that pops up. The error message should mention the IP address that it detects.

Now, enter that IP address in the whitelist of authorized machines, in the SQL Azure database's configuration screen in the Azure Portal.

• Edited by Shahed ChowdhuriMicrosoft employee 5 hours 27 minutes ago
• Marked as answer by Shahed ChowdhuriMicrosoft employee 5 hours 27 minutes ago

When you whitelist an IP address in SQL Server, you may not have entered the "correct" IP address that Azure is seeing you connect from. Using tools such as "ipconfig" or a web-based "what is my ip?" tool may give you different results.

To identify the client IP address that Azure is seeing, simply attempt to connect using SQL Server Management Studio, and keep an eye on the detailed connection error message that pops up. The error message should mention the IP address that it detects.

Now, enter that IP address in the whitelist of authorized machines, in the SQL Azure database's configuration screen in the Azure Portal.

• Edited by Shahed ChowdhuriMicrosoft employee 5 hours 18 minutes ago
• Marked as answer by Shahed ChowdhuriMicrosoft employee 5 hours 18 minutes ago

When you whitelist an IP address in SQL Server, you may not have entered the "correct" IP address that Azure is seeing you connect from. Using tools such as "ipconfig" or a web-based "what is my ip?" tool may give you different results.

To identify the client IP address that Azure is seeing, simply attempt to connect using SQL Server Management Studio, and keep an eye on the detailed connection error message that pops up. The error message should mention the IP address that it detects.

Now, enter that IP address in the whitelist of authorized machines, in the SQL Azure database's configuration screen in the Azure Portal.

NOTE: The whitelist config screen in SQL Azure can be used to detect your client IP. The above suggestion is applicable to situations where you've tried auto-detecting it via the config screen, but SQL Server Management Studio is still rejecting the IP.

• Marked as answer by Shahed ChowdhuriMicrosoft employee Saturday, August 22, 2015 1:49 AM
• Edited by Shahed ChowdhuriMicrosoft employee 16 hours 28 minutes ago

When you whitelist an IP address in SQL Server, you may not have entered the "correct" IP address that Azure is seeing you connect from. Using tools such as "ipconfig" or a web-based "what is my ip?" tool may give you different results.

To identify the client IP address that Azure is seeing, simply attempt to connect using SQL Server Management Studio, and keep an eye on the detailed connection error message that pops up. The error message should mention the IP address that it detects.

Now, enter that IP address in the whitelist of authorized machines, in the SQL Azure database's configuration screen in the Azure Portal.

NOTE: The whitelist config screen in SQL Azure can be used to detect your client IP. The above suggestion is applicable to situations where you've tried auto-detecting it via the config screen, but SQL Server Management Studio is still rejecting the IP.

• Marked as answer by Shahed ChowdhuriMicrosoft employee Saturday, August 22, 2015 1:49 AM
• Edited by Shahed ChowdhuriMicrosoft employee 16 hours 37 minutes ago

When you whitelist an IP address in SQL Server, you may not have entered the "correct" IP address that Azure is seeing you connect from. Using tools such as "ipconfig" or a web-based "what is my ip?" tool may give you different results.

To identify the client IP address that Azure is seeing, simply attempt to connect using SQL Server Management Studio, and keep an eye on the detailed connection error message that pops up. The error message should mention the IP address that it detects.

Now, enter that IP address in the whitelist of authorized machines, in the SQL Azure database's configuration screen in the Azure Portal.

NOTE: The whitelist config screen in SQL Azure can be used to detect your client IP. The above suggestion is applicable to situations where you've tried auto-detecting it via the config screen, but SQL Server Management Studio is still rejecting the IP.

• Marked as answer by Shahed ChowdhuriMicrosoft employee Saturday, August 22, 2015 1:49 AM
• Edited by Shahed ChowdhuriMicrosoft employee Saturday, August 22, 2015 2:40 PM

When you whitelist an IP address in SQL Server, you may not have entered the "correct" IP address that Azure is seeing you connect from. Using tools such as "ipconfig" or a web-based "what is my ip?" tool may give you different results.

To identify the client IP address that Azure is seeing, simply attempt to connect using SQL Server Management Studio, and keep an eye on the detailed connection error message that pops up. The error message should mention the IP address that it detects.

Now, enter that IP address in the whitelist of authorized machines, in the SQL Azure database's configuration screen in the Azure Portal.

NOTE: The whitelist config screen in SQL Azure can be used to detect your client IP. The above suggestion is applicable to situations where you've tried auto-detecting it via the config screen, but SQL Server Management Studio is still rejecting the IP.

• Marked as answer by Shahed ChowdhuriMicrosoft employee Saturday, August 22, 2015 1:49 AM
• Edited by Shahed ChowdhuriMicrosoft employee Saturday, August 22, 2015 2:40 PM