I created a database in azure and assigned a new server to it. I entered my ip address in the firewall and tried to connect to the server in Sql Server Management Studio but no success. I tried to ping the FQDN of the server server.database.windows.net but no success.
I searched the problem and I found that the server cannot be pinged
click here. Can you please help me in connecting to the SQL server or database from SSMS on my machine?
Thanks
Sql-server – Unable to ping/connect to azure sql server from sql server management studio
azure-sql-databasesql serverssms
Related Question
- Sql-server – SQL Server Management studio slow connection or timeout when using Windows Authentication
- Sql-server – Can connect using SQL Server Management Studio but cannot ping or via program
- Sql-server – SQL Server Management Studio – Cannot connect – Method not found SqlConnectionInfo.set_IsActiveDirectoryUniversalAuth
- Unable to connect using Azure AD Service Principal on SQL Server
- Sql-server – Connection issues with Azure DB from SSMS
- Sql-server – SSMS can’t connect to Azure database
- Sql-server – SQL Server Management Studio cannot connect because of common algorithm
Best Answer
The problem was with our company firewall. The port 1433 was blocked on the firewall. After removing the outgoing and incoming restrictions on firewall the SMSS started working.