dbTalk Databases Forums  

Browsing Cubes in Sept CTP

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


Discuss Browsing Cubes in Sept CTP in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve McHugh
 
Posts: n/a

Default Browsing Cubes in Sept CTP - 09-23-2005 , 07:45 AM






Here's something....

Start up the September CTP and connect to the Analysis Services
Tutorial and browse the cube. No problems so far. This is all happening
on my laptop whilst connected to my work network. Repeat the above but
this time not connected to network and I get the following message...

The query could not be processed:
o Errors in the OLE DB provider. Could not connect to the redirector.
Ensure that the SQLBrowser service is running on the 'computername'
server.
o Errors in the OLE DB provider. An error occurred while named instance
information was being retrieved from the SQLBrowser service on the
'computername' server.

no services have been stopped, all that has happened is connection to
my work network has been broken.

Any ideas?

Steve


Reply With Quote
  #2  
Old   
dbahooker@hotmail.com
 
Posts: n/a

Default Re: Browsing Cubes in Sept CTP - 09-23-2005 , 08:40 PM






you should try the address 127.0.0.1 instead of the computer name.. it
makes sense to me that you might be trying to resolve your own computer
name but you cant

this would be especially a problem where group policy locked down
permissions so that you couldn't cache logins


Reply With Quote
  #3  
Old   
Steve McHugh
 
Posts: n/a

Default Re: Browsing Cubes in Sept CTP - 09-24-2005 , 01:31 AM



I was working along that theory as well, this is what that gives
you....

TITLE: Connect to Server
------------------------------
Cannot connect to 127.0.0.1\septctp.
------------------------------
ADDITIONAL INFORMATION:
Authentication failed. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
The Local Security Authority cannot be contacted
(Microsoft.AnalysisServices.AdomdClient)
------------------------------

it looks like it comes down to resolving the users login, domain user
with cached login information is good enough to write mdx against the
cube but not to browse it. Of course this means all client tools are
effected the same way.

So my choices are stay connected to the network or login to the machine
as local admin....


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.