Gaston
AZURE SQL SERVER DB IP ACCESS
Hello, i run into this issue, everytime i deploy my railway backend I get this error
originalError: ConnectionError: Cannot open server 'gastondev' requested by the login. Client with IP address '34.145.12.49' is not allowed to access the server. To enable access, use the 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.
It's pretty clear, so I set up a rule on my azure portal with that IP, the problem is everytime I deploy the ip changes and I have to set up a new rule each time, the only way I get to know the IP is to fail, read the error and then set up the rule.
Is there any way to know de IP beforehand or some way to just avoid this error at all ?
5 replies