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

ID: Q197390

The information in this article applies to:

Microsoft SQL Server version 7.0

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.

You can create a linked server definition by using sp_addlinkedserver.

You can use sp_linkedservers to view information about the linked servers defined in a given SQL Server.

You can use sp_dropserver to delete a linked server definition. NOTE: You can also use this stored procedure to remove a remote server.

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