Error while processing cube

Hi All,
I keep on getting the following error while processing a cube in SSAS
2005:
Connection could not be established to the Data Source with
DataSourceID <my_data_source_name>
I don't understand why as my project deployement completed successfully
and a "Test Connection" of my Data Source returns a "Test connection
succeeded"
My user is 'sa' so I don't think rights are a problem here.
Does someone have any idea on this ?
Thanks in advance
Eric
Hello esl,
This error is more than likely caused by the Analysis Services service
account not having the permissions to connect to your data source. This
happens when you use windows authentication for the data source
connection and the AS2005 service is running under local system
account.
Try to run the Analysis Services with a windows account that has rights
to connect to your data source. The cube should then process.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com
|||Hello Myles,
you're right it was indeed a problem with the impersonation account I
used for the data source.
I know use the service account which I have given required permissions
(domain +db) and it works fine.
Many Thanks for your help !
Eric

Error while processing cube

Hi All,
I keep on getting the following error while processing a cube in SSAS
2005:
Connection could not be established to the Data Source with
DataSourceID <my_data_source_name>
I don't understand why as my project deployement completed successfully
and a "Test Connection" of my Data Source returns a "Test connection
succeeded"
My user is 'sa' so I don't think rights are a problem here.
Does someone have any idea on this ?
Thanks in advance
EricHello esl,
This error is more than likely caused by the Analysis Services service
account not having the permissions to connect to your data source. This
happens when you use windows authentication for the data source
connection and the AS2005 service is running under local system
account.
Try to run the Analysis Services with a windows account that has rights
to connect to your data source. The cube should then process.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com|||Hello Myles,
you're right it was indeed a problem with the impersonation account I
used for the data source.
I know use the service account which I have given required permissions
(domain +db) and it works fine.
Many Thanks for your help !
Eric

error while creating new sql server login.

May be there are multiple domains in your LAN and a two
way trust relationships are established among them.
Possibly one of the domains was a test domain which no
longer exist, thats why you are getting this error.
What happens after this error ? Are you able to add users
from the current domain? As long as you can see users from
your current domain it should be fine.
hth.

>--Original Message--
>while trying to create a new sql server login getting the
follwing error:
>"You may not be able to browse all of the domains to
which you have access
>because the following error occurred: Cou;d not find
domain controller for
>this domain."
>what can be the possible cause of this error?
>thanks in advance.
>regards,
>harshal
>
>.
>no I am not able to add users from the current domain.
<anonymous@.discussions.microsoft.com> wrote in message
news:13c3b01c3f7c1$91046900$a401280a@.phx
.gbl...
> May be there are multiple domains in your LAN and a two
> way trust relationships are established among them.
> Possibly one of the domains was a test domain which no
> longer exist, thats why you are getting this error.
> What happens after this error ? Are you able to add users
> from the current domain? As long as you can see users from
> your current domain it should be fine.
> hth.
>
>
> follwing error:
> which you have access
> domain controller for