06-14-2013 04:58 PM - edited 06-19-2013 10:01 AM
I have a new customer that has a backup of their ACT DB. They were using a hosted version of ACT and no longer have contact with the vendor. I tried restoring the DB to the new version we put on her new server but her ID must not have to correct privileges as I get a popup that states You do not have the authority to restore the database.
Is there anyway around this?
I am using File / Restore Database / Restore As...
06-17-2013 10:08 AM
Sounds like the user doesn't have apporpriate security role in Act! to restore the database. You can extract the BAK file from the ZIP file and use actdiag to restore the BAK. You can then try different user names and passwords to get access to the database. If you still cannot access the database you will need to go through our Login Disclose service to retrieve the user name and/or reset password.
06-19-2013 07:52 AM
OK, I managed to get passed the previous issue by contacting the vendor directly. They supplied me with a new DB with my client as the administrator and I went through the same process to restore the DB. I recieved the below laundry list of errors. I searched the Knowledgebase for the column in question and it came up empty. I did find a similar issue where NULL was casuing an issue but it was based on converting a DB to the latest version and there was an executable attached to that solution but I did not want to run it as it was not an exact match.
06-19-2013 09:58 AM
My fault I guess.
Hosting company is using Act Premium and I installed Act Pro on the new server.
Never enough Due diligence I guess.
In any event he is going to save the DB in Pro format and resend and that will likely solve the issue.
The client is very small, currently only 3 users and they don't use the Web or Phone accessibility so I am hoping that once I show the differences to the client there will not be a need to upgrade to Premium.