Database Administration
sql-server sql-server-2014 permissions connectivity tempdb
Updated Fri, 05 Aug 2022 20:26:00 GMT

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?

enter image description here

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)




Solution

This has been sorted out.

what it was is that while changing the tempDB file locations I put them in the T: drive and the sql server accounts did not have permissions there.

After I have copied all permissions from the sql server data folder to the T: drive it all worked fine.

to copy all the folder permissions from D:\data to T:\tempdb using Powershell (run as administrator):

$Acl = Get-Acl "D:\data"
Set-Acl "T:\tempdb" $Acl

enter image description here