search

microsoft / studentambassadors

This repository is for Microsoft Learn Student Ambassadors.
MIT License
130 stars 47 forks source link

IP address not allowed to access the server #192

Open anupamishra333 opened 1 year ago

anupamishra333 commented 1 year ago

Describe the bug

I Cannot access to the server i created before using the steps to create resource & server

What happened?

After Creating a resource group & server with azure powershell. When I tried to access the server through SQL database using SQL authentication. It denied to access the server asking to change the IP address range. The default ipstart range is 0.0.0.0 and endrange 0.0.0.0 However 0.0.0.0 should also work since it is a wildcard ip. Updating IP is recommended just for security purposes.

Screenshot (8)

What did you expect to happen?

Login successfully with default IP address.

How would you reproduce the bug?

  1. Go to azure powershell and follow the steps to create resources, server.
  2. After creating server its time for Query the database.
  3. In the portal, search for and select SQL databases, and then select your database from the list.

On the page for your database, select Query editor (preview) in the left menu.

Enter your SQL server authentication server admin login information

Did this happen via Desktop and/or Smartphone?

Desktop

Operating System

Windows 11

What browsers are you seeing the problem on?

Chrome

Version

No response

Device

No response

What is your current role?

Student Ambassador

What technical topic is this bug related to?

AI/Data Science/Machine Learning, Application Development, Other

Relevant log output

No response

github-actions[bot] commented 1 year ago

Thank you for submitting this issue! The team will review your issue, tag with the appropriate tags, and comment with any additional questions on information needed. :sparkles: