10-15-2016 10:33 AM
Installing Act Premium 18 (access from web). Installation was fine, as was database creation and access of the database from the server and all workstations where I installed the client. Regarding web configuration, I created the impersonation user and made it a member of the local administrators group, then opened Act → Tools → Web Site Administration. Testing on the Web Server tab revealed no problem, nor did configuring and testing on the User account tab.
But now, I come to Act's IIS configuration on the Add/Remove Database tab. Default Web Site & Virtual Directory APFW appear correctly, but now I have either one problem with two symptoms, or two separate problems:
I am guessing that perhaps the first error is a consequence of the seconda, but I cannot tell for sure. For the record, the Web Administrators Guide contains an entry that purports to address this but is of absolutely no help: "Verify that the user has the appropriate permission to access all Act files and database." Huh? I just created the user and made it a member of the local Administrators group. Nor is KB 37548 any help when it indicates, for the latter issue, to browse to C:\Windows\Microsoft.NET\Framework and give the impersonation account Full Control to the v4.0.30319 folder. This is nonsense, for two reasons:
Nor does KB 16516 help, when it indicates that these things must apply to the user: "Be a local Windows administrator on the Web server" and "Have permission to access all ACT! Premium for Web and database supplemental files on the server." Huh, again? What is there in this that does not exist via membership in the local Administrators group?
I did find other posts on the forum here regarding the IIS page error. But that person's solution (which may or may not solve my problem), which was to remove .NET 4.5, install .NET 4.0, then install Act, is not workable since .Net 4.5 is part of the Application Server role which is already in use for my backup system. So I cannot simply start hacking away at .NET and hope to have other system components survive. Nevertheless, I did uninstall Act, removed all C++ Redistributable packages whose installation was dated the same as my Act setup (avoiding those installed in conjunction with my earlier installation of my backup software), and reinstalled. But that all changed nothing.
Now I am kind of stuck. With no off-hours/weekend Act support, I must now troubleshoot this on a weekday, when users are connected to this same server for other purposes (it happens to be the main file server). But it will undoubtedly involve one or more server reboots. It seems clear that the Act developers have not tested setup routines very thoroughly. I am not (and do not want to become) an IIS expert. And, for the record, this is not a particularly old or complicated server; it is running just as a file server (and hosting Act), although it does also have backup software installed. But I am getting no clue that my problems are related to anything specific that predates Act installation.
10-16-2016 09:06 AM
10-15-2016 01:17 PM
10-15-2016 04:44 PM - edited 10-15-2016 05:34 PM
This is just great I have now spent upwards of 10 hours installing/uninstalling, looking up possible solutions, all to no avail. I have been very careful to change one thing at a time, then change it back if it did not help. I went as far as a complete uninstallation, removing IIS, removing all the .NET and IIS-related user profiles that were auto-created during setup, and I am still back to the last issue I had: a security exception in the /APFW application. I have no way of knowing whether this is farther ahead or farther behind than my prior "can not load file..." errors. I did get past one thing, as noted in my second post, by granting the Users group Write access to the C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files folder.
And, not too surprisingly, note that I have spent all day looking at posts directed at website developers (i.e. how to include dll's in setup packages, etc), not at posts directed toward IT managers trying to get a product to install correctly. In the particular case of this last event log / security-related issue, I get enough detail to see that there is a problem accessing the SECURITY log.
SecurityException: The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security
I found posts recommending giving various users (NETWORK SERVICE or my ASP.NET impersonation user) access to the Security event log registry key--to which the Administrators group already has access. I did try granting explicit permissions to the impersonation user, and even to Everyone (very temporarily), but found no change, so I reversed those change as well. Other than that, the posts seem to relate to the product itself not correctly creating the event log source at installation time--another developer-related issue.
Sigh...I should not have to be thinking about all of this...especially on a weekend.
10-16-2016 09:06 AM
10-17-2016 02:32 AM
12-27-2016 01:57 AM - edited 12-27-2016 03:05 AM
All I can say is Brain is right!
installation on a server 2008, 2012 or even 2016 when it is a domain server simply does not install correctly!!! It is a real dogs dinner that has never been tested or fixed in some 5 years. It hates 64 bit machines with Essentials Server software. (What was SBS)
This is what I have learn't over 10 years of looking after Act! myself.
Lesson number one... before installing make a back up of IIS. You will need it after the install has switched IIS to 32 bit mode and screwed up all your other web sites and settings. It will especially break MS Remote, Connect and most other small business services that won't run in 32 bit mode. Grrrr.
lesson number two... it will fail with missing prerequisites. It won't tell you what's missing! But run set up a second time as an administrator and it will install.
lesson three... sql won't run. You will need to reset the sql password.
lesson four... use the IIS backup to correct the settings to the pre install state. Test this before proceeding!!
lesson five... use apfwcreator to create a seperate web site for act in IIS. Only this should run in 32 bit mode. Note this will put the web site on port 8080 so you will also need to open this port in windows firewall, and also on your router.
Note, I have never understood why Act is determined to put the web site on the machine's default web site. I was always taught to keep seperate uses on seperate web sites in IIS wherever possible. It's more robust and much easier to diagnose when they play up. Also where is the logic in switching the whole of IIS to 32 bit mode? Its a crazy way of ensuring all your other services are fouled up, and is really unacceptable for a server configuration. Afterall, all MS servers are 64 bit.
Lastly, watch out for service pack upgrades such as 18.2! Why, because they mess IIS up all over again...which is how I came to be writing this note.
its exasperating, but it can be made to work brilliantly for small businesses, especially those that don't want/can't afford to run more than one server for a very small team of users.
And although unsupported, it runs perfectly on Server Essentials 2016..... FANTASTIC!
Hope this helps others.