CODEWITHSUNDEEP
sqlsql-serverdatabaseazurevirtual-machine
Heap of Pinto Beans
Heap of Pinto Beans

Reputation: 677

Azure VM Database

I just got finished creating a VM in Azure and called it vm123. I was trying to use that VM when creating my SQL Server. When I create a SQL Database in Azure, it forces me to either create a server or pick one from dropdown. Why can't I see my vm123 in the list?

PICTURE: Do not see vm123 on the list

I can create a new one alright, which is what I did, since my VM did not appear in the dropdown. How do I remote into it? See screenshots... PICTURE: I created new server while creating database but can't remote into it

Upvotes: 0

Views: 62

Answers (2)

Architect Jamie
Architect Jamie

Reputation: 2599

Azure SQL Database is a managed service and the underlying infrastructure is shared across tenants.

If you really need access to the host then you'll need to choose from one of the following:

  1. Create a SQL Server VM (includes licensing but at a higher operational cost)
  2. Create a Windows Server VM and install a SQL instance on it. You must license it yourself accordingly.

Upvotes: 1

Sajeetharan
Sajeetharan

Reputation: 222720

You are confusing VM with the Database server, the one asked in the dropdown is a SQL server not a VM. Those two are two different services on Azure.

To fix this create a SQL server resource first and you should be able to see that in the dropdown when you create the database.

Upvotes: 1

Related Questions