大网数据广告活动
启动与系统组件

Removing VMM service account from the db_owner role causes login failures for end users

· 52CE 我爱测

This article describes an issue that removing the VMM service account from the db_owner role in the VMM database causes login failures for end users.

This article describes an issue that removing the Virtual Machine Manager (VMM) service account from the db_owner role in the VMM database causes login failures for end users.

Original product version:   Microsoft System Center 2012 R2 Virtual Machine Manager, System Center 2012 Virtual Machine Manager
Original KB number:   3087868

Summary

System Center 2012 Virtual Machine Manager setup creates a login for the VMM service account and adds it to db_owner role in the VMM database. Membership in the db_owner role is required for the VMM service account. Removing the account from the db_owner role triggers login failures for end users.

Assigning any combination of roles with lesser permissions and individual permissions instead of db_owner for the VMM service account isn't supported.

More information

When a user connects to VMM through the console or a command shell, the VMM service dynamically adds the user to the VMM database. When the user disconnects, the VMM service automatically removes the user from the VMM database.

As a connected user performs actions, the VMM service runs EXECUTE AS statements to run database stored procedures on the user's behalf. For it to work, the VMM service account must have the IMPERSONATE permission on the user. Non-dbo users don't have this permission.

You can't work around this limitation by explicitly granting the IMPERSONATE permission to a non-dbo service account because you can grant IMPERSONATE only on an existing principal. Because the VMM service dynamically adds and removes database users, you can't grant IMPERSONATE permissions on them ahead of time. The user must exist at the time you grant permissions.

The SQL Server language reference specifically documents the requirement that a principal must exist when the IMPERSONATE permission is granted to the principal. For more information, see Specifying a User or Login Name.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 04/09/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。