Error: report service the connectionstring property has not been

Error when trying to access SQL Server Reporting Services 

    • On my reporting service webpage, I can access my SCCM reporting services 100% - no password prompts and no errors.

      On that same page, i can 'Forefront Endpoint Protection XXX' and I can view the reports to run.  But when I actually run the reports, I prompt for username and password.    After I enter username and pw (or even domain\username and pw), I receive this error...

      • An error has occurred during report processing. (rsProcessingAborted)
        • Cannot create a connection to data source 'DefaultDataSource'. (rsErrorOpeningConnection)
          • The ConnectionString property has not been initialized.

      How can I get this to be like my SCCM web reporting service, no password and working reports?

       

      Wednesday, April 06, 2011 4:00 PM
      |
      |
       
       
      Avatar of c_kubie
      c_kubie
      a company
       
      5 Points
       
 

All replies

    • Question
      Sign in to vote
      0
      Sign in to vote

      Do the execution account have read access to the database?

      Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
      Wednesday, April 06, 2011 5:29 PM
      |
      |
       
       
      Avatar of Kent Agerlund
      Kent Agerlund
      Coretech A/S
      (MCC, Partner, MVP)
      72,776 Points
       
 
 
    • Question
      Sign in to vote
      0
      Sign in to vote

      I found this and followed it to a 100%, no luck.   I have multiple accounts with db_datareader for both FEPDB and FEPDW databases. http://support.microsoft.com/default.aspx?scid=kb;EN-US;2428400

      I don't have impersonate account configured for the working 'ConfigMgr-xxx' reports, besides it fails when I enter all credentials including the sql server service credentials.

      Are there any SQL logs I can view to check what its failing on? 
      Anyway of confirming the SQL settings its using?  (Maybe it isn't seeing the database (moved reporting server 1 month ago, but it is working perfectly for SCCM reports)

       

      Wednesday, April 06, 2011 9:23 PM
      |
      |
       
       
      Avatar of c_kubie
      c_kubie
      a company
       
      5 Points
       
 
    • Question
      Sign in to vote
      0
      Sign in to vote

      After much searching and testing, I found my Database Connection is not correct.
      I went to http://dbserver/reportserver
      Then browsed to /Forefront Endpoint Protection_XXX/Datasources/DefaultDataSource

      It opend with this

      - <DataSourceDefinition>
        <Extension>SQL</Extension>
        <UseOriginalConnectString>True</UseOriginalConnectString>
        <OriginalConnectStringExpressionBased>False</OriginalConnectStringExpressionBased>
        <CredentialRetrieval>Prompt</CredentialRetrieval>
        <WindowsCredentials>True</WindowsCredentials>
        <Prompt>E2nter a user name and password to access the data source:</Prompt>
        <Enabled>True</Enabled>
        </DataSourceDefinition>
       
      I check my working SCCM data source and found this
      - <DataSourceDefinition>
        <Extension>SQL</Extension>
        <ConnectString>Data Source=dbserver;Initial Catalog=SMS_CHI;Integrated Security=true</ConnectString>
        <UseOriginalConnectString>False</UseOriginalConnectString>
        <OriginalConnectStringExpressionBased>False</OriginalConnectStringExpressionBased>
        <CredentialRetrieval>Store</CredentialRetrieval>
        <WindowsCredentials>True</WindowsCredentials>
        <ImpersonateUser>False</ImpersonateUser>
        <UserName>Domain\SQLService</UserName>
        <Enabled>True</Enabled>
        </DataSourceDefinition>
       
      So i edited the properties of one of the reports and added the datasource string 
      Data Source=dbserver;Initial Catalog=FEPDW_CHI;Integrated Security=true
       
       
      It displays the formating of the reports but no data...
      I'll create a new post with the next error message, I wanted to update this topic in case someone searches this post. 
      Thursday, April 07, 2011 6:22 PM
      |
      |
       
       
      Avatar of c_kubie
      c_kubie
      a company
       
      5 Points
       
 
posted @ 2013-09-26 16:21  邹邹  Views(868)  Comments(0)    收藏  举报