- You create a new SQL Server login ID and then assign the login ID as the owner of a database on a Microsoft SQL Server 2012 instance.
- You log in to the SQL Server 2012 instance by using the new login ID.
- You try to view properties of a database in the SQL Server 2012 instance.
Cannot show requested dialog. (SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch.
The user does not have permission to perform this action. (Microsoft SQL Server, Error: 297)
When you click Database Properties, SQL Server Management Studio (SSMS) runs queries against the following dynamic management views (DMVs):
Cumulative update information
SQL Server 2012The fix for this issue was first released in Cumulative Update 2 for SQL Server 2012 Service Pack RTM. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 2714785 - Last Review: 19 Nov 2012 - Revision: 1