Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009
Accepted Solution

Remote Path when creating remote databases

When creating a remote database in admin, there is a setting for "Remote Path - Recommended setting is the data directory of the source database".  How "Recommended" is that?  We're having some permissions issues on Server 2008 R2 where, even though the person creating the database is supposed to have Read/Write permissions on the target directory (remote path), they are unable to copy or cut any of the files created by admin through the admin tool.  

 

Can we point the remote path to a different file server?

 

Thanks


Patrick

Employee
Posts: 79
Registered: ‎06-25-2009

Re: Remote Path when creating remote databases

Patrick, It is important to note that it is the SQLServer service user that needs permission to the directory.  It is the SQLServer process that is actually moving the created database to the specified location.  That is why we recommend this path be somewhere on the server.

This path can exist elsewhere as long as the user configured for the SQLServer service has access.

Paul Zeimet
Development Manager
Infor CRM
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Remote Path when creating remote databases

Thank you Paul!