04-04-2013 06:17 AM
Our main ACT server got trashed by a series of brownouts during the storm this morning, so I've just finished reinstalling the darned thing (getting so sick of that...), and restoring the four databases on it from backups.
And discovered that none of our remote sites will sync. Nice of them to send a gig of updates BEFORE failing though..
I'm getting the following error:
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.
I thought the whole point of restoring from backup was that it recreated all the appropriate users, etc..
I can do the whole copy from remote, merge, and publish dance, but when we're talking 80gb of attachments, I'm not really wanting to send the remotes back down our wan links..
Anyone know of a way to simply restore the appropriate permissions etc for the dbo user?
BTW, if it makes a difference, both the master, and remote sites are running MS SQL Server standard edition, not the express edition that ships with act..
04-04-2013 08:45 AM
04-04-2013 12:10 PM
Yep, they're showing as active, with all the correct details showing..
I restored the DB's, by using 'Restore' (not 'Restore as')
04-04-2013 01:43 PM
Here is an article with some steps to try: KB Article 25099
Beyond those steps, try:
- Add exceptions to firewall/anti-virus using this article: KB Article 25125, test sync
- Assuming you are using Network Sync, change the port number being used (change it in Network Sync and in remotes), test sync
04-04-2013 02:19 PM
I just tried those steps on the Irish DB, waiting for it to sync now.. It's a bit of a bugger that it doesn't fail till the very end of the sync - means I have to wait ~1 hour for that initial sync to go through, while it catches up the last week!
Hmm, from your comments, I'm getting the feeling that you're suggesting that a network issue could cause this dbo credentials error?
05-07-2013 03:15 PM
In this reply, you have provided quite a few links for different firewall settings...my version of Bitdefender is "Total Security 2013" and there are HUGE differences between the version in the link (2009) and mine. Do you have a link on how to set up the Bitdefender Total Security 2013 Firewall?
05-07-2013 03:51 PM
Believe it or not, after trying all of the database repairs, and firewall configurations (none of which did a thing to allow the sync to complete) I clicked on Help > About ACT > Database Information... on both my remote and main programs - and my sync now works just fine.
It's worth a try gang!
05-08-2013 09:11 AM