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 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
External links referenced by this document: