Solved

How to grant user permissions within Great Plains (Backup and Restore)

Posted on 2008-10-22
4
1,576 Views
Last Modified: 2013-12-11
I have 2 users in GP that need to be able to back up and restore within Great Plains. They have proper permissions to the SQL databases but it looks like permissions must be set for the user accounts in Great Plains as well. Is this in fact the case? Where can I change these permissions? Thanks.
0
Comment
Question by:Xvand
  • 2
4 Comments
 
LVL 1

Expert Comment

by:Dynamics_Girl
ID: 22952292
Are you using the back up utility under the file menu?
0
 
LVL 1

Author Comment

by:Xvand
ID: 22952934
Yes. We are using Back Up and Restore under the application itself. The main questions that is left is what kind of permissions are needed in order to restore from a backup? We have given the proper permissions for Backing up but restoring still fails due to lack of permissions. Thank you
0
 
LVL 1

Accepted Solution

by:
Dynamics_Girl earned 75 total points
ID: 22953735
As far as I know, you have to be logged into GP as 'SA' to use the restore screen.  There is no amount of security that will allow you to restore as a user in this screen.



0
 
LVL 18

Assisted Solution

by:Victoria Yudin
Victoria Yudin earned 50 total points
ID: 23094765
You not only have to be logged in as 'sa' or 'DYNSA' but you also have to be on the SQL server itself to do this.  
The big difference between backups and restores in SQL are that a backup is just a snapshot in time and can be performed with users in the system.  A restore can only be performed when there is no one else in the system.
Not really best practice for a production environment to have multiple users backing up and restoring.  Why is this needed?  
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question