A little late to the party but I used the following string to connect:
provider=sas.IOMProvider.9.45;data source=demo;sas port=8591;sas protocol=2;sas metadata user id=domain\userid;sas metadata password=PassWord;sas metadata location=demo:8561;
provider=sas.IOMProvider.9.45;
data source=server;
sas port=8591;
sas protocol=2;
sas metadata user id=domain\userid;
sas metadata password=PassWord;
sas metadata location=server:8561;
Hope it helps.
... View more