I'm having really frequent and occasional connection problems between my local instance of Microsoft SQL Server 2014 Management Studio (MSSQLSMS) and my cloud Microsoft Azure SQL Database.

Sporadically, my MSSQLSMS reports Disconnected along with the following error message when asking queries:
Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Unfortunately, Googling this problem doesn't give me any clue on how to solve it.

Facts:

• I don't have any bad or lousy internet connection. It is fast and stable!
• I don't have any problems connecting to other remote SQL Server Databases.
• My cloud Microsoft Azure SQL Database is just for learning purpose - there is not heavy load on it since I'm the only user.

Does anyone know what's the problem here?

Hello,

You always have 3 replica of your Azure Database: The currently running one, a backup in the same datacenter and a second backup in a different datacenter. Sometime MS has to patch the server for security and for this the "current" shut down and the backup comes up; so you get disconnected. But this should be an issue at all if you well program database connectivity.

Hi, 

Azure SQL database has firewall settings where you need to update with your IP address, otherwise it will not be connected. If your IP address changes, it needs to be updated.

thanks,

Mostafa