0

I am using PHP to connect to my SQL Server which is hosted on a database in Azure. I have a form which gathers the data being entered from users into the database. My problem is that the data entry is inconsistent.

Scenario 1: On the PC where all development was made, the data entry is always working, no matter how many entries I make. I can see all the entries I made on the backend.

Scenario 2: On my friend's PC, data entry was ok initially, however after a couple of tests, it seems that his PC was blocked from entering more entries.

Scenario 3: On a third PC, data entry is only working sometimes. For some entries we managed to enter data, then it stops receiving data for a small period of time, and then accepts further entries.

Can anyone please shed a light on the issue? Is it a known issue in the pdo-sql driver which Microsoft have for PHP and if yes is there a way around it? Is it an Azure security feature and if so how can I disable it? Is there something I am missing?

Thanks a million for all your help!

Improve this question

1 Answer 1

Reset to default
1

Did you specify a range of IP addresses that can access your database?

To add trusted IPs, see "Create a server-level firewall rule" section at: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-get-started-portal

To help protect your data, Azure prevents access to your server until you specify which computers have permission. For more details, see docs at: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I have added an IP range from 0.0.0.0 to 255.255.255.255 already and the problem has not been solved.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.