05-01-2011 11:05 PM
I had to delete & reinstall and ran into an issue upon reinstall with following message:
Upon trying to restart the SQL Server (ACT7) I get the following message:
Windows could not start the SQL Server (ACT7) service on local computer
Error 2: The system cannot find the file specified.
Next I tried to install ACT7 and was told to find
sqlrun_sql.msi which of course In can't find.
Anybody have an idea of what to do next???
05-02-2011 01:15 AM
I got ACT7 installed & it let me reinstall Act 2010 but when I try to open my database it says, "The database could not be accessed...," and if I try to restore a backup I get,
"Act.Data.DatabaseAccessException:Failed To Open A Connection To the Database--> Act.Data.ActDBException: Login failed for user "ACTACCESS"--> System.Data.SqlClientException: Login failed for user "ACTACCESS"
Plus a whole lot more that won't allow a cut & paste. I suspect I made some sort of error in reinstalling the SQL server but I'm at a loss to figure out what.
05-02-2011 04:54 AM
IMHO this problem is with a couple of things
a) DOT Net 4 is on the machine - try removing
b) MSXML Service Packs try removing
Then try a reinstall after fully removing SQL
Failing this you could try looking up ACTACCESS in the KB
05-02-2011 10:24 AM
Removed as recommended & went to registry level to insure everything was a blank slate but I must be missing something. Tried to reinstall but got the following message:
ACT! Installer has detected that the ACT7 instance is either not running or disabled.\n\nSystem.UnauthorizedAccessException: Access to the path 'D:\ACT!2010\SQLEXPR.exe' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at System.IO.File.Copy(String sourceFileName, String destFileName, Boolean overwrite) at PrereqCommon.SQLMethods.InstallSQL2005(String SourcePath, String ACTPath, String Param, String strSAPWD, Boolean InstallSP) at PrereqCommon.SQLMethods.PrepareAndInstallSQL2005(String strSrcPath, String strSQLPath, String strACTPath, String strSQLAccount, String strSQLCollation, Boolean IsSPNeeded)