(This is for an Azure SQL database)
Almost every article says “connect to the main database” at the beginning before creating a new database.
I connected to my Azure SQL database server with SSMS 2014 without any problems. I see the main database in System Databases. I right-click on Databases (this is above the System database) in the LHS tree and clicks Create Database ...
The comments area of the template comments says, among other things, "... connect to master ...", which implies that I am not connected to the master.
I am clearly missing something very fundamental and obvious regarding the basics.
Can someone please spare me from my suffering :)
PS When I click "New Database ..." when connecting to non-Azure SQL Server 2012, I get a graphical interface and I can create the database without any problems.
source
share