locked
401 Not authorised for report server during setup RRS feed

  • Question

  • Hi,

    Im busy with a new install of CRM 4.0 and am getting an error when running a silent install. error:

    0:18:25|  Error| Check ExistingRSValidator : Failure: Setup failed to validate specified Reporting Services Report Server http://SYNCRMSQL01/ReportServer. Error: The request failed with HTTP status 401: Unauthorized.
    The request failed with HTTP status 401: Unauthorized.

     

    I can browse to that address through IE from the CRM app server where im running the install ( i had to add the site to local intranet and disable Intergrated windows authentication in IE) Im trunning the install as a domain admin.

    I am also using the latest setup updates from MS.

    Setup:

    App server is server 2008 R1 woth all pre reqes done

    SQL server is server 2008 R1 with SQL 2008 R2

     

    Config XML:

    <CRMSetup>
    <Server>
    <Patch update="true">c:\crm4_updates\Server_amd64_enu.msp</Patch>
     <LicenseKey>removed</LicenseKey>
    <SqlServer>SYNCRMSQL01</SqlServer>
    <Database create="true"/>
    <Reporting URL="http://SYNCRMSQL01/ReportServer"/>
    <basecurrency isocurrencycode="USD" currencyname="US Dollar" currencysymbol="$" />
    <Organization>organisations</Organization>
    <OrganizationFriendlyName>organisations</OrganizationFriendlyName>
    <OU>OU=organisations,OU=hosted,DC=domain,DC=local</OU>
    <WebsiteUrl>/LM/W3SVC/1</WebsiteUrl>
    <InstallDir>c:\Program Files\Microsoft CRM</InstallDir>
    <CrmServiceAccount type="NetworkService">
    </CrmServiceAccount>
    <SQM optin="false"/>
    <ifdsettings enabled="true">
    <internalnetworkaddress>192.168.*.*-255.255.255.255</internalnetworkaddress>
    <rootdomainscheme>https</rootdomainscheme>
    <sdkrootdomain>removed</sdkrootdomain>
    <webapplicationrootdomain>crmhost.co.uk</webapplicationrootdomain>
    </ifdsettings>
    </Server>
    </CRMSetup>

    crminstall log extract:

    10:18:22|   Info| Check CrmDatabaseFilesValidator: Success
    10:18:22|Verbose| BaseGroup.Validate completed
    10:18:22|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    10:18:22|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    10:18:22|Verbose| After context key substitutions RunModes
    10:18:22|Verbose| After env var substitutions RunModes
    10:18:22|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    10:18:22|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    10:18:22|Verbose| After context key substitutions Setup
    10:18:22|Verbose| After env var substitutions Setup
    10:18:22|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    10:18:22|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Microsoft SQL Server Reporting Services
    10:18:22|Verbose| Calling BaseGroup.Validate
    10:18:22|   Info| Check ReportingUrlValidator: Success
    10:18:25|  Error| Microsoft.Crm.CrmReportingException: The request failed with HTTP status 401: Unauthorized. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
       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.Crm.ReportingServices2005.ReportingService2005.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, SearchCondition[] Conditions)
       at Microsoft.Crm.Reporting.ReportServer.FindItemByName(String searchRoot, String name, ItemTypeEnum itemType)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Reporting.ReportServer.FindItemByName(String searchRoot, String name, ItemTypeEnum itemType)
       at Microsoft.Crm.Reporting.ReportServer.validateRSUrl()
       at Microsoft.Crm.Reporting.ReportServer.validateServer()
       at Microsoft.Crm.Setup.Server.RSInstaller.ValidateExistingRS(IDictionary parameters)
       at Microsoft.Crm.Setup.Server.ExistingRSValidator.InternalCheck(IDictionary parameters)
    10:18:25|  Error| Check ExistingRSValidator : Failure: Setup failed to validate specified Reporting Services Report Server http://SYNCRMSQL01/ReportServer. Error: The request failed with HTTP status 401: Unauthorized.
    The request failed with HTTP status 401: Unauthorized.

    Any help would be great.

     

    Thanks!

    Tuesday, September 14, 2010 9:31 AM

Answers

  • configuration was correct, looks like not compatible with SQL 2008 R2 during setup, have installed SQL2008 and worked first time.
    • Marked as answer by Hiltonh69 Tuesday, September 14, 2010 4:30 PM
    Tuesday, September 14, 2010 4:30 PM

All replies

  • Hi

    Check SQL Server Reporting Services is running under Network Service. On the server click on start than All program than Sql Server 2008 and than Configration Tool and Than Reporting service Configration Manager and click connect. Try to find any issue with configration.

    Regards

    Faisal

     

    Tuesday, September 14, 2010 12:50 PM
  • configuration was correct, looks like not compatible with SQL 2008 R2 during setup, have installed SQL2008 and worked first time.
    • Marked as answer by Hiltonh69 Tuesday, September 14, 2010 4:30 PM
    Tuesday, September 14, 2010 4:30 PM