• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 892
  • Last Modified:

Can't run Sage software

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
Alex Angus
Asked:
Alex Angus
  • 6
  • 6
1 Solution
 
Forrest BurrisCommented:
"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
 
Alex AngusDirectorAuthor Commented:
UAC is already turned off (slider right at the bottom).
0
 
Forrest BurrisCommented:
Ok so UAC is set to 'Never Notify' yes? UAC usually wants a reboot when it's changed. Please verify?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Alex AngusDirectorAuthor Commented:
Yes, booted a few times since.
0
 
Forrest BurrisCommented:
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
 
Alex AngusDirectorAuthor Commented:
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
 
Forrest BurrisCommented:
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
 
Alex AngusDirectorAuthor Commented:
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
 
Alex AngusDirectorAuthor Commented:
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
 
Forrest BurrisCommented:
Excellent it sounds like you were able to resolve the issue. Well done. I hope testing remains positive
0
 
Alex AngusDirectorAuthor Commented:
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now