Can't access Azure SQL DB from my machine using python

Question

I created the my own database in azure which is now doesn't have any data. I follow this documentation to create the DB. I want to create table and access it from my machine using python. Here what I tried so far

import mysql.connector
from mysql.connector import errorcode

# Obtain connection string information from the portal
config = {
    'host': '<servername>.database.windows.net',
    'user': '<username>@servername.database.windows.net',
    'password': '<passwword>',
    'database': '<DB name>'
}
# Construct connection string
try:
    conn = mysql.connector.connect(**config)
    print("Connection established")
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with the user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)

but when I when i run it its throwing the following error

9002 (28000): The server name you tried cannot be found: <servername>.database.windows.net. Please check the Username and retry connection. The Username should be in <username@hostname> format.

I filled the credentials with mine.

Thanks in advance

I can access from Microsoft SQL Server Management Studio

Why I can't access via Python?

Are you using Azure SQL or Azure MySQL? Both are different! Your code is for MySQL, but you mentioned you followed the documentation for SQL to create DB. Most likely that's the issue. Code should be learn.microsoft.com/azure/azure-sql/database/… for SQL. If you want MySQL then create that instead. — krishg
– krishg, Commented Oct 6, 2020 at 8:31
After you created your database did you set the firewall rules? learn.microsoft.com/en-us/azure/azure-sql/database/… — Tim Mylott
– Tim Mylott, Commented Oct 6, 2020 at 13:26

Darkknight · Accepted Answer · 2020-10-07 04:52:07Z

2

I think you misunderstood SQL and MySQL. You can check here the difference between them.

You are trying to access the SQL database using MySQL connector. That can't be done. You have two solutions here

change your DB to MySQL check here
access using SQL code check here

feel free to ask if you need any clarification

answered Oct 7, 2020 at 4:52

Darkknight

1,87613 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Can't access Azure SQL DB from my machine using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related