OLAP, Analysis Services Questionssubmit your own question
trying to connect to remote Microsoft Sql (ssas) but connection not opening
I am trying to connect to remote Microsoft sqlServer 2016 Enterprise(ssas) using Visual Studio 2015 community. using (AdomdConnection conn = new AdomdConnection(@";Initial Catalog=CCAnalytics;Data Source=APPSWORLD\MSSQL;User ID=madhubabu;Password=sasa;Provider=MSOLAP.7;"))
Dynamic Application Name in OLEDB/ODC Connection String
I have several (more than 100) Excel reports (files) that use the same data connection file. The data connection file connects to SSAS 2012 Tabular Model.
CS for unencrypted, uncompressed HTTP for tracing
Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;Protection Level=connect;Transport Compression=None;Protocol Format=XML;
- Load more posts