Peter Dzuya

Peter Dzuya

  • NA
  • 313
  • 41.1k

Deploying a new Project database to My Azure Portal Account

Jul 12 2016 2:34 AM
Hi all. I am trying to deploy a new project to my azure portal account. I am getting an exception as follows:-
 
 
"Additional information: Cannot open server 'abcdefgh' requested by the login. Client with IP address 'xxx.xxx.xxx.xxx' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect."
 
I am new to Azure. How do I Solve this matter.
 
Thanks 

Answers (2)

0
Ravi Patel

Ravi Patel

  • 271
  • 6.8k
  • 1.4m
Jul 12 2016 4:35 AM
Hi ,
please refer this
https://blogs.msdn.microsoft.com/azuresqldbsupport/2015/04/29/configuring-the-firewall-for-client-access/
Accepted Answer
0
Peter Dzuya

Peter Dzuya

  • 0
  • 313
  • 41.1k
Jul 13 2016 11:07 AM
Thanks Ravi Patel. The Link helped me. I sorted the issue and now I am connected.
Peter Chiringa