09-30-2010 02:16 PM
I have ACT! 2011 and it was working this morning until MS7 did some update now I can't open my DB, restore AS or create a new one.
ERROR IS: Unable to create Database. There is an error connectiong to the Microsoft SQL server,
Can anyone help?
09-30-2010 02:27 PM
The update may have turned off the SQL service. Try this:
- Click your Windows Start button. From the Start menu, either click Run (Windows XP) or go to the Search box (Vista, Windows 7) and type in services.msc
- When the list of services comes up, scroll down and locate SQL Server (ACT7)
- Right-click on the service and select either Start or Restart, whichever is not grayed out
- After the services starts up, close the services screen
- Open ACT! and see if you can access your database
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
10-10-2010 06:52 AM
12-27-2010 05:59 AM
I saw your post and thought I would give it a try for my problem. I am running ACT 2011 Pro. I upgraded to Win 7 Professional from Vista. Couldn't open my databases. Went to services.msc and started my SQL Server (ACT 70 and it worked. I would have never figured that one out. Thanks for the post.
12-30-2010 11:20 AM
04-04-2011 09:50 AM
How can I change the settings at startup so that I dont have to go into services.msc and manually start the SQL Server for ACT every time I start my computer? There must be away to change the startup boot protocol? Pleaee help.
04-04-2011 10:21 AM
After you go to start, run, services.msc...
you can tell the services to start automatically, instead of being manual.
Right click on the service, choose properties, then in the drop down you can select Automatic.
Hope that helps.
04-04-2011 12:56 PM
Mine is set the automatic and I find myself having to start it quiet often.It is a real pain.
I am also out of virtual memory every morning on the main database PC but I suspect this is a Delll driver rather than ACT at this point. (unless others are having the same issue with Act 2011 and Vista?)
04-05-2011 05:46 AM
If the SQL Server (ACT7) service keeps stopping, you'll want to check your Automatic Updates (Windows Updates) - look for any SQL update attempting to apply. If there is one listed, it is most likely the cause of your problem. You can remove/hide the update so that it will no longer attempt to apply through Automatic Updates. Depending on the SQL update attempting to apply, we may have instructions in our Knowledgebase for applying it manually.