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?