04-19-2011 07:17 AM
Synchronization has failed. Server Error Description: Setuser failed because of one of the following reasons: the database principal 'dbo' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission. Contact your administrator for assistance.
I am receiving the above message as I try to sync with our master database, which was recenly move to a new computer. ACT help suggests database maintenance, detaching and reataching database. I have tried all these but nothing works. Any other ideas? Id it possible something was done wrong with the master database move to a new computer?
04-19-2011 07:29 AM
There are several steps involved in the move and any one of them could have caused this. Before I threw in the towel, please consider reaching out to a ACT consultant.
Here is a Knowledge Base Article which references the error you mentioned.
04-19-2011 10:21 AM
Have you tried Opening the Main Database (not the remote trying to sync) go into Help/About ACT! then clicking on Database Information? Close out of that and then retry the sync.
If you detached and reatthached - did you also delete the databasename.pad file, then open the database via the .alf file? This recreates the .pad file (which is just a pointer to the database file)?
Finally - if the server name changed where your main database is located then make sure you've made the change on the syncing database in the sync panel (manage main database location).
Technology Transfer Services
(813) 908-1100 x231
01-08-2013 10:09 AM
I came here to find a solution to the same problem. I was doubtful it could be as easy as going into the Help->About ACT!, clicking on database information, and closing out. But it worked! Thanks Klock!