Errors while trying to deploy my first cube

Question

Hi,

I am trying to deploy my first cube to a SSAS Server.

My datasource and datasource view are pointing to a different sql server..

The Database used for the datasource and datasource are not located in the box where SSAS is loaded? -- Do i need to load the database in that box?

i have created a Analaysis server project on my local computer and i have set the project properties to point to the Box where i have my test analysis server.

When i try to deploy my project i get the following errors:
Error 2 Internal error: The operation terminated unsuccessfully. 
I checked the sql configuration manager and the network configuration for the shared Memory and Tcp/IP are enabled and the Named pipes and the VIA are disabled 
  Client configuration -- Shared memory, Tcp/ip, named pipes are enabled and VIA is disabled


Error 3 Server: The operation has been cancelled. 

Error 4 OLE DB error: OLE DB or ODBC error: Login failed for user "servername"; 42000.  
Am I getting this error because my database doesnt exists in this box... when i went to deploy the project it didnt ask me for any credentials...


Error 5 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'CI Report Cube', Name of 'CI Report Cube'.  -- Datasource ID is been pointed to a different sql server box and the my test server doesnt have this database loaded
Do I need to load the database in here??


Error 6 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Tbl Report Fact Count Consumer Demog 1', Name of 'consumer_Demog_county' was being processed.  


I have also heard that first you need to process the dimension and then the cubes..
IF i hit deploy does it process the cubes too?? and right now my datasource is pointing to a production server and if i hit process would it affect the production server or would it just process the cube on the test server...

Any help will be appreciated

Thanks,
Karen

Answer 1

Hi,

I would start with checking the credentials of the service account running Analysis Services. Is that a domain account that has read permissions in the data source?

BR
Thomas Ivarsson

Answer 2

but my datasource and the Analysis services are on 2 different machines.. does that matter??

Answer 3

Yes that matters.

You will need a domain account for the Analysis Services services to access data on another server.

BR
Thomas Ivarsson

Answer 4

Thomas,

thanks for the answer to i am going to back up that database and load it into the same box where my analysis Server resides...

Answer 5

Thomas,

thanks for the answer to i am going to back up that database and load it into the same box where my analysis Server resides...

That will make security a little easier, but if you look at error 4, it appears you are trying to login to the server as "servername".  That's like me walking up to you and saying "Hi, my name is Personname".  So I think you have an issue in your connection string or something.

Answer 6

Tha_thyrant i changed the name of the server to servername to protect the server names identity... lol

Answer 7

Tha_thyrant i changed the name of the server to servername to protect the server names identity... lol

LOL ok now I feel stupid.  Still, sometimes you just don't know!