Can you tell me how to do this? Sorry - I dont have experience adding a user to roles on Reporting Services.
Thanks, On Thu, Oct 8, 2009 at 7:55 PM, Geoff Orr <[email protected]> wrote: > Try adding TFSSetup to all roles on Reporting Services. > > Geoff > > ------------------------------ > Date: Thu, 8 Oct 2009 16:39:10 -0500 > Subject: Re: TFS 2008 > > From: [email protected] > To: [email protected] > > I created a user account of TFSSETUP. This user has Administrator access. > Do I need to do anything in SQL Server in terms of security or login or > roles? Or is the error happening on the Windows Server side? I am unclear. > > Thanks for your help, > Oscar Bautista > > > On Thu, Oct 8, 2009 at 4:29 PM, Geoff Orr <[email protected]> wrote: > > Check that the service or domain user that is running tfs is a browser and > content provider in RS. > > Geoff Orr > > ------------------------------ > Date: Thu, 8 Oct 2009 15:13:12 -0500 > Subject: TFS 2008 > From: [email protected] > To: [email protected] > > > I recently installed TFS 2008 on Windows Server 2008. My installation > included: > > .Net Framework 3.5 SP1 > SQL Server 2008 SP1 > WSS 3.0 > TFS 2008 Power Tools - October 2008 > Team Explorer > > I am trying to create a Team Project on TFS through Team Explorer. I am > getting the error message below. Can anyone help point me in the right > direction? > > > *2009-10-08 14:43:44Z | Module: Internal | Team Foundation Server proxy > retrieved | Completion time: 0 seconds > 2009-10-08 14:43:44Z | Module: Internal | The template information for Team > Foundation Server "CTS01" was retrieved from the Team Foundation Server. | > Completion time: 0.009765 seconds > 2009-10-08 14:43:44Z | Module: Wizard | Retrieved IAuthorizationService > proxy | Completion time: 0 seconds > 2009-10-08 14:43:44Z | Module: Wizard | TF30227: Project creation > permissions retrieved | Completion time: 0.0048825 seconds > 2009-10-08 14:45:26Z | Module: Engine | Thread: 5 | New project will be > created with the "MSF for Agile Software Development - v4.2" methodology > 2009-10-08 14:45:26Z | Module: Engine | Retrieved IAuthorizationService > proxy | Completion time: 0 seconds > 2009-10-08 14:45:26Z | Module: Engine | TF30227: Project creation > permissions retrieved | Completion time: 0.0068355 seconds > 2009-10-08 14:45:26Z | Module: Engine | Wrote compressed process template > file | Completion time: 0 seconds > 2009-10-08 14:45:27Z | Module: Engine | Extracted process template file | > Completion time: 1.3426875 seconds > 2009-10-08 14:45:27Z | Module: Engine | Thread: 5 | Starting Project > Creation for project "TeamWebServices" in domain "CTS01" > 2009-10-08 14:45:27Z | Module: Engine | The user identity information was > retrieved from the Group Security Service | Completion time: 0.007812 > seconds > 2009-10-08 14:45:27Z | Module: Initializer | Thread: 5 | The New Team > Project Wizard is starting to initialize the plug-ins. > 2009-10-08 14:45:27Z | Module: CssStructureUploader | Thread: 5 | Entering > Initialize in CssStructureUploader > 2009-10-08 14:45:27Z | Module: CssStructureUploader | Thread: 5 | > Initialize for CssStructureUploader complete > 2009-10-08 14:45:27Z | Module: Initializer | Thread: 5 | The New Team > Project Wizard successfully Initialized the plug-in > Microsoft.ProjectCreationWizard.Classification. > 2009-10-08 14:45:27Z | Module: Rosetta | Thread: 5 | Entering Initialize in > RosettaReportUploader > ---begin Exception entry--- > Time: 2009-10-08 14:45:27Z > Module: Initializer > Event Description: TF30207: Initialization for plugin > "Microsoft.ProjectCreationWizard.Reporting" failed > Exception Type: Microsoft.TeamFoundation.Client.PcwException > Exception Message: TF30224: Failed to retrieve projects from the report > server. Please check that the SQL Server Reporting Services Web and Windows > services are running and you have sufficient privileges for creating a > project. > Exception Details: The Project Creation Wizard encountered a problem while > creating reports on the SQL Server Reporting Services on CTS01. > The reason for the failure cannot be determined at this time. > Because the operation failed, the wizard was not able to finish > creating the SQL Server Reporting Services site. > Stack Trace: > at > Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.CheckForProjectFolder(PrivateData > data, String projectName, ProjectCreationContext context) > at > Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.Initialize(ProjectCreationContext > context) > at > Microsoft.VisualStudio.TeamFoundation.EngineStarter.InitializePlugins(MsfTemplate > template, PcwPluginCollection pluginCollection) > -- Inner Exception -- > Exception Type: System.Web.Services.Protocols.SoapException > Exception Message: System.Web.Services.Protocols.SoapException: The > permissions granted to user 'CTS01\TFSSETUP' are insufficient for performing > this operation. ---> > Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The > permissions granted to user 'CTS01\TFSSETUP' are insufficient for performing > this operation. > at > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListChildren(String > Item, Boolean Recursive, CatalogItem[]& CatalogItems) > at > Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String > Item, Boolean Recursive, CatalogItem[]& CatalogItems) > SoapException Details: <detail><ErrorCode xmlns=" > http://www.microsoft.com/sql/reportingservices";>rsAccessDenied</ErrorCode><HttpStatus > xmlns="http://www.microsoft.com/sql/reportingservices";>400</HttpStatus><Message > xmlns="http://www.microsoft.com/sql/reportingservices";>The permissions > granted to user 'CTS01\TFSSETUP' are insufficient for performing this > operation.</Message><HelpLink xmlns=" > http://www.microsoft.com/sql/reportingservices";> > http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.2531.0</HelpLink><ProductName > xmlns="http://www.microsoft.com/sql/reportingservices";>Microsoft SQL > Server Reporting Services</ProductName><ProductVersion xmlns=" > http://www.microsoft.com/sql/reportingservices";>10.0.2531.0</ProductVersion><ProductLocaleId > xmlns="http://www.microsoft.com/sql/reportingservices";>127</ProductLocaleId><OperatingSystem > xmlns="http://www.microsoft.com/sql/reportingservices";>OsIndependent</OperatingSystem><CountryLocaleId > xmlns="http://www.microsoft.com/sql/reportingservices";>1033</CountryLocaleId><MoreInformation > xmlns="http://www.microsoft.com/sql/reportingservices";><Source>ReportingServicesLibrary</Source><Message > msrs:ErrorCode="rsAccessDenied" msrs:HelpLink=" > http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.2531.0"; > xmlns:msrs="http://www.microsoft.com/sql/reportingservices";>The > permissions granted to user 'CTS01\TFSSETUP' are insufficient for performing > this operation.</Message></MoreInformation><Warnings xmlns=" > http://www.microsoft.com/sql/reportingservices"; /></detail> > Stack Trace: > at > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage > message, WebResponse response, Stream responseStream, Boolean asyncCall) > at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String > methodName, Object[] parameters) > at > Microsoft.TeamFoundation.Proxy.Reporting.ReportingService.ListChildren(String > Item, Boolean Recursive) > at > Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.CheckForProjectFolder(PrivateData > data, String projectName, ProjectCreationContext context) > -- end Inner Exception -- > --- end Exception entry --- > > 2009-10-08 14:45:27Z | Module: Engine | Thread: 5 | Attempting to delete > MSF folder "I:\Users\TFSSETUP\AppData\Local\Temp\2\TPW_tmp2CD5.tmp" > 2009-10-08 14:45:27Z | Module: Engine | Thread: 5 | The temporary folder > I:\Users\TFSSETUP\AppData\Local\Temp\2\TPW_tmp2CD5.tmp used to store the > process template was removed. > * > > > > ------------------------------ > Click Here View photos of singles in your > area<http://clk.atdmt.com/NMN/go/150855801/direct/01/> > > _______________________________________________ > oztfs mailing list > [email protected] > http://prdlxvm0001.codify.net/mailman/listinfo/oztfs > > > > ------------------------------ > Find out how here Get Hotmail on your > iPhone<http://windowslive.ninemsn.com.au/article.aspx?id=845706> > > _______________________________________________ > oztfs mailing list > [email protected] > http://prdlxvm0001.codify.net/mailman/listinfo/oztfs > >
_______________________________________________ oztfs mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/oztfs
