An issue occurs in SAS Financial Management Add-in for Microsoft Excel 5.62 where your initial login attempt fails, but your second login attempt succeeds. 

In a SAS^® 9.4M8 (TS1M8) environment where HTTPS is configured, your first login attempt to the (SAS 9.4M8) SAS Financial Management Add-in for Microsoft Excel 5.62 client fails with the following error:

(401) Unauthorized 

This issue occurs when you configure HTTPS with the SASENVIRONMENTSURL=FILE option in the sassw.config file.

Here is an example:

SASENVIRONMENTSURL=file:///c:/temp/sas-environment.xml

Note errors similar to the following can also be displayed when this issue occurs:

VSTA_Main: Entered getServiceTicket
VSTA_Main: ticketGrantingTicket
VSTA_Main: serviceUrl https://middle-tier:443/SASWIPClientAccess/rest/
VSTA_Main: final http call restUrl is
--------------- EXCEPTION REPORT ---------------
Login failure.
System.Net.WebException: The remote server returned an error: (401) Unauthorized.
at System.Net.HttpWebRequest.GetResponse()
at SAS.FM.Common.CommonServerProvider.getRestServices(String restUrl, String credentials)
at SAS.FM.Common.CommonServerProvider.getRestServiceRegistryUrl(String restRegistryUrl, String credentials)
at SAS.FM.Common.CommonServerProvider.authenticate(ServiceURLInformation sui, String userId, String password, String& infoMsg)
at SAS.FM.Common.LogonDlg.retrieveLogonInformation(Boolean envSpecified, String key, String userHost, Int32 userPort, Boolean userSecure, String userName, String password)
at SAS.FM.Common.LogonDlg.btnOK_Click(Object sender, EventArgs e)

HTTPS configuration previously worked in the SAS^® 9.4M7 (TS1M7) SAS^® Financial Management 5.61 environment.

There is no workaround for this issue.