locked
How do I connect to SSAS instance without SQL Browser services started? RRS feed

  • General discussion

  • [This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.]

    Answer:
    By default SSAS uses the TCP port 2383 (the configured port is 0).  SQL Server Browser Services uses the TCP port 2382 for redirecting client requests to the correct Analysis Services instance. However if SQL Server Browser Services is not started or not allowed to start by company security policy when a client tries to establish a connection, it cannot locate the SSAS instance. To resolve this issue, you need to explicitly specify the TCP port in your connection string in your client.
    For example:

     AdomdConnection cn = new AdomdConnection("Data Source=myASserver:2383;Initial Catalog=ASTest;Integrated Security=SSPI;");
          try
          {
            cn.Open();
            MessageBox.Show("Succeed!");
          }
          catch (Exception ex)
          {
            MessageBox.Show(ex.ToString());
          }
          finally
          {
            cn.Close();
          }
    

    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Thursday, June 24, 2010 5:04 AM