BUG: Members of Server Role Setupadmin Cannot Add/Drop/Configure Linked Server

• Microsoft SQL Server version 7.0

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:
   
   
   • New Linked Server...
   • Delete
   • Properties

Additional query words: Error 15232

Keywords          : kbbug7.00 kbSQLServ700bug 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: June 1, 1999