{"id":7103,"date":"2007-07-25T15:35:00","date_gmt":"2007-07-25T15:35:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2007\/07\/25\/how-to-find-your-analysis-services-server\/"},"modified":"2019-02-14T17:52:23","modified_gmt":"2019-02-15T01:52:23","slug":"how-to-find-your-analysis-services-server","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/how-to-find-your-analysis-services-server\/","title":{"rendered":"How to find your Analysis Services server"},"content":{"rendered":"

If you’re developing custom reports, you need to know the name of the Analysis Services server for Team System so that you can connect to the Team System cube. Typically, AS is deployed on the data tier server. However, it can be moved to another server to get the load off the data-tier server. In fact, that’s a really good practice. If you need to find the Analysis Services server, use the following code. You’ll need to reference Microsoft.TeamFoundation.dll and Microsoft.TeamFoundation.Client.dll. Unfortunately, this code will only work if you have TFS administration rights.<\/p>\n

Allen<\/p>\n

\n

        \/\/\/<\/span> <\/span><summary><\/p>\n

<\/span><\/span><\/p>\n

        \/\/\/<\/span> Returns the AS server name for the specified TFS instance.<\/p>\n

<\/span><\/span><\/p>\n

        \/\/\/<\/span> <\/span><\/summary><\/p>\n

<\/span><\/span><\/p>\n

        \/\/\/<\/span> <\/span><param name=”teamFoundationServerUrl”><\/span>Team Foundation Server URL (i.e. http:\/\/server1:8080).<\/span><\/param><\/p>\n

<\/span><\/span><\/p>\n

        \/\/\/<\/span> <\/span><returns><\/span>AS Server Name.<\/span><\/returns><\/p>\n

<\/span><\/span><\/p>\n

        public<\/span> static<\/span> string<\/span> GetASServerName(string<\/span> teamFoundationServerUrl)<\/p>\n

<\/span><\/p>\n

        {<\/p>\n

<\/span><\/p>\n

            if<\/span> (String<\/span>.IsNullOrEmpty(teamFoundationServerUrl))<\/p>\n

<\/span><\/p>\n

            {<\/p>\n

<\/span><\/p>\n

                throw<\/span> new<\/span> ArgumentException<\/span>(“Argument cannot be null or empty.”<\/span>, “teamFoundationServerUrl”<\/span>);<\/p>\n

<\/span><\/p>\n

            }<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

            string<\/span> toolId = “vstfs”<\/span>;<\/p>\n

<\/span><\/p>\n

            TeamFoundationServer<\/span> tfs = TeamFoundationServerFactory<\/span>.GetServer(teamFoundationServerUrl);<\/p>\n

<\/span><\/p>\n

            IRegistration<\/span> iRegistration = (IRegistration<\/span>)tfs.GetService(typeof<\/span>(IRegistration<\/span>));<\/p>\n

<\/span><\/p>\n

            RegistrationEntry<\/span>[] registrationEntries = iRegistration.GetRegistrationEntries(toolId);<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

            if<\/span> (registrationEntries.Length < 1)<\/p>\n

<\/span><\/p>\n

            {<\/p>\n

<\/span><\/p>\n

                throw<\/span> new<\/span> Exception<\/span>(string<\/span>.Format(“Registration does not have an entry for tool Id “{0}””<\/span>, toolId));<\/p>\n

<\/span><\/p>\n

            }<\/p>\n

<\/span><\/p>\n

            if<\/span> (registrationEntries.Length > 1)<\/p>\n

<\/span><\/p>\n

            {<\/p>\n

<\/span><\/p>\n

                throw<\/span> new<\/span> Exception<\/span>(string<\/span>.Format(“Registration has more than one entry for tool Id “{0}””<\/span>, toolId));<\/p>\n

<\/span><\/p>\n

            }<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

            Database<\/span>[] databases = registrationEntries[0].Databases;<\/p>\n

<\/span><\/p>\n

            Database<\/span> database = null<\/span>;<\/p>\n

<\/span><\/p>\n

            for<\/span> (int<\/span> i = 0; i < databases.Length; i++)<\/p>\n

<\/span><\/p>\n

            {<\/p>\n

<\/span><\/p>\n

                if<\/span> (string<\/span>.Compare(“BISANALYSIS DB”<\/span>, databases[i].Name, StringComparison<\/span>.OrdinalIgnoreCase) == 0)<\/p>\n

<\/span><\/p>\n

                {<\/p>\n

<\/span><\/p>\n

                    database = databases[i];<\/p>\n

<\/span><\/p>\n

                    break<\/span>;<\/p>\n

<\/span><\/p>\n

                }<\/p>\n

<\/span><\/p>\n

            }<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

            if<\/span> (database == null<\/span>)<\/p>\n

<\/span><\/p>\n

            {<\/p>\n

<\/span><\/p>\n

                throw<\/span> new<\/span> Exception<\/span>(string<\/span>.Format(“Registration for tool Id “{0}” does not have a database entry with name “BISANALYSIS DB” “<\/span>, toolId));<\/p>\n

<\/span><\/p>\n

            }<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

            return<\/span> database.SQLServerName;<\/p>\n

<\/span><\/p>\n

        }<\/span><\/p>\n

<\/span><\/p>\n<\/div>\n

<\/p>\n

 <\/p>\n

<\/span><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

If you’re developing custom reports, you need to know the name of the Analysis Services server for Team System so that you can connect to the Team System cube. Typically, AS is deployed on the data tier server. However, it can be moved to another server to get the load off the data-tier server. In […]<\/p>\n","protected":false},"author":125,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7103","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops"],"acf":[],"blog_post_summary":"

If you’re developing custom reports, you need to know the name of the Analysis Services server for Team System so that you can connect to the Team System cube. Typically, AS is deployed on the data tier server. However, it can be moved to another server to get the load off the data-tier server. In […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/7103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/125"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=7103"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/7103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=7103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=7103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=7103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}