03-18-2014 10:45 AM - edited 03-18-2014 11:21 AM
I am having issues with accessing my database. A recent Windows (automatic )update was done on my computer and immediately after I was not able to access ACT. It appears the SQL server had stopped and I was not able to get it to start. I called a computer tech and he worked on it and in command prompt he was able to get it started with this code
net start MSSQL$ACT7 /T360
I was still not able to get to my database and I uninstalled and then reinstalled the same version of ACT 2009 version 11.0. It seems that everytime I attempt to open the database the SQL server stops responding (I then have to manually reopen) and this error message appears
Error - tempdb is skipped. You cannot run a query that requires tempdb
Could anyone advise? I am not very tech savvy and any advice would be helpful. I am also wondering if I am to upgrade to the latest version of ACT, that it might by pass problems?
I am on Windows Vista and I am the only computer, I am not networked.
03-21-2014 10:58 AM
It sounds like the Microsoft SQL Server instance is damaged. Uninstalling and Reinstalling Act! alone won't fix this because the uninstall of Act! does not remove SQL. That has to be done separately. What you can do is uninstall Act!, uninstall Microsoft SQL Server, then reinstall Act! and act will recreate the SQL server instance for you. For instructions on uninstalling Microsoft SQL Server, see the knowledgebase article below:
Updating to the latest version of Act! is not a guarantee that Windows Updates won't interfere with the Microsoft SQL Server instance because these things do happen. What I can tell you though, is that Act v16 is the most solid release yet. There have been quite a few defects between Act 2009 and v16 that have been fixed along the way as well, so it might possibly be worth it for you to upgrade.