BUG: SetupAdmin Member Not Allowed to Add Linked Server in SEM

ID: Q197390


The information in this article applies to:

BUG #: 53191 (SQLBUG_70)

SYMPTOMS

A user who is part of a Setup Administrators (setupadmin) server role will not be able to create a new linked server using SQL Server Enterprise Manager. The menu from the tree for "New Linked Server" will be unavailable in SQL Server Enterprise Manager. In addition, if the user right-clicks an existing linked server, the Delete and Properties commands are missing from the shortcut menu.


WORKAROUND

To work around this problem, you can use existing stored procedures to add, drop, or configure the linked servers.

For more information, see the SQL Server 7.0 Books Online.


STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: SEM MMC grey gray greyed grayed out dim dimmed
linkedserver linkedservers linkserver linkservers


Keywords          : SSrvAdmin SSrvEntMan kbbug7.00 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 21, 1999