Solved

Can't run Sage software

Posted on 2014-07-18
12
532 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
 

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
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…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

911 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now