every time login message

[zezo2021]

why does this message appear every time or every day when opening SQL server management studio

 

[Minty]

Because your public facing IP address keeps changing. Azure uses IP address whitelisting as a security measure.
It expects most corporate users to be on a fixed IP address. I pay for a fixed IP at home as I do a lot of Azure work so it would be a pain to constantly have to update it.

It's a very handy additional way of keeping unauthorised users out, if you implement it, and I wouldn't advise removing it.

 

[zezo2021]

Because your public facing IP address keeps changing. Azure uses IP address whitelisting as a security measure.
It expects most corporate users to be on a fixed IP address. I pay for a fixed IP at home as I do a lot of Azure work so it would be a pain to constantly have to update it.

It's a very handy additional way of keeping unauthorised users out, if you implement it, and I wouldn't advise removing it.

Thank for your efforts and time

 

[zezo2021]

Does the message appear if link access to the SQL server (Tables)

 

[Minty]

Yes.

Whatever the source is if the IP isn't on the list, you're not coming in.

 

[zezo2021]

Yes.

Whatever the source is if the IP isn't on the list, you're not coming in.

 

[zezo2021]

Should I buy IP Static from the Azure Portal
Or
Internet Service Provider

 

[Minty]

Up to you - Static at home is useful but also has some downsides for anonymity.

 

[GPGeorge]

Should I buy IP Static from the Azure Portal
Or
Internet Service Provider

I don't think you can get a static IP from Azure. I think it has to be your ISP. The ISP provides the IP in the first place. Azure only accepts or rejects it based on what rule you have set in the Firewall.

 

[zezo2021]

I don't think you can get a static IP from Azure. I think it has to be your ISP. The ISP provides the IP in the first place. Azure only accepts or rejects it based on what rule you have set in the Firewall.