Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACTDIAG failed to connect with message " Could not connect to the SQL instance"

New Member
Posts: 4
Country: United States

ACTDIAG failed to connect with message " Could not connect to the SQL instance"

We are using Act 10. I've found an article in knowledge base however it seems to apply to version 7? (it asks for reinstall the whole app)

 

Anyway, I think it caused by sa password becasue I found an message like ' login failed for user sa' when I clicked around. Is there any fix? My bottomline is not losing any data.

 

Thanks a lot.

Moderator
Posts: 4,395
Country: USA

Re: ACTDIAG failed to connect with message " Could not connect to the SQL instance"

[ Edited ]

Is the SQL Server ACT7 service started (Start -> Run -> services.msc)? 

 

Are you able to open a database?

Message Edited by dlunceford on 10-16-2008 03:23 PM
New Member
Posts: 1
Country: United_Kingdom

Re: ACTDIAG failed to connect with message " Could not connect to the SQL instance"

Hi

 

Reinvigorating this thread as I am having the same error message. 

 

The SQL Server ACT7 service is active but I am unable to open my database - I followed previous threads regarding the use of Actdiag to resolve problems but could not get up the 'Database List'.

 

Failure message is:

Cannot open database "BLAH" requested by the login. The login failed. Login failed for user 'sa'.

 

Can anyone help? We use Sage Act! Pro 2013.

 

Thank you.