How can I "connect to the main database" (Azure SQL database)

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

+4
source share
2 answers

You do not need to explicitly connect to master to create a database in Azure SQL DB. To create a database in Azure SQL DB, follow these steps:

https://azure.microsoft.com/en-us/documentation/articles/sql-database-get-started/

Also, can you give me links to articles that mention "Connect to the host" so I can take a look and fix them if necessary? Thank.

+1
source

, . , . select db_name() "master" .

master/nothing, .

- =========================================================================================== ================================================== ===========

- Azure SQL

- script . - SQL Server Management Studio, , .

+1

Source: https://habr.com/ru/post/1599611/


All Articles