Posted by Erland Sommarskog on 09/14/06 06:52

kalaivanan (mail2kalai@gmail.com) writes:
> I am getting the following error while trying to add a remote server.
>
> The user does not have permission to perform this action.
>
> The command i used is:
> exec sp_addlinkedserver 'remote_server_name'
>
> What is the solution?

Books Onlines says about permissions for sp_addlinkedsever:

Execute permissions default to members of the sysadmin and setupadmin
fixed server roles.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Recurring Scheduled Job
• Prev in forum: Re: Flattening Parent Child, an issue, please help
• Thread view: Re: The user does not have permission to perform this action.

[Reply to this message]