SAS AddIn Excel | Not show Server

[MariaD]

Hi folks,

We have a user that, from one day to another, when tried to open a Data on SAS AddIn in Excel shows only SAS Folder. The Server to select libname, that not appears. She also use SAS EG and everything works fine on SAS EG.

Thanks,

[AnandVyas]

Hi @MariaD 

Is this scenario only for a single user or all users? If it is for a single user, can you compare the permissions in SMC for this user with others?

[JuanS_OCS]

Hello @MariaD ,

I would suspect there is a problem in Firewall and/or registration of the COM components. Indeed, I would check if this issue happens only for this user, or more. Is this a virtualized client (Citrix/AppV...) or is it a local installation?

I would definitely try to enable the logging for this client, restart the client and try again the operation, to check the log afterwards: https://support.sas.com/kb/56/743.html

[MariaD]

For now, happens only for one user. Until last week, the user has not problem.

Regards,

[JuanS_OCS]

I can imagine well that something changed from the infra side. The answers to the questions above would help to filter and surround the issue.

[DanielKaiser]

I would do two things:

1) Go to %APPDATA%\SAS and rename the SAS-Folder. Then try again.

2) Go to Excel --> Options --> AddIns --> COM AddIns and delete the SAS AddIn. Then go to the Installationdirectory of your Add-In and execute the SwitcherUtility.exe to reinstall the COM-Addin. Then try again.