Below are the steps to Connect to Azure SQL Database with SQL Server Management Studio:
- We are creating with our Azure subscription, if you don't have an Azure subscription, you can create a free account in just a couple of minutes.
- Login to the Azure portal site using your subscription id and password
- Once login you will be on Portal page of Azure.
Note: first you need a SQL Database on Azure site with your subscription, If it not available follow the below my last blog about how to create SQL database on Azure:
Connecting to the Microsoft Azure portal with a subscription
- First of all we need to install latest version of SQL server Management Studio (SSMS) on local machine (Where you are going to connect)
- The newest version of SSMS is optimised for both SQL Database and SQL Server 2016, and is also designed for use with older versions of SQL Server. To download and install the most recent version of SSMS, see Download SQL Server Management Studio .
Use the following steps to connect to Azure SQL Database with SSMS
- Type "Microsoft SQL Server Management Studio" in the Windows search box, and then click the desktop app to start SSMS.
- In the Connect to Server window, enter the following information:
Server type: The default is database engine; do not change this value.
Server name: Enter the name of the server that hosts your SQL database in the following format: <servername>.database.windows.net
Authentication type: If you are just getting started, select SQL Authentication. If you have enabled Active Directory for your SQL Database logical server, you can select either Active Directory Password Authentication or Active Directory Integrated Authentication.
User name: If you selected either SQL Authentication or Active Directory Password Authentication, enter the name of a user with access to a database on the server.
Password: If you selected either SQL Authentication or Active Directory Password Authentication, enter the password for the specified user.
- To get above information login to Azure portal and click on created SQL Database and verified below screen shots with needing information
- Here we will server name, login details will be same as your subscription for first time login.
- Open SSMS 2016 then enter the login details with sever db name and Click
- If your client's IP address does not have access to the SQL Database, you will be prompted to sign in to an Azure account and create a server-level firewall rule
- If you are an Azure subscription administrator and need to sign in, when the sign in page appears, provide the credentials for your subscription and sign in.
- After your sign in to Azure is successful, Click ok to configure
- Again go back to SSMS and click on login, here we will able to connect SQL DB in local machine
Thanks
Your new valuable key points imply much a person like me and extremely more to my office workers. With thanks; from every one of us.
ReplyDeleteAmazon Web Services Online Training
Very nice to read the post
ReplyDeleteSQL DBA training in chennai
I am inspired to read this blog. keep sharing more informative blogs.
ReplyDeleteData Science Course in Chennai
Data Science Courses in Bangalore
Data Science Training in Bangalore
Best Data Science Courses in Bangalore
Data Science Institute in Bangalore
Data Science Training Institutes in Bangalore
Data Science Training in BTM
Data Science Training in Marathahalli
DOT NET Training in Bangalore
PHP Training in Bangalore
Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.
ReplyDeleteMicrosoft Windows Azure Training | Online Course | Certification in chennai | Microsoft Windows Azure Training | Online Course | Certification in bangalore | Microsoft Windows Azure Training | Online Course | Certification in hyderabad | Microsoft Windows Azure Training | Online Course | Certification in pune
really the blog is good
ReplyDeleteoracle training in chennai
nice thanks for sharing......................!
ReplyDeleteAzure online training
Azure training
Chef online training
Chef training
Data Guard online training
Data Guard training
Data Modelling online training
Data Modelling training
Data Science online training
Data Science training
DevOps online training
DevOps training
Exchange Server online training
Exchange Server training
Google Cloud online training
Google Cloud training
IBM Intergration Bus online training
IBM Intergration Bus training
IBM Message Queue online training
Thanks for sharing
ReplyDeleteSAP mm training
SAP pm training
SAP PP training
SAP Qm training
kralbet
ReplyDeletebetpark
tipobet
slot siteleri
kibris bahis siteleri
poker siteleri
bonus veren siteler
mobil ödeme bahis
betmatik
MLMM