topic SAS Add-in wont start with user rights but will start with admin rights in Microsoft Integration with SAS

SAS Add-in wont start with user rights but will start with admin rights

jimbocalvo — Mon, 05 Feb 2018 13:47:37 GMT

Hi, I have deployed SAS Add-in for Microsoft Office v7.14 to my users via SCCM. When they start Word or Excel and the add-in is observed loading on the splash screen, we get "SAS Add-in for Microsoft Office has encountered a problem".

Word will eventually load, after clicking close on the error box, but the addins are not in the ribbon.

If I start Word with admin rights, the addins load and word starts with the addin in the ribbon.

We have Windows 10, Office 365 C2R and SAS Add-in 7.14. I have attached the error dump. We also have AppSense in our environment as well.

any advice would be appreciated.

thanks,

James

Re: SAS Add-in wont start with user rights but will start with admin rights

jimbocalvo — Mon, 05 Feb 2018 14:11:39 GMT

Just as a follow up to some more testing, we get the same error when we run word with an account that isnt in AppSense.

Re: SAS Add-in wont start with user rights but will start with admin rights

nhvdwalt — Tue, 06 Feb 2018 06:01:12 GMT

Have you tried to enable logging ?

http://support.sas.com/kb/56/743.html

Re: SAS Add-in wont start with user rights but will start with admin rights

TimBeese — Wed, 07 Feb 2018 19:05:22 GMT

Hi James,

One of the scenarios that can cause this is if the bitness of the Office product does not match the bitness of the SAS Add-In. I would suggest checking your Office installation on the machine to see if it is 32 or 64 bit Office. Then, make sure that your SAS Add-In was installed with the same bitness.

A common mistake is that someone will have a 64-bit machine, but the default Office installations are still 32-bit applications.

Tim Beese

Re: SAS Add-in wont start with user rights but will start with admin rights

jimbocalvo — Wed, 07 Feb 2018 20:03:51 GMT

Hi, we are using 32bit Office 365. I will just add though that if I start Word or Excel with elevated rights, the add-in loads normally. If the bitness was an issue would it give me the error when running with elevated and non-elevated permissions?

Re: SAS Add-in wont start with user rights but will start with admin rights

TimBeese — Wed, 07 Feb 2018 21:12:05 GMT

You're right, if the add-in was installed with the wrong bitness, then it wouldn't matter if the user had admin rights or not, it would be giving this error.

I'm not familiar with the difference between running the install with SCCM vs using the SAS Deployment Wizard, so I'm not much help on that front.

As for the error that you're getting, another thing that could cause that would be if the Microsoft Visual C++ 2015 Redistributable (x86) was not available to the user. it seems odd that this would only be available for a user with admin rights and not for the regular user, but it's a thought. Is this component installed on the machine?

If this doesn't help, you could open a track with SAS Technical support and they can assist with further diagnosis to try and find out which component is not available.

Re: SAS Add-in wont start with user rights but will start with admin rights

Damo — Wed, 28 Feb 2018 13:47:56 GMT

Hi @jimbocalvo

Not sure if you're still experiencing the problem reported some weeks ago.

Did you try to use the Switcher utility as per Problem Note 52058 (If SAS® Add-In for Microsoft Office is installed with provisioning software, the SAS® menu is missing and the installation is incomplete) ?

Hope that helps.

Cheers,
Damo

Re: SAS Add-in wont start with user rights but will start with admin rights

jimbocalvo — Wed, 28 Feb 2018 15:02:55 GMT

Thanks Damo, I will give this a try