The connection is broken and recovery is not possible - sql server error I am having the following sql server error, while creating tempDB files.
Any ideas?




  The connection is broken and recovery is not possible.  The client
  driver attempted to recover the connection one or more times and all
  attempts failed.  Increase the value of ConnectRetryCount to increase
  the number of recovery attempts. (Microsoft SQL Server, Error: 0)
I had this issue when I was trying to Deploying a Database to Azure SQL Server. I tried a few times and I got the same error. I double-check the Azure permissions, Firewall, user and pwd.
What I did to fix it was run SQL Management Studio as Administrator. Simple as it.
I believe the problem was some permission to the temporary file to &quot;C:\Users\xxx\AppData\Local\Temp&quot; to create bacpac file.