dbTalk Databases Forums  

generating local cube from remote server problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss generating local cube from remote server problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Klaus Wiesel
 
Posts: n/a

Default generating local cube from remote server problem - 08-09-2006 , 05:17 AM






Hello

I try the following:

I
1) connect to a remote server and browse its as databases and cubes
2) display one cube in a OWC 10/11 pivottable (by setting
..connectionstring and .datamember
3) try to create a local cube from this server database/cube using
"CREATE GLOBAL CUBE...") giving a unc path as target

Steps 1 and 2 are successful (I use a named user in the format
domain\username).

Step 3 gives an error: either a connection cannot be made to server ...
or AS is not running on this computer

When I try this with my local AS, 1 to 3 works fine (assumed I use
localhost and integrated security)


Is there any rule for user accounts to be able to create local cubes?

Regards
Klaus Wiesel

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.