Support Portal

Welcome, Guest Login

Support Center

DxTransfer Required Permissions

Last Updated: Aug 28, 2015 10:22AM PDT

Summary

An explanation of the permissions required to use DxTransfer.

Information

Source Permissions

  • If not using "Trusted Authentication" then the supplied UserID and Password are used to authenticate to the source Microsoft SQL Server instance.
  • Repository Path - The configured source instance service account is used to create the backup files. So the source instance service account will need write access to the Repository Path folder. If using a UNC path, then the source instance service account will need write access on both the folder and the file share permissions.
    • Mapped drive letters are generally not recommended for the repository path, as the instance service account will not have the mapping record unless specifically setup through SQL Server Management Studio. See the following MSDN blog for further details: Backup and Restore SQL Server Database to a network shared drive
  • If not using a domain account for the source instance service account then please see the "Additional Information" section below.
  • To change the source instance service account you will need to use Microsoft SQL Server Configuration Manager.

Target Permissions

  • If not using "Trusted Authentication" then the supplied UserID and Password are used to authenticate to the target Microsoft SQL Server instance.
  • Repository Path - The configured target instance service account is used to restore the backup files created from the source instance. So the target instance service account will need read access to the Repository Path folder. If using a UNC path, then the target instance service account will need read access on both the folder and the file share permissions.
    • Mapped drive letters are generally not recommended for the repository path, as the instance service account will not have the mapping record unless specifically setup through SQL Server Management Studio. See the following MSDN blog for further details: Backup and Restore SQL Server Database to a network shared drive
  • Target Path - The configured target instance service account will need write permissions on the folders to successfully write the databases that it restores from the repository path.
  • If not using a domain account for the target instance service account then please see the "Additional Information" section below.
  • To change the target instance service account you will need to use Microsoft SQL Server Configuration Manager.

Additional Information

To allow a SQL Server instance with the service account running under a local account (LocalSystem, MSSQL$<instance_name>, etc.) access to a network share via UNC path (\\server\share), the remote shared server must have the following security policies set:

  • Network access: Let Everyone permissions apply to anonymous users
  • Network access: Shares that can be accessed anonymously

More information on these policies can be found here:

More information on Microsoft Windows service accounts and permissions:

References

For more information on DxTransfer please see the DxTransfer User Guide.

Applies to...

  • DxTransfer

Contact Us

support.desk@dh2i.com
http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete