Link to home
Start Free TrialLog in
Avatar of Ali Shah
Ali ShahFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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?User generated image
SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vitor Montalvão
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).
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ali Shah

ASKER

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.

regards,