Reply
New Member
audiotx100
Posts: 12
Country: United_Kingdom
Message 11 of 19 (195 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

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

 

 

 

Please use plain text.
New Member
audiotx100
Posts: 12
Country: United_Kingdom
Message 12 of 19 (195 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

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)

 

 

Please use plain text.
New Member
audiotx100
Posts: 12
Country: United_Kingdom
Message 13 of 19 (195 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

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?

 

Please use plain text.
Platinum Elite Contributor
ghollister
Posts: 6,537
Country: USA
Message 14 of 19 (179 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

[ Edited ]

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

Greig Hollister
Sage

Note: Effective 6/1/13, Sage no longers provides support for the Act! software

Please use plain text.
New Member
audiotx100
Posts: 12
Country: United_Kingdom
Message 15 of 19 (174 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

Thank you

Did as you say

Actidag connects,

Database list visible

ACT still will not open

HAndshake symbol nothing else

 

 

Please use plain text.
New Member
audiotx100
Posts: 12
Country: United_Kingdom
Message 16 of 19 (173 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

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
Please use plain text.
Platinum Elite Contributor
ghollister
Posts: 6,537
Country: USA
Message 17 of 19 (172 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

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

Greig Hollister
Sage

Note: Effective 6/1/13, Sage no longers provides support for the Act! software

Please use plain text.
New Member
audiotx100
Posts: 12
Country: United_Kingdom
Message 18 of 19 (169 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

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

Please use plain text.
New Member
DrkSharkACT
Posts: 3
Country: USA
Message 19 of 19 (141 Views)

Re: ACT 2012 or actdiag cannot connect to SQL

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.

Please use plain text.