permissions problems creating a linked server

I am trying to create a linked server in the management studio and am getting an error

"A required operation could not be completed. You must be a member of the sysadmin role to perform this operation"

I have tried giving the user rights via

GRANT ALTER ANY LINKED SERVER TO [DOM\user]

as well as adding them to the setupadmin group. No luck.

I can add the linked server via sp_addlinkedserver as the user.

Any ideas?After searching some more I came across this.

http://msdn2.microsoft.com/en-us/library/aa560998.aspx

Which states you must be a member of the sysadmin role to create a linked server to do this via the management tools. Any idea why?

When I script the GUI all of the SP's it calls are available to logins with the setupadmin role or who have been granted access to alter any linked server.

Permissions granted for user x are insufficient for performing this operation

Here's the setup:
I've got a RS server set up in a QA domain. When I publish reports to it,
it prompts me for a username and password. I enter the ADMINISTRATOR
account and password and all is well.
I've now set up a RS server in the production domain and I need to publish
my reports to it. I've added my domain account to the Role Assignments with
System Administrator privliges. When I log into RS, I see all of the
relevant administrator options, but when I try to publish a new report via
VS I get the error message: "Permissions granted for user x are
insufficient for performing this operation"
What am I doing wrong?
ThanksYou need to grant the user permission in the correct folder. There is a
default role called Content Manager. Make your user this role in the
appropriate folder.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"troark" <t.roark@.excite.com.n0sp@.m> wrote in message
news:es0Px60nEHA.3868@.TK2MSFTNGP11.phx.gbl...
> Here's the setup:
> I've got a RS server set up in a QA domain. When I publish reports to it,
> it prompts me for a username and password. I enter the ADMINISTRATOR
> account and password and all is well.
> I've now set up a RS server in the production domain and I need to publish
> my reports to it. I've added my domain account to the Role Assignments
with
> System Administrator privliges. When I log into RS, I see all of the
> relevant administrator options, but when I try to publish a new report via
> VS I get the error message: "Permissions granted for user x are
> insufficient for performing this operation"
> What am I doing wrong?
> Thanks
>
>|||DOH! Thanks.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uiFmju1nEHA.2024@.TK2MSFTNGP09.phx.gbl...
> You need to grant the user permission in the correct folder. There is a
> default role called Content Manager. Make your user this role in the
> appropriate folder.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "troark" <t.roark@.excite.com.n0sp@.m> wrote in message
> news:es0Px60nEHA.3868@.TK2MSFTNGP11.phx.gbl...
> > Here's the setup:
> > I've got a RS server set up in a QA domain. When I publish reports to
it,
> > it prompts me for a username and password. I enter the ADMINISTRATOR
> > account and password and all is well.
> >
> > I've now set up a RS server in the production domain and I need to
publish
> > my reports to it. I've added my domain account to the Role Assignments
> with
> > System Administrator privliges. When I log into RS, I see all of the
> > relevant administrator options, but when I try to publish a new report
via
> > VS I get the error message: "Permissions granted for user x are
> > insufficient for performing this operation"
> >
> > What am I doing wrong?
> >
> > Thanks
> >
> >
> >
> >
>

Permissions

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are
insufficient for performing this operation
I am getting this error when I have installed my asp.net application on the
server, it runs fine on my development box, here is the code that is running:
Dim rService As ReportingService = New ReportingService
rService.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim catalogItems As CatalogItem()
catalogItems = rService.ListChildren("/", True)
And it's falling over on the last line, anyone got any ideas?
--
Regards
<<<Bryan Avery>>Have your asp.net application run under different credentials. You can set
these for services on the Log On tab for the services property.
"Bryan Avery" wrote:
> The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are
> insufficient for performing this operation
> I am getting this error when I have installed my asp.net application on the
> server, it runs fine on my development box, here is the code that is running:
> Dim rService As ReportingService = New ReportingService
> rService.Credentials = System.Net.CredentialCache.DefaultCredentials
> Dim catalogItems As CatalogItem()
> catalogItems = rService.ListChildren("/", True)
> And it's falling over on the last line, anyone got any ideas?
> --
> Regards
> <<<Bryan Avery>>|||Hi,
I'm a little unsure what you mean by setting different credentials for the
application, where and how do you set them?
--
Regards
<<<Bryan Avery>>
"Harolds" wrote:
> Have your asp.net application run under different credentials. You can set
> these for services on the Log On tab for the services property.
> "Bryan Avery" wrote:
> > The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are
> > insufficient for performing this operation
> >
> > I am getting this error when I have installed my asp.net application on the
> > server, it runs fine on my development box, here is the code that is running:
> >
> > Dim rService As ReportingService = New ReportingService
> > rService.Credentials = System.Net.CredentialCache.DefaultCredentials
> > Dim catalogItems As CatalogItem()
> > catalogItems = rService.ListChildren("/", True)
> >
> > And it's falling over on the last line, anyone got any ideas?
> >
> > --
> > Regards
> >
> > <<<Bryan Avery>>|||Found the problem to be with web.config file.
Adding the following line under
<authentication mode="Windows" />
<identity impersonate="true" />
And it all springs in to life
--
Regards
<<<Bryan Avery>>
"Bryan Avery" wrote:
> Hi,
> I'm a little unsure what you mean by setting different credentials for the
> application, where and how do you set them?
> --
> Regards
> <<<Bryan Avery>>
>
> "Harolds" wrote:
> > Have your asp.net application run under different credentials. You can set
> > these for services on the Log On tab for the services property.
> >
> > "Bryan Avery" wrote:
> >
> > > The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are
> > > insufficient for performing this operation
> > >
> > > I am getting this error when I have installed my asp.net application on the
> > > server, it runs fine on my development box, here is the code that is running:
> > >
> > > Dim rService As ReportingService = New ReportingService
> > > rService.Credentials = System.Net.CredentialCache.DefaultCredentials
> > > Dim catalogItems As CatalogItem()
> > > catalogItems = rService.ListChildren("/", True)
> > >
> > > And it's falling over on the last line, anyone got any ideas?
> > >
> > > --
> > > Regards
> > >
> > > <<<Bryan Avery>>

Permission problem

I get the following error at times:

The permissions granted to user 'PMS\rforkner' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

The user is me and I am the administrator and owner of the SQL Server 2005 database. SQL Server is running on Windows 2003 Server Enterprise SP1. How is it I don’t have permission to change a change a permission. For the past several days I have added users and set the permissions (in Report Server). What I had done was uncheck Browser for my account and that worked. When I tried to check Browser and OK is when I got the error.

Any ideas, suggestions, or comments are certainly welcome

Roy

Hi RoyAF,
i guess it is possible that when you check Browser (I really don't know the exact place where you do that) you are using another user. It is just as logging with your NT user accnt and surfing by the built-in accnt for IIS; that built-in accnt is NOT admin on the Report Server and this is why you get the error.
I have posted a question on about the same problem - it seems that you must have admin rights on the RS to do anything (including viewing reports).
I am waiting for someone to confirm that this problem goes away if you uninstall SP1 for W2K3.
If you get to talk to anybody and can shed more light, please post back,
thanks,
kowalsky|||kowalsky,
I have full privilages to the server, sql server and of course RS. I have sa rights. The strange thing is, that it worked until I unchecked browser on I had rights then but, a few minutes later when I tried to check browser on built in I no longer had the rights.
It is really frustrating and I have no idea where to get answers other than here. I have posted numerous questions about problems and I have had only 2 answers. Maybe my questions are so easy no one wants to bother answering.
I really like the product and I know it is beta but it seems to work for some; I just wish I could make it work for me.
Roy
|||This is crazy; today all the permission problems have disappeared and all is working as it should. The face that yesterday was a problem and today isn't makes me wonder what is happening.|||

RS has to call out to the Domain Controller to ensure you are who you say you are. If the network connectivity between the DC and RS is unstable, this kind of issue can occur.

Removing the Browser role should not affect your ability to set permissions because the default definition of Browser does not grant you this right.

Hope that helps,

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

Permission problem

I get the following error at times:

The permissions granted to user 'PMS\rforkner' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

The user is me and I am the administrator and owner of the SQL Server 2005 database. SQL Server is running on Windows 2003 Server Enterprise SP1. How is it I don’t have permission to change a change a permission. For the past several days I have added users and set the permissions (in Report Server). What I had done was uncheck Browser for my account and that worked. When I tried to check Browser and OK is when I got the error.

Any ideas, suggestions, or comments are certainly welcome

Roy

Hi RoyAF,
i guess it is possible that when you check Browser (I really don't know the exact place where you do that) you are using another user. It is just as logging with your NT user accnt and surfing by the built-in accnt for IIS; that built-in accnt is NOT admin on the Report Server and this is why you get the error.
I have posted a question on about the same problem - it seems that you must have admin rights on the RS to do anything (including viewing reports).
I am waiting for someone to confirm that this problem goes away if you uninstall SP1 for W2K3.
If you get to talk to anybody and can shed more light, please post back,
thanks,
kowalsky|||kowalsky,
I have full privilages to the server, sql server and of course RS. I have sa rights. The strange thing is, that it worked until I unchecked browser on I had rights then but, a few minutes later when I tried to check browser on built in I no longer had the rights.
It is really frustrating and I have no idea where to get answers other than here. I have posted numerous questions about problems and I have had only 2 answers. Maybe my questions are so easy no one wants to bother answering.
I really like the product and I know it is beta but it seems to work for some; I just wish I could make it work for me.
Roy
|||This is crazy; today all the permission problems have disappeared and all is working as it should. The face that yesterday was a problem and today isn't makes me wonder what is happening.|||

RS has to call out to the Domain Controller to ensure you are who you say you are. If the network connectivity between the DC and RS is unstable, this kind of issue can occur.

Removing the Browser role should not affect your ability to set permissions because the default definition of Browser does not grant you this right.

Hope that helps,

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.