Create Configure and Use SQL Server Database using Microsoft Azure

create configure SQl server microsoft azure 4
InfoPath alternatives for form designing SharePoint

In this Article I had explained how to create, configure and SQL Server database in Microsoft Azure.
Open Microsoft Azure Portal.

Logged in with your subscription Microsoft account
In your portal
Click New -> SQL database

 configure sql server in microsoft azure

configure sql server in microsoft azure

 

Also you can read my previous posts on:
– Create a responsive navigation menu using managed metadata navigation in SharePoint server 2013

– JQuery Tabs using content search web part in SharePoint 2013

– Cross site publishing in SharePoint 2013

Click Add
Provide the database name and select the subscription of your account
Create a new resource group

create sql server in microsoft azure

Click on the server to create a new server

    microsoft azure configure sql server database

microsoft azure configure sql server database

microsoft azure configure sql server database

Provide the Server name of your newly creating Database Server
Provide the login username and password to access the database server
Pick your server location
Click Select to create a new SQL server
SQL Elastic pool by default: N0
SQL elastic pool: SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases
Pick the pricing tier -> In my scenario am picked Basic 2GB

steps to create sql database in microsoft azure
steps to create sql database in microsoft azure

steps to create sql database in microsoft azure

Collation By Default
Click Create

create configure SQl server microsoft azure 1
create configure SQl server microsoft azure 1

So now the SQL server database has been created successfully and ready to Go
Now will connect it from local SQL Server Management Studio
Click Connect.

create configure SQl server microsoft azure 2
create configure SQl server microsoft azure 2

Provide the server name “vinodh.database.windows.net”
Pick authentication type “SQL Sever authentication”
Provide the username and password
Click Ok and connection works successfully.

create configure SQl server microsoft azure 3
create configure SQl server microsoft azure 3

Created database has been shown inside the server
Now going to create a table inside the database for example
Query: Create table AzureDB(Sub_name varchar(50))

create configure SQl server microsoft azure 4
create configure SQl server microsoft azure 4

You can also get the connection string from azure portal to click on connection string option

create configure SQl server microsoft azure 5
create configure SQl server microsoft azure 5

Now ready to go. Happy learning!…….

Similar SharePoint 2013 Tutorials


Leave a Reply