_Pero_


Hi,

I have question concerning DW and OLAP. I had DW database on SQL 2000 Server and I created AS 2005 OLAP cube. During deployment I got error, that I cannot deploy. Then I move DW DB to SQL Server 2005 on the same server as AS 2005. Then deployment worked.

So, is it possible to have DW on different server as OLAP, or has to be same 2005 server




Re: DW & OLAP Server

Francesco De Chirico


Hi,

yes, you can have your DW on a server and OLAP on different server.

Can you give more details about your problem with the deployment in the initial situation






Re: DW & OLAP Server

mr_e_dub

Coming to grips with the way that MSAS handles credentials and processing is a challenge when first starting out. I'll try to go over what i understand and save you some time.

When you create data sources in MSAS try and make (if at all possible) a concerted effort not to use windows authentication. Until you come to grips with how the MSAS service uses credentials once something is deployed, you'll be pulling your hair out trying to figure it out.

If you can, make SQL server accounts and use those users names and passwords for the data sources. These will be used by the AS service on the server to which it's deployed.

T
he way that impersonation information (on the data source property dialog) tab is set up is confusing to say the least, and it kind of leads you to think that those settings will work for a projects ultimate deployment desination. Which it doesn't. Avoid the confusion by leaving the option set to default.

When processing a remotely deployed solution, the activity takes place under the account credentials used by the Analysis Services Service itself. If you leave your data sources set to windows authenticationon the remote system will try to authenticate against your data source with the credentials of the service, not your credentials.

Generally the Analysis Services Service runs under one of the system accounts, or a domain service account. Generally these (for good reason) accounts don't have access to databases, and any process activity relying on windows authentication will fail.

Hope this Helps.


-Eric





Re: DW & OLAP Server

_Pero_

I will try with separate servers, but first have to configure server properly

I think problem was with security.