Problem connecting to SAS using OLEDb SAS.IOMprovider

[dondokp]

ErrorWe are trying to access data from a SAS grid using Integrated Windows authentication, single sign on. This works in Visual studio but in PowerBi we get the above error. The client doesn't want to supply credential every time they access a different folder or library. Any help will be appreciated

[v-haibl-msft]

@dondokp

From the error message, it seems that the connection string is not correct. Do you include credential and security related properties in it?

Best Regards,
Herbert

[dondokp]

Hi Herbert

Thanks for your response. The connection string is as follows

Provider=SAS.IOMProvider;Data Source=iom-name://SASApp - Logical Workspace Server;SAS Metadata Location=’iom://MYSERVER:8561;Bridge;SECURITYPACKAGE=Negotiate’

Since we are using Integrated Windows Authentication , is it necessary to put in credentials? In Visual studio we don't have to enter credentials.

Thanks

Kudzayi

[Anonymous]

Any luck solving this?

[Otacon]

This is for a SAS IOM Provider through OLEDB:

First in conetction string put this conection string (your IOM-NAME could be different)

Provider=sas.IOMProvider.9.47; Data Source=iom-name://SASApp - Logical Workspace Server;SAS Port=8561;SAS Protocol=0;SAS Server Type=1;SAS Metadata User ID=xxxx;SAS Metadata Password=xxxx;SAS Metadata Location=[your metadata server];SAS Workspace Init Script="LIBNAME [your libname] '[route]'";

then click on accept

in the next window put the metadata server credentials "SAS Metadata User ID=xxxx;SAS Metadata Password=xxxx"

and click to conect. if everything is fine youll see the datasets in your library listed

Best Regards