Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Server (ACT7) service makes restar server WIndows 2003

Accepted Solution Solved
Copper Contributor
Posts: 17
Country: USA
Accepted Solution

SQL Server (ACT7) service makes restar server WIndows 2003

Hi Comm,

 

Recently I have noted a problem with my server running Windows 2003 Standard SP2 with ACT 2008.

 

Suddenly the server shows a message saying the computer is going to be restarted due to an error in lsass.exe

 

I was scared about famous virus sasser but my server seems to be clean and updated so I was taking a look around the event viewer, I located the event describing the lsass.exe error and I noted that always before the error some events appears related with ACT´s SQL Server service.

 

I have stopped the SQL Server (ACT7) and ACT! Scheduler services and I have changed the startup type to manual and after rebooting my server the lsass.exe error has not happened anymore.

 

Does anyone know what might be happening?

 

Thanks in advance for your help.

 

Regards,

 

Álvaro.


Accepted Solutions
Solution
Accepted by topic author alvaro.martin
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: SQL Server (ACT7) service makes restar server WIndows 2003

Hello alvaro,

ACT! uses its own instance of SQL Server called "ACT7". The following two Knowledgebase articles provide instructions to remove and reinstall this instance:

 

Remove:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2340...

 

Reinstall:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1938...

 

Be sure to reboot your machine after uninstalling, before you reinstall.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

View solution in original post


All Replies
Copper Elite Contributor
Posts: 514
Country: USA

Re: SQL Server (ACT7) service makes restar server WIndows 2003

Windows might be trying to install an auto update to the sql 2005 instance that ACT! 2008 used, but because it is a locked instance, it is failing when it tries to apply it.

Mark Hammer
ACT! Fanatic
Copper Contributor
Posts: 17
Country: USA

Re: SQL Server (ACT7) service makes restar server WIndows 2003

Hi Mark,

 

Thanks for your answer.

 

I have configured Windows updates just to install when I accept to install them and I have not installed any sql update recently, is there any way to know if Windows is trying to install something related with sql 2005?

 

Álvaro.

Copper Contributor
Posts: 17
Country: USA

Re: SQL Server (ACT7) service makes restar server WIndows 2003

I'm thinking to reinstall SQL Server 2005 in the server, is this software what ACT uses to manage their databases or it has its own sql server instance?

 

Regards,

Solution
Accepted by topic author alvaro.martin
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: SQL Server (ACT7) service makes restar server WIndows 2003

Hello alvaro,

ACT! uses its own instance of SQL Server called "ACT7". The following two Knowledgebase articles provide instructions to remove and reinstall this instance:

 

Remove:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2340...

 

Reinstall:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1938...

 

Be sure to reboot your machine after uninstalling, before you reinstall.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 17
Country: USA

Re: SQL Server (ACT7) service makes restar server WIndows 2003

Hi Greg,

 

I hace reinstalled SQL Server instance for ACT and now is working fine.

 

Thanks for your answer!

 

Regards,

 

Álvaro.