Reference attached image. I keep seeing "Access Denied" in the console log thing at the bottom of the window, however, it still lets me access the SQL database. Not sure if that's an issue or how to go about resolving it so it doesn't say Access Denied in the log.
Access Denied
Strange. I just had a look and I saw some auto-backuped files are loaded into query tabs at the position where you have that "access is denied":
I'm nearly sure that "access is denied" error is not something from the database server. Could really be a file permission issue on your pc.
I would have a look at the tabs.ini file in C:\Users\youruser\AppData\Roaming\HeidiSQL\
, and see if the contained filenames reference some invalid file or so. Be careful when editing that file.
I was having the same issue with only one computer all with the same version. After reading the above I checked my tabs.ini and it has an entry: BackupFilename=C:\Users\drak\AppData\Roaming\HeidiSQL\Backups\query-tab-2023-07-16_16-46-23-598.sql
That .sql file does not exist in the Backups folder. I attempted to change the entry to: BackupFilename=
I wasn't sure if it was safe to delete the tabs.ini. This just made HeidiSQL to make a new [timestamp] entry (keeping the old) and put a filename in there that doesn't exist.
I then attempted to delete the tabs.ini file completely and it recreated the file with the same entry. Again no Backup file is present or created.
Hope that helps out. Glad to know it's not something that affects usage. Odd just affects one install.
Please login to leave a reply, or register at first.