long day; AC tech support couldn't solve the problem, that makes the problem seem more mystifying - today we uninstalled sql svr 2005, reinstalled AC, sql svr/AC was not loaded;
reinstalled SQL SVr 2005, reinstalled AC only to see that it is asking for an older install file (KB893803-v2-x86) which was taken off the downloads on Microsoft since SQL 2005 was released (?); have rebooted the server after each modification; it seems like the solution is incipient, but hidden from us; I'm thinking of reformatting the server, and reloading Server 2003, and starting fresh; I might be able to salvage functionality by reloading from one of my backups off the server if the system was mirrored entirely from an earlier point - gonna check with my IT backup; I will let you know where I'm at with this tomorrow; lucky for me I synched my notebook and database before all this trouble so I can at least run off that for now
You say that you install SQL Server, then AC. If neither is on the machine, why aren't you installing AC along with SQL at the same time.
I think reformatting the server would be the biggest mistake you could ever make.
If installing AC and letting it install SQL Express (even though it isn't as good as 2005 Standard would likely solve the problem. SQL would be installed and AC would be installed in its own instance and work.
Short of this, I could put you in touch with my SQL Server expert, and it would be fixed in two to three hours. But, no one ever takes me up on that. Would be much better than reformatting your server and having the same problem. My understanding anyway is you will have a much easier time if you install Express, then upgrade to 2005 Standard.
