Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Can't run Sage software

Posted on 2014-07-18
12
Medium Priority
?
807 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 1500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

783 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