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


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q197390
BUG #: 53191 (SQLBUG_70)
BUG #: 53254 (SQLBUG_70)

SYMPTOMS

A user who is part of a Setup Administrators (setupadmin) server role are not be able to create a new linked server using SQL Server Enterprise Manager. The menu from the tree for "New Linked Server" is 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.

RESOLUTION

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 that 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.

MORE INFORMATION

Steps to Reproduce the Problem

  1. Create a Login with Server Role of setupadmin.
  2. Register the server in SEM using this login.
  3. Connect to the server in SEM and right-click the Linked Server Name.
  4. The following options are not available:

    • New Linked Server...
    • Delete
    • Properties
Modification Type:MinorLast Reviewed:3/21/2005
Keywords:kbBug KB197390
©2004 Microsoft Corporation. All rights reserved.