You should post this to a SQL Server group. sp_addlinkedserver requires "ALTER ANY LINKED SERVER" permission. Try granting that to the user and see if he/she can work with sp_addlinkedserver.
On Wed, Oct 1, 2008 at 4:46 PM, Alex <[EMAIL PROTECTED]> wrote: > > Hello, > > In MS SQL 2005 I need to give a user access to sp_addlinkedserver and > sp_addlinkedsrvlogin so he can connect to another server within a > stored procedure, but I need to do this without putting him in the > sysadmin or setupadmin group. I looked at GRANT first, but MSDN > specifically says this can't be used unless the user is in the > sysadmin group. > > Any ideas on how to set this up without opening up the entire server? > > Thanks -- > > Alex > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx <p><a href="http://feeds.feedburner.com/DotNetDevelopment";><img src="http://feeds.feedburner.com/~fc/DotNetDevelopment?bg=99CCFF&fg=444444&anim=1"; height="26" width="88" style="border:0" alt="" /></a></p> -~----------~----~----~----~------~----~------~--~---
