I am sick and tried of these ACT Sync failures!!!!!!

[RobertAce]

Please HELP!!!!

I have a main data base PC and client desktop PC, they were syncing fine, now I get this attached error, sync fails at last error checking, I have search and run the SQL batch file on the client and it is all clean but the host I get below error

The SQL Server (ACT7) service is stopping.

The SQL Server (ACT7) service was stopped successfully.

The SQL Server (ACT7) service is starting.

The SQL Server (ACT7) service was started successfully.

Type in your database name

LaptopOct08

Msg 18456, Level 14, State 1, Server DT1\ACT7, Line 1

Login failed for user 'xxxx\xx'.

Press any key to continue . . .

Please see attached client error.

[RobertAce]

Also tried but did not help http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28141

[pbuchtmann]

Robert

Which version of ACT?

Did you run the batch file on both master and remote?

Try detaching and reattaching both databases

Make sure all of the above are done when either logged in as the Administrator account or right click and choose run as administrator when opening and closing ACT

[RobertAce]

Paul Thank you, Yes I did run the batch file and I am getting an error on the host computer -

I remember now. It is the 2012 Premium, and this happened before and we called the tech support and he did the following

1-detach the database from the actdiag

 2-move or copy the adf or alf file over to another computer with act on it

 3- attach the adf file using the actdiag

4- run the sql express bat fileon another computer until u get 0 rows affected

 5-move the database back to the old computer and open the database

I need to do it again but I need more clear guidance I am hesitant to do it with below steps, if any one can give me step by step guidance I appreciate it.

Thank you,

[gmartin]

Your steps look good, here are some additional details:

- How to move a database (KB Article 23392)

- How to attach database using ActDiag (KB Article 27607)