| Groups | Blog | Home |
sql server reporting services : Setting admin rights to Report Manager, SQL Server Express 2005, V
I'm a newbie to Reporting Services so please forgive my ignorance... I've recently installed SQL Server Express 2005 with Reporting Services on my Vista Business Notebook (with no network connections) and have installed VS C# Express as well as the Business Intelligence Studio to create reports. My C# application can connect to SQL Server fine, however, the reports I created with Business Studio refuses to deploy to the server due to the following reason: "The permissions granted to user 'localhost\Jenny' are insufficient for performing this operation". I find this odd as I've been able to deploy reports on my other Windows XP machine (with SQL Server Express) no probs at all. Additionally, I cannot see the 'Site settings' link within Report Manager (Web) that I'd normally get with an admin account (i.e. on my Win. XP machine). Various sources indicate that my account has insufficient access rights to view this. Having browsed through seemingly endless blogs and forums, I suspect that my local account has not been configured to access the Report Manager web client to publish, manage and administer the site. I have tried the surface area tool for SQL Server, but I suspect that this is relevant only to SQL Server DB access and management. Adding an administrator here does nothing. The question is, how can I grant access to myself (local account) to allow me to publish reports via business studio, and at the same time - administer Report Manager Site Settings - on my vista notebook?? I would be extremely grateful for any help on this matter - I've tried ceaseless reinstallations, but to no avail! Many thanks in advance, Jenny
I, too, would like the answer to this question because it is exactly what I'm
seeing. I'm running SQL 2005 Developer Edtion on Vista. After installing SQL 2005 SP 2, Reporting Services now functions, but by default my login does not have any access to the Reporting Server. I can view the Report Manager and Reports web sites, but I'm unable to do anything. I'm still looking for a solution to this issue, and if I find something, I'll post the results here. Chris [quoted text, click to view] "Jenny" wrote:
> Hi all, > > I'm a newbie to Reporting Services so please forgive my ignorance... > > I've recently installed SQL Server Express 2005 with Reporting Services on > my Vista Business Notebook (with no network connections) and have installed > VS C# Express as well as the Business Intelligence Studio to create reports. > > My C# application can connect to SQL Server fine, however, the reports I > created with Business Studio refuses to deploy to the server due to the > following reason: > > "The permissions granted to user 'localhost\Jenny' are insufficient for > performing this operation". > > I find this odd as I've been able to deploy reports on my other Windows XP > machine (with SQL Server Express) no probs at all. Additionally, I cannot > see the 'Site settings' link within Report Manager (Web) that I'd normally > get with an admin account (i.e. on my Win. XP machine). Various sources > indicate that my account has insufficient access rights to view this. > > Having browsed through seemingly endless blogs and forums, I suspect that my > local account has not been configured to access the Report Manager web client > to publish, manage and administer the site. > > I have tried the surface area tool for SQL Server, but I suspect that this > is relevant only to SQL Server DB access and management. Adding an > administrator here does nothing. > > The question is, how can I grant access to myself (local account) to allow > me to publish reports via business studio, and at the same time - administer > Report Manager Site Settings - on my vista notebook?? > > I would be extremely grateful for any help on this matter - I've tried > ceaseless reinstallations, but to no avail! > > > Many thanks in advance, > > Jenny
Well, I'm logged in as an Admin, and I'm a sysadmin on SQL, so I'm not sure,
how I could run IE at a higher security setting. The main issue for me is simply that as a member of the built-in Administrator's group, I don't appear to have any access to SSRS beyond viewing the folders. So, I can't add logins to roles and I can't add or modify reports. I've also added my IIS server to my trusted sites in IE. Chris [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> I haven't done this but I was told the following: "only gotcha is that you > need to run IE as administrator else you don't see the SSRS toolbar" > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Christopher Robin" <ChristopherRobin@discussions.microsoft.com> wrote in > message news:A2F81309-B3F1-4309-B827-5DF36B92F934@microsoft.com... > > I, too, would like the answer to this question because it is exactly what > > I'm > > seeing. I'm running SQL 2005 Developer Edtion on Vista. After installing > > SQL 2005 SP 2, Reporting Services now functions, but by default my login > > does > > not have any access to the Reporting Server. I can view the Report > > Manager > > and Reports web sites, but I'm unable to do anything. > > > > I'm still looking for a solution to this issue, and if I find something, > > I'll post the results here. > > > > Chris > > > > "Jenny" wrote: > > > >> Hi all, > >> > >> I'm a newbie to Reporting Services so please forgive my ignorance... > >> > >> I've recently installed SQL Server Express 2005 with Reporting Services > >> on > >> my Vista Business Notebook (with no network connections) and have > >> installed > >> VS C# Express as well as the Business Intelligence Studio to create > >> reports. > >> > >> My C# application can connect to SQL Server fine, however, the reports I > >> created with Business Studio refuses to deploy to the server due to the > >> following reason: > >> > >> "The permissions granted to user 'localhost\Jenny' are insufficient for > >> performing this operation". > >> > >> I find this odd as I've been able to deploy reports on my other Windows > >> XP > >> machine (with SQL Server Express) no probs at all. Additionally, I > >> cannot > >> see the 'Site settings' link within Report Manager (Web) that I'd > >> normally > >> get with an admin account (i.e. on my Win. XP machine). Various sources > >> indicate that my account has insufficient access rights to view this. > >> > >> Having browsed through seemingly endless blogs and forums, I suspect that > >> my > >> local account has not been configured to access the Report Manager web > >> client > >> to publish, manage and administer the site. > >> > >> I have tried the surface area tool for SQL Server, but I suspect that > >> this > >> is relevant only to SQL Server DB access and management. Adding an > >> administrator here does nothing. > >> > >> The question is, how can I grant access to myself (local account) to > >> allow > >> me to publish reports via business studio, and at the same time - > >> administer > >> Report Manager Site Settings - on my vista notebook?? > >> > >> I would be extremely grateful for any help on this matter - I've tried > >> ceaseless reinstallations, but to no avail! > >> > >> > >> Many thanks in advance, > >> > >> Jenny > >> > >
I haven't done this but I was told the following: "only gotcha is that you
need to run IE as administrator else you don't see the SSRS toolbar" -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Christopher Robin" <ChristopherRobin@discussions.microsoft.com> wrote in message news:A2F81309-B3F1-4309-B827-5DF36B92F934@microsoft.com... [quoted text, click to view] > I, too, would like the answer to this question because it is exactly what > I'm > seeing. I'm running SQL 2005 Developer Edtion on Vista. After installing > SQL 2005 SP 2, Reporting Services now functions, but by default my login > does > not have any access to the Reporting Server. I can view the Report > Manager > and Reports web sites, but I'm unable to do anything. > > I'm still looking for a solution to this issue, and if I find something, > I'll post the results here. > > Chris > > "Jenny" wrote: > >> Hi all, >> >> I'm a newbie to Reporting Services so please forgive my ignorance... >> >> I've recently installed SQL Server Express 2005 with Reporting Services >> on >> my Vista Business Notebook (with no network connections) and have >> installed >> VS C# Express as well as the Business Intelligence Studio to create >> reports. >> >> My C# application can connect to SQL Server fine, however, the reports I >> created with Business Studio refuses to deploy to the server due to the >> following reason: >> >> "The permissions granted to user 'localhost\Jenny' are insufficient for >> performing this operation". >> >> I find this odd as I've been able to deploy reports on my other Windows >> XP >> machine (with SQL Server Express) no probs at all. Additionally, I >> cannot >> see the 'Site settings' link within Report Manager (Web) that I'd >> normally >> get with an admin account (i.e. on my Win. XP machine). Various sources >> indicate that my account has insufficient access rights to view this. >> >> Having browsed through seemingly endless blogs and forums, I suspect that >> my >> local account has not been configured to access the Report Manager web >> client >> to publish, manage and administer the site. >> >> I have tried the surface area tool for SQL Server, but I suspect that >> this >> is relevant only to SQL Server DB access and management. Adding an >> administrator here does nothing. >> >> The question is, how can I grant access to myself (local account) to >> allow >> me to publish reports via business studio, and at the same time - >> administer >> Report Manager Site Settings - on my vista notebook?? >> >> I would be extremely grateful for any help on this matter - I've tried >> ceaseless reinstallations, but to no avail! >> >> >> Many thanks in advance, >> >> Jenny >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |