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)

This is an old thread but this was the first hit on Google so I'm going to add my experience here. I was using SQL Server 2014 Enterprise while remote connected to the server.

I was attempting to restore a database from backup WITH REPLACE and RESTORE WITH NORECOVERY. Between the backup and my first transaction log I received the error indicated above. No databases on the server were able to be accessed; all received the same message. I was, however, able to access the other databases by connecting through a local instance of SSMS and it indicated that my intended target database was (Restoring...), as expected.

Turns out, all I had to do on the server instance of SSMS was restart SSMS. All was normal after that.

StackExchange Database Administrators Q#108193, answer score: 5