Solved

Can't run Sage software

Posted on 2014-07-18
12
502 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:alexangus
  • 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:alexangus
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:alexangus
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:alexangus
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:alexangus
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:alexangus
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:alexangus
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

743 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

12 Experts available now in Live!

Get 1:1 Help Now