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.
act
LVL 2
infedonetworkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
AndyAinscowFreelance programmer / ConsultantCommented:
Have you disabled the firewalls on both client and server to test?
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
infedonetworkAuthor Commented:
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.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
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/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.