Another vignette from SQL Server 2005 Management Studio showing a possible lack of attention to detail somewhere…
(Speaking of lack of attention to detail, I can’t remember which version of the SSMS had this bug. I suspect it was RTM, but cannot recall if it was fixed by SP3…)
The situation: A user was logged in who wasn’t a member of the sysadmin role, but did have the required permissions to add linked server. The user tried to open the add a Linked Server dialog, but was presented with the following error message:
As a reminder, you don’t need to be Sysadmin in order to add linked servers, but you do need to have been granted the appropriate rights, in this instance “ALTER ANY LINKED SERVER”.
Assuming you do have the right privileges, and you still can’t get to the right dialog box, then you’ll need to know the following SQL Server stored procedures:
- sp_addlinkedserver – to create the new linked server entry
- sp_addlinkedsrvlogin – to assign non-default users to the linked server
Get it wrong, and you’ll need to know your way around the rest of the linked server procedures, so here’s the list.