This video shows you what you need to do,such as setting firewall rules and finding the connection string needed to connect to your Azure SQL database from SQL Server management Studio. It also shows at how to create and configure an Azure SQL database from SSMS.