Solved

Can't run Sage software

Posted on 2014-07-18
12
577 Views
Last Modified: 2015-01-13
Windows Server 2012R2 Essentials plus Server 2012R2 Application server.
The App server has SQL 2012 and Sage 300 (Accpac) installed.
PC's have Windows 8.1 Pro connected to the domain.
Sage 300 is a 32Bit app installed in Workstation mode. So SQL data on the server. Common shared folder with licenses, user data and so on. The program folder is mapped back to the server using UNC. Folders shared to everyone with full rights.

When I start up Sage 300 it opens ok. But if I select anything from the menu it comes up with the UAC warning.
I say YES I want to allow this to run.
It comes up with security warning "Windows has blocked this software because it can't verify the publisher" etc, etc. The file points back to the OCX on the server.
I have been through many Google suggestions and they all seem to come up with the same solution of making changes to Active-X in the Security settings. I have done this.
I removed the app and installed on the PC as Admin. It seems better if I run as Admin but still comes up with the same error.
I am looking for other suggestions to overcome this or remove the security completely. The network is Isolated (as much as one can isolate) so I am not concerned about Virus/Malware etc.
0
Comment
Question by:Alex Angus
  • 6
  • 6
12 Comments
 
LVL 11

Expert Comment

by:Forrest Burris
ID: 40205067
"IF" you're not worried about security, why not completely disable UAC? I can't think of a TS app server I've ever built out that I/we've left UAC on?

However if you want it to work with your current UAC setting then you will have to use signtool in order to verify the app. The software must be digitally signed with a valid certificate

http://social.msdn.microsoft.com/Forums/windowsdesktop/en-US/a674d011-6d4d-43d0-9a3b-ea8143a44716/how-do-i-change-verified-publisher-unknown-to-verified-publisher-my-name-goes-here-in-the?forum=windowssecurity

http://technet.microsoft.com/en-us/library/cc733026.aspx
0
 

Author Comment

by:Alex Angus
ID: 40205241
UAC is already turned off (slider right at the bottom).
0
 
LVL 11

Expert Comment

by:Forrest Burris
ID: 40205252
Ok so UAC is set to 'Never Notify' yes? UAC usually wants a reboot when it's changed. Please verify?
0
Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

 

Author Comment

by:Alex Angus
ID: 40205257
Yes, booted a few times since.
0
 
LVL 11

Expert Comment

by:Forrest Burris
ID: 40205337
Is Sage web based? Are you trying to access it through an internet browser? It's possible there is a sub-component of the app that is also using an browser based active-x control. Or is it a stand alone client application? Could be your Internet Options? Do you have any UAC group policies enabled on your domain?

1. Open internet explorer, click Tools – Internet Options .
2. Click the Security tab – Custom Level button.
Under ActiveX ensure the following are set to enabled
Run ActiveX and plug-ins – Enabled
Download Signed ActiveX Control – Enabled
Script ActiveX controls marked as safe for scripting – Enabled
Set the following to “Prompt ”
Download unsigned ActiveX Control – Prompt
Initialize and script ActiveX controls not mark as safe – Prompt
3. Click OK and Apply and OK. Restart the browser.
0
 
LVL 11

Expert Comment

by:Forrest Burris
ID: 40205351
0
 

Author Comment

by:Alex Angus
ID: 40205358
As mentioned above:
"
I have been through many Google suggestions and they all seem to come up with the same solution of making changes to Active-X in the Security settings. I have done this."

So I have done this. It makes no difference.
0
 
LVL 11

Expert Comment

by:Forrest Burris
ID: 40205393
My apologies for not reading this as clearly as I should have. Have you manually registered the offending .ocx file(s) popping up with the alert message? From the run command or a DOS prompt:

Regsvr32 filename.ocx
0
 

Author Comment

by:Alex Angus
ID: 40206666
Yes. They are registered on installation but there is also a utility that does this in case there is a problem. So I have run the register utility a few times again. The log is clear indication all registrations were successful.
Then reboot and retry.
Same.

I was wondering if this was not an Essentials related problem?

I loaded the programs locally as a test. Still comes up wuth UAC warning but if you accept it then goes away and the screen works. This means that I have to do this for about 600 screens, one by one.

It looks like the only solution is to install Server 2008 and Windows 7. Then one does not get this problem.
0
 

Author Comment

by:Alex Angus
ID: 40207415
Removed everything from workstation.
Made sure registry was clean.
Restarted. Made sure all firewalls were off. Both server and workstation. Disabled anti-virus.
Did workstation install.
Rebooted. Firewalls still off but anti-virus back on.
Made sure first run was as administrator.
Seems to be working so far.
0
 
LVL 11

Accepted Solution

by:
Forrest Burris earned 500 total points
ID: 40209113
Excellent it sounds like you were able to resolve the issue. Well done. I hope testing remains positive
0
 

Author Comment

by:Alex Angus
ID: 40213821
Not out of the woods yet.
The error/warning still comes up on certain functions.
Have sent the details to the software manufacturers to see what they come up with.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Know what services you can and cannot, should and should not combine on your server.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question