Access Denied

PeerlesslyHinged's profile image PeerlesslyHinged posted 2 years ago in General Permalink

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.

1 attachment(s):
  • Screenshot-2023-07-15-023629
ansgar's profile image ansgar posted 2 years ago Permalink

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":

Description

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.

raydrak's profile image raydrak posted 2 years ago Permalink

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.

raydrak's profile image raydrak posted 2 years ago Permalink

Oh, the version is current: 12.5.0.6683 and on thinking, the one computer it does this to, even with a reinstall, is the only Windows 11 system on my network. All the Win10's does not display this behavior.

Please login to leave a reply, or register at first.