ACT 2012 or actdiag cannot connect to SQL

[audiotx100]

Ok

So I have now edited registry to complete manual delete of ACT and SQL

Reloaded act now actidiag can see a database

I go to reset password but the box is greyed out

I click ok and go back to open a database but does not work

It is on Port 52251 is that right?

All pipes are open and alias data correct

[audiotx100]

Ok - So I have now edited registry to complete manual delete of ACT and SQL

Reloaded act now actidiag can see a database

I go to reset password but the box is greyed out

I click ok and go back to open a database but does not work

It is on Port 52251 is that right?  All pipes are open and alias data correct

I open act it says loading then I just get a window with handshake logo

Here is a log

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.Data.SqlClient.SqlException: Login failed for user 'sa'.

A severe error occurred on the current command.  The results, if any, should be discarded.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

[audiotx100]

OK

All reloaded again

ACT starts to load

then all that is seen is handshake logo

ACTDIAG now connects and log error shows

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

I have not changed the database password so what does this mean?

Does it refer to the ACT7 instance password?

[ghollister]

This is an issue with SQL SA password. Go to this KB article an download the batch file from the File Attachments section:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2887...

- Download the batch file
- Close ACT!
- Run the file file by right-clicking on it and selecting 'Run As Administrator'
- When prompted to turn off password policy, answer 'y' (may get prompted twice)
- When complete, open ACT! to test

[audiotx100]

Thank you

Did as you say

Actidag connects,

Database list visible

ACT still will not open

HAndshake symbol nothing else

[audiotx100]

In actdiag I run check database and it sees the DB and confirms it is OK yet act will not open
Since running the bat file I can no longer see loading act, loading contacts, the legend just minimizes into a handshake logo so it seems a step back

[ghollister]

In the Task Manager, under the Processes tab, do you see the ActSage.exe process running?

[audiotx100]

Thank you for your reply

Yes Sage.exec is running

Indeed to try and run again the database I need to stop the process and start again or selecting databse files direct does nothing and  I need to close the .exe

Before running the .bat file I did see act starting and then the bar come across as it is loading database contacts

now all that happens is the sage logo minimises and if I tap tab to see what screens are open I see the ACT handshake symbol minimised and nothing else

[DrkSharkACT]

I experienced similar issues last month.  After thoroughly removing/cleaning all instances of ACT and SQL Server in all file structures and Registry, it loaded up as a fress install and I was able to open my DataBase.... PHEW.