Re: The user does not have permission to perform this action.
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 14 Sep 2006 06:52:58 +0000 (UTC)
kalaivanan (mail2kalai@xxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- References:
- The user does not have permission to perform this action.
- From: kalaivanan
- The user does not have permission to perform this action.
- Prev by Date: Re: Flattening Parent Child, an issue, please help
- Next by Date: Re: Recurring Scheduled Job
- Previous by thread: The user does not have permission to perform this action.
- Next by thread: SQLRef - Website Created by Programmer to Programmers
- Index(es):
Relevant Pages
|
