Newbie: trouble connecting to Azure database

asked 2021-11-01T20:10:21.747+00:00
Cary Bruestle 1 Reputation point

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.)

Azure SQL Database
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-11-02T01:46:24.867+00:00
    Oury Ba-MSFT 9,561 Reputation points Microsoft Employee

    Hi @Cary Bruestle 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)

    145605-image.png

    Regards,
    Oury