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;"))
I am trying to connect to remote Microsoft Sql Server 2016 Enterprise using Visual Studio Express 2013 Web.
My connection string sample is :
using (AdomdConnection conn = new AdomdConnection(@"Provider=MSOLAP.4;Persist Security Info=True;User ID=madhubaabu;Password=sasa;Initial Catalog=CCAnalytics;Data Source=APPSWORLD\MSSQL;"))
It is failing with this error :
Additional information: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running.
is this correct?orelse what is the correct approach to write this.
In my remote server my SQL Browser is running but i am unable to find exact error. Can anybody help to this problem how to write AdomdConnection(connection to remote server)