{"id":912,"date":"2015-08-26T09:47:51","date_gmt":"2015-08-26T14:47:51","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=912"},"modified":"2015-08-26T09:47:51","modified_gmt":"2015-08-26T14:47:51","slug":"ssas-lost-security-context","status":"publish","type":"post","link":"https:\/\/cognitiveinfo.com\/?p=912","title":{"rendered":"SSAS Lost security context"},"content":{"rendered":"<p>I recently logged into an SSAS server and was unable to add a user to the server security. Worse yet, the Security Properties tab was not showing domain user names, just SID&#8217;s. This means the service has lost connectivity to resolve SID&#8217;s with the domain.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-919 size-medium\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2015\/08\/SSAS_lost_security-300x268.png\" alt=\"SSAS_lost_security\" width=\"300\" height=\"268\" \/><\/p>\n<p>The solution today was to run SSMS as Administrator, domain admin that is. Once connected the domain administrator account is able to remove the disconnected SID&#8217;s and add back the proper accounts.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-920 size-medium\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2015\/08\/SSMS_run_as_Admin-300x193.jpg\" alt=\"SSMS_run_as_Admin\" width=\"300\" height=\"193\" \/><\/p>\n<p>On other occasions I have seen the security tab empty, meaning there is no recognized administrators. To resolve that issue, stop the service and edit the msmdsrv.ini file. In that file, you can set the property BuiltinAdminsAreServerAdmins which will recognize admins on the box as admin on the the SSAS Service. After a service stop\/restart you can add\/edit\/remove admins using SSMS.<\/p>\n<p>For more info about that, see <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms174556.aspx\">MSDN<\/a>.<\/p>\n<p>Sometimes I blog these things just so I will remember it a few months from now.\u00a0 Hope this helps you too.<\/p>\n<p>-Allen<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SSAS lost security context in the domain and is showing SID&#8217;s in the Security properties.  How to fix it.<\/p>\n","protected":false},"author":2,"featured_media":919,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[85,100],"class_list":["post-912","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ssas","tag-security","tag-ssas"],"_links":{"self":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=912"}],"version-history":[{"count":0,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/912\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}