Lazy programming from MS? Surely not…

Another vignette from SQL Server 2005 Management Studio showing a possible lack of attention to detail somewhere…

(Speaking of lack of attention to detail, I can’t remember which version of the SSMS had this bug.  I suspect it was RTM, but cannot recall if it was fixed by SP3…)

The situation: A user was logged in who wasn’t a member of the sysadmin role, but did have the required permissions to add linked server. The user tried to open the add a Linked Server dialog, but was presented with the following error message:

Cannot show requested dialog

As a reminder, you don’t need to be Sysadmin in order to add linked servers, but you do need to have been granted the appropriate rights, in this instance “ALTER ANY LINKED SERVER”.

Assuming you do have the right privileges, and you still can’t get to the right dialog box, then you’ll need to know the following SQL Server stored procedures:

Get it wrong, and you’ll need to know your way around the rest of the linked server procedures, so here’s the list.

Have fun!

This entry was posted in SQLServerPedia Syndication, Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.