From the course: Visual Studio Tools for Azure Developers

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Connect to Azure SQL Server

Connect to Azure SQL Server

From the course: Visual Studio Tools for Azure Developers

Start my 1-month free trial

Connect to Azure SQL Server

- [Instructor] SQL Server for Azure is a Cloud optimized version of SQL Server. I'll show you a sample database I created on the Azure portal. You'll find it here. This is the name of the database I'll use, vscoursesquldb-340. I created it by going to the Add button and making some changes here in the basic settings. I picked my subscription, chose my resource group, gave my database a name. You'll need to host your database on a Windows server. So you want to choose a server from your list here, okay, I used this one but if you don't have one you click on Create New server. Enter your server name, enter your login credentials, you're going to create a new admin login account and a new admin password. And you'll need the admin login and password to connect to this database in Visual Studio. Then you click the Review + Create but before you do that let me show you one more thing. Go to Additional settings. If you leave it at the defaults you'll get an empty database with no tables. You…

Contents