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

• Microsoft SQL Server version 7.0

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.

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