Newbie: trouble connecting to Azure database

Question

I am new to Azure, I am trying to connect my local SSMS to a remote Azure SQL database.

I successfully created a SQL database :

• Server Name: motusaudere.database.windows.net
• DB Name: {mydbname}
• Server admin login : motusaudere
• Note - did not prompt for a password. I'm assuming that the password is the same as my Azure Portal password.

Firewall settings :

• Connection Policy: default
• Allow Azure services and resources to access this server: yes
• Rule:
  • Rule Name: {mylocalcomputername}
  • Start IP: {myip}
  • End IP: {myip}

In SSMS / Connect / Database Engine :

• Server Name: motusaudere.database.windows.net
• Authentication: SQL Server Authentication
• Login: motusaudere
• Password: {mypassword}

I get the error message "Cannot connect to motusaudere.database.windows.net." What am I doing wrong?

(By the way, the next step would be to get the app I'm developing locally to connect to the Azure database. First things first.)

Answer 1

Hi @Anonymous Thank you for posting your Question

When creating an Azure SQL Database did you select the option SQL Authentication. The password should be created when setting up server (see image below)

Regards,
Oury