SQL Agents in Create Images Error

vinay11vinay11 Posts: 15 New member
Hi Team,

In the clone Process , Creating Images we are getting error like "The agent on INSTANCE is still not able to access the server. Please check permissions for USER and try again."
Please find the attached screenshot
Tagged:

Answers

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    Hi,
    Thank you for your forum post.

    Can you please check the start-up account [OSB\vrevannasiddappa] for the Redgate SQL Clone Agent service on your machine 'OSBDMASKSQLD01' is a member of the Sysadmin Fixed Server role for the SQL Instance?  It appears that the account does not have the required permissions as per this help article. In the SQL Clone Agent requirements paragraph:

    SQL Clone Agent requirements

    An agent should be installed on the same machine as any SQL Server you wish SQL Clone to use as a source of images, destination for clones, or temporary scratch space for restoring backups.

    Requirements...
    • Operating System (one of):
      • Windows Server: Windows Server 2012 R2 or later
      • Windows Desktop: Windows 8.1 or later
    • Recommended CPU: 4 core 2.0GHz or higher
    • Recommended RAM: 4GB or higher
    • SQL Server 2012 or later (Express edition is sufficient - though Clones will not circumvent SQL Server Express' 10GB database size limit)
    • .NET Framework 4.7.2 or later (part of installation)
    • Outbound connection to remote (SQL Clone Server) port 14146 must be allowed
    • The Volume Shadow Copy Service must be available in order to make images from SQL Server instances:
      • The 'Volume Shadow Copy' service must be enabled
      • A shadow copy provider must also be enabled. The default software provider service is called ' Microsoft Software Shadow Copy Provider', but you may have a different provider (for example, if you're using a storage device that provides hardware support for shadow copying)

    This requires a Windows user account which has:

    • Local admin privileges in order to use the Virtual Disk Service
    • Read/write and change permissions access to network locations where images will be stored

    On local SQL Server instances where clones will be created or dropped, or images created from, the agent will also need a login with:

    • Membership in  the sysadmin fixed server role

    This can be either a Windows login tied to the agent's Windows account, or a SQL Server login.

    If you want to use a SQL Server login, you will need to provide the username and password (once) when creating an image or clone with the instance.

    The agent must have enough disk space to store the clones, bearing in mind that they may grow over time.


    Many Thanks

    Eddie

    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.