Notifications
Clear all
Topic starter
Curious for those of you who have a training database that mirrors your live database if you have every gotten this error message? Also, how did you license your test db?
Posted : June 8, 2012 4:04 am
How are you mirroring your database? LogShipping, Mirroring, other?
I think we had this issue as well. If I recall correctly you may have to delete the cpsuser account from the mirrored database and then re-add them. I am not 100% sure if this fixes that issue or not however.
Posted : June 8, 2012 4:28 am
Topic starter
Havent had a chance to setup a mirroring yet. It is a direct db copy and restore.
Posted : June 8, 2012 4:31 am
Yes, that is what we are doing as well. I am pretty sure you need to go to the database CentricityPS, go to securities and logons and delete the CPSUSER. then recreate him at the top level and attach them back to the restored version of CPS database.
We have to do this even during a regular upgrade when moving database from one server to another. for some reason the permissions do not come across corecctly, Also probably just missing the CPSUSER account at the top level of securities for the SQL server.
Posted : June 8, 2012 4:36 am
ErnieT said:
Havent had a chance to setup a mirroring yet. It is a direct db copy and restore.
How are you copying your DB files across to the secondary server? I know we were using powershell to copy the file over, but as the file size grew that job started to freeze the entire server making it unresponsive. I had to automate an ftp transfer of the file nightly to avoid this issue, just FYI.
Posted : June 8, 2012 4:41 am
Topic starter
Right now it is a Manual process. Havent had a chance to automate anything yet.
Posted : June 8, 2012 4:42 am
ErnieT said:
Right now it is a Manual process. Havent had a chance to automate anything yet.
If you want some help / advice / what have you, when you come to that bridge let me know and I will be happy to help.
Posted : June 8, 2012 4:44 am
Topic starter
Thanks, I will probably take you up on that.
Posted : June 8, 2012 4:46 am
Topic starter
You da man Joshua. Deleted and recreated the account and worked like a charm. I will be putting that in my notes.
Posted : June 8, 2012 4:51 am
