SAS Service Name instead of port number using SAS OLAP Provider
Connection string
This SAS OLAP Data Provider connection string can be used for connections to SAS OLAP.
Provider=sas.OLAPProvider;Data Source=lambchop.unx.sas.com;SAS Protocol=2;
SAS Service Name=sasobjspawn;
Make sure that "SAS Port" isn't defined in the connection string as it will override the "SAS Service Name" value.