{"id":5664,"date":"2013-10-17T19:59:05","date_gmt":"2013-10-17T17:59:05","guid":{"rendered":"https:\/\/ingmarverheij.com\/?p=5664"},"modified":"2013-10-21T12:25:33","modified_gmt":"2013-10-21T10:25:33","slug":"microsoft-app-v-5-0-lost-administrative-access","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/microsoft-app-v-5-0-lost-administrative-access\/","title":{"rendered":"Microsoft App-V 5.0 – Lost administrative access"},"content":{"rendered":"

\"2013-10-16<\/a>In case you\u2019re locked out of your Microsoft App-V 5.0 Management Server – because the account \/ group is removed , you\u2019re not a member of the group or because you don\u2019t know which account was specified during installation<\/em> – you will receive an error message:\u00a0 You do not have access to this information. Please check your credentials.<\/strong><\/p>\n

Fortunately, regaining access to the App-V management server is pretty easy.<\/p>\n

<\/p>\n

Who\u2019s authorized?<\/h1>\n

During the installation of the first<\/strong> Management Server an active directory group or account is specified<\/strong> that is authorized<\/strong> to manage App-V.\u00a0 Unless you\u2019ve added other groups or accounts this is the only account that\u2019s authorized to administer<\/strong> Microsoft App-V.<\/p>\n

\"Microsoft<\/a><\/p>\n

<\/h1>\n

ManagementDB<\/h1>\n

Fortunately the role<\/strong> assignments<\/strong> are stored in the Management<\/strong> Database<\/strong> on the SQL, making it easy to regain access. All you need is the Microsoft SQL Management Studio (or similar) and browse to the App-V management database (typically AppVManagement <\/strong>when installed via the installer or AppVirtManagement <\/strong>when installed via script) and edit the table [RoleAssignments].<\/strong><\/p>\n

Here you can see the SID <\/strong>of the Active Directory object <\/strong>that\u2019s authorized <\/strong>to manage App-V, using PowerShell (for instance) you can determine which account a SID belongs to (see Microsoft TechNet<\/a>), However. the easiest way to regain access is to add your users SID <\/strong>to the table and assign the role <\/strong>\u201cADMIN\u201d.\u00a0 The table has the following columns:<\/p>\n\n\n\n\n\n\n\n
Column<\/strong><\/td>\nDescription<\/strong><\/td>\nValues<\/strong><\/td>\n<\/tr>\n
Id<\/strong><\/td>\nUnique identifier of the record<\/td>\nAutomatically filled by SQL<\/em><\/td>\n<\/tr>\n
RoleName<\/strong><\/td>\nThe name of the role<\/td>\nADMIN \u2013 Administrative access<\/td>\n<\/tr>\n
Sid<\/strong><\/td>\nThe secure unique identifier of the Active Directory object<\/td>\nS-1-5-21-\u2026.. A quick method of determining your SID (and groups) is using WhoAmI<\/strong><\/a><\/td>\n<\/tr>\n
AccountType<\/strong><\/td>\nThe type of the Active Directory object<\/td>\n0 \u2013 Group
\n1 \u2013 Account<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"Microsoft<\/a><\/p>\n

That\u2019s it, no restart is needed.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

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

In case you\u2019re locked out of your Microsoft App-V 5.0 Management Server – because the account \/ group is removed , you\u2019re not a member of the group or because you don\u2019t know which account was specified during installation – you will receive an error message:\u00a0 You do not have access to this information. Please […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[294],"tags":[],"class_list":["post-5664","post","type-post","status-publish","format-standard","hentry","category-microsoft-app-v"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/5664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=5664"}],"version-history":[{"count":3,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/5664\/revisions"}],"predecessor-version":[{"id":5668,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/5664\/revisions\/5668"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=5664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=5664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=5664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}