MS Azure DB hosting

Senna

I have a small c# project that I'll be developing using a few different pc's, so for handiness I thought I would host the related dB on MS Azure.
Got my azure account set up, dB set up and am trying to get my SQL server manager to connect to Azure, but I keep getting connection error.
I have my PC added to Azure firewall.
I have the port needed opened in my firewall and also on my router. But still getting connection error.
Anyone come across this problem. It looked so easy at the beginning, but it just never works out that way:)

Aswerty

Providing the error message could prove useful!

Basic setup...

The server name should be in the format <<server name>>.database.windows.net and be sure you're using the Server Admin Login with the correct password using SQL Server Authentication. On the Azure firewall make sure your current client IP address (which they display to you) is the one setup in a rule - typically you have the same IP address as the start and end IP. If you're on a home connection you IP address can change depending on how frequently you ISP rotates your dynamic IP so make sure that it hasn't automatically changed on you.

Buford T Justice

As above, make sure you've authorised your IP address in azure so you can connect.

jmcc

As above. Also check if your server was started with --skip-networking.

Regards...jmcc

Senna

Thanks for everyones help. I was spending too long at it, so i just set up the dB on my own machine and once I have enough progress that I can take a bit of a break, I'll come back to Azure and try to fix that issue.