• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 129
  • Last Modified:

How to connect to Azure SQL Server from Management Studio

Hi guys,

How do i connect to a database hosted in Azure environment. I can RDP to Azure itself and can logon to SQL Server using windows authentication however i want to access the instance on my local machine using Management Studio. I am new to Azure can you please help?Azure Error
Ali Shah
Ali Shah
3 Solutions
Pawan KumarDatabase ExpertCommented:
Well connection to Azure from local ssms requires few steps.

Please follow the steps from below URL -- https://dzone.com/articles/connecting-sql-azure-sql

Hope it helps!
Daniel JonesData Research AnalystCommented:
Take a look at this link, It shows the list of test that you need to perform to fix the error: http://social.technet.microsoft.com/wiki/contents/articles/1719.windows-azure-sql-database-connectivity-troubleshooting-guide.aspx
Vitor MontalvãoMSSQL Senior EngineerCommented:
Your issue is with the server name.
Where you got the name that you used from? It should be get from the Azure portal and you should use the full qualified name (servername.database.windows.net).
Eugene ZCommented:
it looks like you need to review -adjust you r sql server setup .

The error shows "Name pipes" -need TCP\IP
if your sql server is set yo use the default port 1433
try from SSMS use  where  you type sql name to use TCP protocol:

TCP:YourSqlServer,1433                          /https://msdn.microsoft.com/en-us/library/ms345343.aspx#otherComp/

Also, just in case check if sql server  Browser service on your server is running

check Provision a SQL Server virtual machine in the Azure Portal


How to Troubleshoot Connecting to the SQL Server Database Engine
Ali ShahSQL DeveloperAuthor Commented:
Thank you very much. SQL Server was not configured at all. these steps helped me to configure it. There are still network issues which our network administrator is looking at.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now