Microsoft KB Archive/224511

-

The information in this article applies to:


 * Microsoft SQL Server version 7.0

-

BUG #: 53254 (SQLBUG_70)

SYMPTOMS
Members of the Server Role setupadmin cannot add, drop or configure linked servers through SQL Enterprise Manager (SEM).

WORKAROUND
Members of setupadmin role can use T-SQL stored procedures to add, drop or configure linked servers.

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:


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

Additional query words: Error 15232

Keywords : kbbug7.00 kbSQLServ700bug

Version : winnt:7.0

Platform : winnt

Issue type : kbbug