04-02-2009 07:37 AM
Would appreciate if anyone has any insight into this problem:
Even though I have this service set to start automatically everytime Windows restarts - I always have to go in and manually start the SQL Server (ACT7) - MSSQL$ACT7. Everything works fine otherwise, it just won't start automatically.
Running Act! 2008.
04-06-2009 11:55 AM
Do you have automatic Windows updates enabled? If you do, check to see if you have Microsoft® SQL Server® 2005 Service Pack 3 pending to install. If you do, follow the KB article below to install the update.
If you don't have the update pending, check your antivirus, spyware, etc.. to see if its scanning and possibly stopping the server . You can try disabling or excluding for a day to see if security software is causing the issue.