Error: Cannot show requested dialog. A required operation could not be completed. You must be a member of the sysadmin role to perform this operation.


Error: Cannot show requested dialog (SqlMgmt). A required operation could not be completed. You must be a member of the sysadmin role to perform this operation. (SqlManagerUI)

Description: Again another connectivity issue where the user name using having no permission or rights to complete the operation. Or, we can say the user is a normal or standard user.

Solution: Select and right-click Logins from Security node, from Properties window select Server Roles and select sysadmin check box.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s