BookmarkSubscribeRSS Feed
MariaD
Barite | Level 11

Hi Guys, 

 

We have SAS installed on Linux, 9.4M7 on a grid. We have some users that connected from PowerBI to SAS using OLE DB connection string for a while. Yesterday, without any change on the SAS server, the connection string started to fail to connect. 

 

We tested the IOM Bridge connection using SAS Integration Technologie Wizard and the same error occurred.

 

Screenshot 2023-10-17 at 09.07.16.png

 

We don't have any problem connecting using SAS EG. We tested in several users' machines with several logins and the same error appeared.

 

Any idea?

 

Regards,  

3 REPLIES 3
SASKiwi
PROC Star

Can you post the connection string you are using? Also you can test the Workspace Server IOM bridge connection in SAS Management Console by right-clicking on the connection and selecting Test Connection:

SASKiwi_0-1697596059622.png

 

 

MariaD
Barite | Level 11

Hi guys, 

 

After some tries, we connected using PBI desktop but not PBI Gateway (personal mode). The string is the same, but in PBI gateway request again the credentials and timeout occur. We found this Microsoft note, but even when selecting anonymous authentication the error persists. 

 

String:

 

provider=sas.IOMProvider.9.44;data source='iom-name://SASApp - Logical Workspace Server";sas cell cache size=10000;sas machine dns name=XXXXX;sas port=8591;sas protocol=2;sas server type=1;sas metadata user id=YYY;sas metadata password=ZZZZ;sas metatada location:RRRRRR:8561

 

 

Regards,

SASKiwi
PROC Star

I'd suggest progressing your issue with SAS Tech Support as it looks like more troubleshooting is required. 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 453 views
  • 0 likes
  • 2 in conversation