Microsoft KB Archive/197390

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

Article ID: 197390

Article Last Modified on 3/21/2005

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.



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:


 * 1) * New Linked Server...
 * 2) * Delete
 * 3) * Properties

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

Keywords: kbbug kbpending KB197390

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.