SQLAgent account longer than 30 chars

keymoo

Hello,

I am getting the symptoms described in this article:

http://www.red-gate.com/supportcenter/C ... 000285.htm

However, the article does not describe exactly what security checks are skipped when adding the registry key to Skip Checks. I cannot change the service account name at the moment and need to understand exactly what security risk is presented by switching off security checks.

thanks

Brian Donahue

Hi,

I believe it skips the check on your login to make sure you have permissions to do the backup. If you skip this, your backups will fail. So I don't think there are any security implications as a result of skipchecks.

keymoo

Thanks, on one of my servers where the SQL Backup server components are installed I am getting the above symptoms but the registry hive HKLM\SOFTWARE\Redgate does not exist. This means I cannot add the SkipChecks key to this server.

Please advise as to how to fix this.

Regards,
keymoo

Brian Donahue

The key name is RED<space>gate rather than "redgate". This key will exist on your SQL Server. If it doesn't, you're probably going to have even bigger problems.

keymoo

There are no keys named Red anything, no red-gate, redgate or red<space>gate. This is a production server so I need it fixed - should I call redgate support?

Brian Donahue

If it's a 64-bit server you will find this in the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate key.

keymoo

Brian,

Yes that was it, thanks - I am using a 64-bit server. Working fine now.