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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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/
http://kb.act.com/app/answers/detail/a_id/19640/
ASKER
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.