Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

New Member
Posts: 9
Country: USA

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

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. 060112_act_error.JPG

New Member
Posts: 9
Country: USA

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

Bronze Contributor
Posts: 955
Country: Australia

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

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

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.
New Member
Posts: 9
Country: USA

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

[ Edited ]

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,

Platinum Super Contributor
Posts: 5,275
Country: USA

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

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)

Greg Martin
Sage