none
PS2010 - error building an OLAP Cube with SQL Server 2012. RRS feed

  • Question

  • I deployed Project Server 2010 SP1 + CU Feb 2013 in three servers:

    Server 1: WFE

    Server 2: Application Server and Central Admin

    Server 3: SQL Server 2012 and AS 2012 

    Also I deployed correctly the SQL Feature Pack for SQL Serve 2008 R2 (in order to install the AMO objects...)

    When I build an OLAP cube I received this error message:

    Nombre del SSP: Project Service Application
    PSError: CBSOlapProcessingFailure (17004)
    Cube build failed during an OLAP Processing operation. CBS queued message: Setting UID=3bf00dae-a42e-4ff1-a456-da74a94e0b32 ASServerName=SSJSED3082 ASDBName=EPM_TEST2 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/16/2013 12:47:35 ToDate=05/16/2013 12:47:35 HighPriority=True. Error: Error al procesar la base de datos de Analysis Services EPM_TEST2 en el servidor SSJSED3082. Error: OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Status Date' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Type' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Currency' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Resource Is Active', Name of 'Resource Is Active' was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Category Name' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Company Name' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Keywords' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Timesheet Project List', Name of 'Timesheet Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Timesheet Project List attribute' attribute of the 'Timesheet Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Resource Status', Name of 'Resource Status' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Start Date' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task Is Critical', Name of 'Task Is Critical' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Resource Base Calendar', Name of 'Resource Base Calendar' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Finish Date' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Booking Type', Name of 'Booking Type' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Timesheet Class', Name of 'Timesheet Class' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Manager' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.

    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-SharePoint Products-Project Server" Guid="{B2178104-1B5B-4C20-8C8F-960678CED9E5}" />
        <EventID>7691</EventID>
        <Version>14</Version>
       
    <Level>2</Level>

        <Task>11</Task>
        <Opcode>0</Opcode>
        <Keywords>0x4000000000000000</Keywords>
        <TimeCreated SystemTime="2013-05-23T14:27:39.729576600Z" />
        <EventRecordID>142234</EventRecordID>
        <Correlation ActivityID="{BE656D9E-BCD6-4457-A3B0-84BDA1AE4C15}" />
        <Execution ProcessID="4788" ThreadID="1220" />
        <Channel>Application</Channel>
        <Computer>SSJSED3081.acueductospr.local</Computer>
        <Security UserID="S-1-5-21-3733407615-1996751439-133379066-23396" />
      </System>
      <EventData>
        <Data Name="string0">Punto de entrada de PSI:
    Usuario de Project: ACUEDUCTOSPR\srvd-spservices
    Id. de correlación: be656d9e-bcd6-4457-a3b0-84bda1ae4c15
    Sitio de PWA: http://ssjsed3080:90/PWA
    Nombre del SSP: Project Service Application
    PSError: CBSOlapProcessingFailure (17004)</Data>
        <Data Name="string1">Setting UID=3bf00dae-a42e-4ff1-a456-da74a94e0b32 ASServerName=SSJSED3082 ASDBName=EPM_TEST2 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/16/2013 12:47:35 ToDate=05/16/2013 12:47:35 HighPriority=True</Data>
        <Data Name="string2">Error al procesar la base de datos de Analysis Services EPM_TEST2 en el servidor SSJSED3082. Error: OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Status Date' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Type' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Currency' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Resource Is Active', Name of 'Resource Is Active' was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Category Name' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Company Name' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Keywords' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Timesheet Project List', Name of 'Timesheet Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Timesheet Project List attribute' attribute of the 'Timesheet Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Resource Status', Name of 'Resource Status' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Start Date' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task Is Critical', Name of 'Task Is Critical' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Resource Base Calendar', Name of 'Resource Base Calendar' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Finish Date' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Booking Type', Name of 'Booking Type' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Timesheet Class', Name of 'Timesheet Class' was being processed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Project Manager' attribute of the 'Project List' dimension from the 'EPM_TEST2' database was being processed.
    </Data>
      </EventData>
    </Event>


    What can I review or do?

    I reviewed all the administrative accounts and everything it seems OK.

    Regards and thank you in advance.

    Pedrof.-



    Pedrof.-

    Thursday, May 23, 2013 2:44 PM

All replies

  • Hi Pedrof,

    Following error indicates to me some issue with connectivity

    Check if instance name is correct and if SQL Server is configured to allow remote connections

    Are you using named instance?


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Thursday, May 23, 2013 3:45 PM
    Moderator
  • Hi Hrisri,

    Thank you again for your help! (it is very appreciated)

    Yes, I checked it... Sql is configure to allow remote connections.

    Also I ran cliconfg.exe and I verified that TCP and Named Pipes are enabled.

    I thought following these links:

    http://geekswithblogs.net/BobHardister/archive/2011/12/09/tfs-2010-cube-processing-odbc-error.aspx
    http://blogs.msdn.com/b/jsocha/archive/2011/05/27/fixing-cube-processing-odbc-errors.aspx

    The Solution

    Here is what I did:
    •Change the service account for Analysis Services from a domain account to Local System.
    •Restart SSAS

    After that, everything started to work just fine. I then set the service account back to the domain account, using the updated password, and everything is continuing to run correctly. What I didn’t try, and what may work just fine, is to simply restart the Analysis Services service. If I run into this error again, I’ll try that fix (I’ve had reports from some other people that restarting the service is enough to fix this problem).

    What do you think as a possible solution to fix this issue? (Because it is very similar)

    Regards,

    Pedrof.-


    Pedrof.-

    Thursday, May 23, 2013 3:51 PM
  • Pedrof,

    Running SSAS service with local account is not recommended, especially if you have database and AS on separate box. Since you have both on the same system local account worked for you.

    Yes, after you make changes to the Security on AS, you have to restart the service.

    Hope this helps.


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Thursday, May 23, 2013 4:07 PM
    Moderator
  • Hi Hrishi,

    Database and AS are in the same box.

    After to do it.. I will restart all these services.

    I will let you know...:-) (I hope that this solve it!)

    Regards,

    Pedrof.-


    Pedrof.-

    Thursday, May 23, 2013 4:16 PM
  • Hi,

    Unfortunately, I'm havingthe same problem andremains unsolved...(I followed that previous steps...)

    This is the error message in the event viewer log:

    Standard Information:Punto de entrada de PSI:
    Usuario de Project: XXXX\pedro.fraile
    Id. de correlación: f25c4594-163a-45f0-bb2a-e49a4cf2beca
    Sitio de PWA: http://projectsite:90/PWA
    Nombre del SSP: Project Service Application
    PSError: CBSOlapProcessingFailure (17004)
    Cube build failed during an OLAP Processing operation. CBS queued message: Setting UID=3bf00dae-a42e-4ff1-a456-da74a94e0b32 ASServerName=SSJSED3082 ASDBName=EPM_TEST2 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/16/2013 12:47:35 ToDate=05/16/2013 12:47:35 HighPriority=True. Error: Error al procesar la base de datos de Analysis Services EPM_TEST2 en el servidor SSJSED3082. Error: OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Issue Priority', Name of 'Issue Priority' was being processed.
    Server: The current operation was cancelled because another operation in the transaction failed.
    OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Issue Created Date', Name of 'Issue Created Date' was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task Is Active', Name of 'Task Is Active' was being processed.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Risk Trigger Task', Name of 'Risk Trigger Task' was being processed.

    Any more idea how could I resolve this?

    Kind regards,

    pedrof.-


    Pedrof.-

    Thursday, June 6, 2013 9:05 AM
  • Pedrof:

    Does the account that you are using to run Analysis Services have public role and datareader rights on the Project Server Reporting database? This is the most common reason for this error, but there a number of hoops you have to jump through to get this to work on 2012.


    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG


    Tuesday, June 11, 2013 9:10 PM
    Moderator
  • Hi Gary,

    Yes, I checked it... the account that I am using is an administrative account...(sysadmin) in SQL Server and AS.

    Regards,

    Pedrof.-


    Pedrof.-

    Tuesday, June 11, 2013 11:14 PM
  • SysAdmin doesn't cut it and I assume you know that is a very bad practice. Once upon a time the SysAdmin role would have worked, but secuirty is tighter in the newer generations of SQL server. Give the service account public role and datareader rights explicitly and report your results.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG

    Wednesday, June 12, 2013 2:11 PM
    Moderator
  • Pedrof,

    I am really interested to know whether your issue has been resolved or not


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Monday, June 24, 2013 6:02 PM
    Moderator
  • Not yet...

    Pedrof.-

    Monday, June 24, 2013 7:28 PM
  • What version do you have of the following and SP

    SqL server

    Project Server

    native SQL client

    SQL ADO

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Monday, June 24, 2013 11:07 PM
    Moderator