Shawn de Wet's questions

I have configured a VNet in Azure with default 10.0.0.0/16 ip range.

I configured my Azure SQL Database to allow connections from the VNet.

I now want to connect my local dev pc to the VNet, so I added a Gateway to the VNet, with the default subnet 10.0.1.0/24, and then configured a Point-to-Site connection on the gateway with address pool 10.2.0.0/16.

(The above settings may be very wrong(?) - I don't know a LOT about networking, so just went with defaults where available, so am open to guidelines about how to do the above better)

I downloaded the VPN Client settings, and configured my Azure VPN Client, which connects to the Gateway and gets an IP address of 10.2.0.2.

I then tried to connect to the Azure SQL Database (using Microsoft SQL Server Mngt Studio) , and I get the popup that says my IP Address is not allowed to connect. However, the IP Address that it is showing is my Router's static IP address with which my router is connected to the internet.

How do I get this connection in SSMS to connect using the 10.2.0.2 address that my Azure VPN client is connected with?

I had to replace an NIC on my HP Proliant Microserver, running FreeNAS 9.3

In my crashplan jail, I now get "netstat: no namelist" as a response when I execute the netstat command. How to I diagnose this? Could it be that the virtual NIC epair for the jail is still bound to the old NIC?

In SQL Activity Monitor, I see a constant 35% to 40% CPU usage in the Processor Time scrolling graph. How can I tell what Processes within SQL are responsible for that CPU usage?

Using SQL Management Studio 2012, when I right-click on an existing Maintenance Plan, and select the "Maintenance Plan Wizard" option from the context menu, what launches is a wizard to create a new maintenance plan.

I need to open the wizard to edit the selected Maintenance Plan. Please advise as to why this is happening?

Interestingly, when I select the "New Maintenance Plan" option from the context menu, then no wizard pops up at all.