Link to home
Create AccountLog in
Avatar of infedonetwork
infedonetwork

asked on

Sage Act can't connect to database

Few days ago users start to complain that nobody can connect to the database located on the server.
So I start with the basics.
Verify that all the Act and SQL services are start it on both the client and the server. Make sure the Act sync is running on the server.
I reboot both server and client machine.
I move the database from the server on the local client machine to test it locally.
I even install Act on the server where the database reside. I also restore the Database from backup like few days before all this happens. Still the same error no matter from where I try to run it.
User generated image
ASKER CERTIFIED SOLUTION
Avatar of AndyAinscow
AndyAinscow
Flag of Switzerland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of infedonetwork
infedonetwork

ASKER

Yes I did.
I figure it out.
The Computer Browser was stop. Once I start it all clients was able to see it but for some reason the database become unshare and I had to share it again. Not sure what happen and how a database become unshare but now it's all good.
There are quite a number of causes for this error. All of them listed here:
http://kb.act.com/app/answers/detail/a_id/19640/