Permission on sp_addlinkedserver

Hello, I've used sp_addlinkedserver to link an Access database to my SQL
Server 2000 and then move the data into SQL Server. I had been using the
SQLService account to give me the permissions I needed to get it working. I
now want to set the permissions for another account to run this process.
Does anyone now what permissions you need to run the sp_addlinked server.
Also, the errors never occured when you initially link the access file but
when you try to reference it later.
Thanks
Don
"Don" <Don@.discussions.microsoft.com> wrote in message
news:6D5F6F76-E09E-40D0-A64E-66E039F70CE1@.microsoft.com...
> Hello, I've used sp_addlinkedserver to link an Access database to my SQL
> Server 2000 and then move the data into SQL Server. I had been using the
> SQLService account to give me the permissions I needed to get it working.
I
> now want to set the permissions for another account to run this process.
> Does anyone now what permissions you need to run the sp_addlinked server.
From BOL:
Permissions
Execute permissions default to members of the sysadmin and setupadmin fixed
server roles.

> Also, the errors never occured when you initially link the access file but
> when you try to reference it later.
Have you checked the sp_addlinkedsrvlogin proc that allows you to map logins
to remote servers?
Steve