How can we help you today? How can we help you today?

SQLAgent account longer than 30 chars

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
keymoo
0

Comments

6 comments

Sort by
  • 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.
    Brian Donahue
    0
  • 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
    keymoo
    0
  • 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.
    Brian Donahue
    0
  • 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?
    keymoo
    0
  • Brian Donahue
    If it's a 64-bit server you will find this in the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate key.
    Brian Donahue
    0
  • keymoo
    Brian,

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

Add comment

Please sign in to leave a comment.