February 28, 2013 at 11:37 am
I try to build for first time the OLAP Cube and show me this error
oCBSOlapProcessingFailure (17004) - Failed to process the Analysis Services database DatabaseName on the n01wdpjs01 server. Error: Internal error: The operation terminated unsuccessfully. Server: The operation has been cancelled. OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; 28000; Cannot open database "ProjectServer_Reporting" requested by the login. The login failed.; 42000. 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 'DatabaseName' database was being processed. . Details: id='17004' name='CBSOlapProcessingFailure' uid='2a5d679a-5a15-4457-afcc-b96198f51199' QueueMessageBody='Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=n01wdpjs01 ASDBName=DatabaseName ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=12/26/2012 00:00:00 ToDate=12/26/2012 00:00:00 HighPriority=True' Error='Failed to process the Analysis Services database DatabaseName on the n01wdpjs01 server. Error: Internal error: The operation terminated unsuccessfully. Server: The operation has been cancelled. OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; 28000; Cannot open database "ProjectServer_Reporting" requested by the login. The login failed.; 42000. 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 'DatabaseName' database was being processed. '.
Some Idea how correct this?
Regards
February 28, 2013 at 7:58 pm
You are running AS as the "NETWORK SERVICE" account and this does not, currently, have permission to acces the Proj Svr database.
You have a few options
- change the connection string in the data source for the cube so that it uses a SQL Login that has permission
- change the service account that you are using for AS so that it runs with an account that has permission
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply