dbTalk Databases Forums  

Error browsing cube as a different user

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


Discuss Error browsing cube as a different user in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Zoltan Grose
 
Posts: n/a

Default Error browsing cube as a different user - 12-20-2006 , 05:49 PM






If I use AdomdConnection or Visual Studio and change the user when I'm
browsing a cube (or set the EffectiveUser property in my Adomd connection
string), I get the error:

The following system error occurred: A device attached to the system is not
functioning. .


I can see from SQL Profiler that the same user is listed in the NTUserName
field. This in particular example the current user and the effective user
names are the same.

Any clues where to look next?


Reply With Quote
  #2  
Old   
Zoltan Grose
 
Posts: n/a

Default Re: Error browsing cube as a different user - 12-21-2006 , 11:04 AM






More info: The stack trace is (when running inside Management Studio):

at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider.Mi
crosoft.AnalysisServices.AdomdClient.AdomdConnecti on.IXmlaClientProviderEx.C
reateSession(Boolean sendNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolean
createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()
at Microsoft.AnalysisServices.Browse.ConnectionsManag erBase.Connect()
at
Microsoft.AnalysisServices.Browse.CubeBrowser.Conn ectionsManager.Connect()
at Microsoft.AnalysisServices.Browse.CubeBrowser..cto r(String nameOfCube,
Object cube, IServiceProvider iserviceProvider, DesignerPageRelevantData
designerPageRelevantData, UserContextData securityContextData)
at
Microsoft.AnalysisServices.Browse.CubeBrowserHostC ontrol.CreateBrowser()
at Microsoft.AnalysisServices.Browse.BrowserHostContr ol.LoadBrowser()




On 12/20/06 3:49 PM, in article C1AF0BF0.414C%zgrose (AT) mac (DOT) com, "Zoltan Grose"
<zgrose (AT) mac (DOT) com> wrote:

Quote:
If I use AdomdConnection or Visual Studio and change the user when I'm
browsing a cube (or set the EffectiveUser property in my Adomd connection
string), I get the error:

The following system error occurred: A device attached to the system is not
functioning. .


I can see from SQL Profiler that the same user is listed in the NTUserName
field. This in particular example the current user and the effective user
names are the same.

Any clues where to look next?



Reply With Quote
  #3  
Old   
Zoltan Grose
 
Posts: n/a

Default Re: Error browsing cube as a different user - 12-26-2006 , 02:57 PM



According to MS tech support, EffectiveUserName will only work if you have a
real domain, not just a Workgroup. Inconvenient but at least that explains
the issue.


On 12/21/06 9:04 AM, in article C1AFFE9C.41C5%zgrose (AT) mac (DOT) com, "Zoltan Grose"
<zgrose (AT) mac (DOT) com> wrote:

Quote:
More info: The stack trace is (when running inside Management Studio):

at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider.Mi
crosoft.AnalysisServices.AdomdClient.AdomdConnecti on.IXmlaClientProviderEx.C
reateSession(Boolean sendNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolean
createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()
at Microsoft.AnalysisServices.Browse.ConnectionsManag erBase.Connect()
at
Microsoft.AnalysisServices.Browse.CubeBrowser.Conn ectionsManager.Connect()
at Microsoft.AnalysisServices.Browse.CubeBrowser..cto r(String nameOfCube,
Object cube, IServiceProvider iserviceProvider, DesignerPageRelevantData
designerPageRelevantData, UserContextData securityContextData)
at
Microsoft.AnalysisServices.Browse.CubeBrowserHostC ontrol.CreateBrowser()
at Microsoft.AnalysisServices.Browse.BrowserHostContr ol.LoadBrowser()




On 12/20/06 3:49 PM, in article C1AF0BF0.414C%zgrose (AT) mac (DOT) com, "Zoltan Grose"
zgrose (AT) mac (DOT) com> wrote:

If I use AdomdConnection or Visual Studio and change the user when I'm
browsing a cube (or set the EffectiveUser property in my Adomd connection
string), I get the error:

The following system error occurred: A device attached to the system is not
functioning. .


I can see from SQL Profiler that the same user is listed in the NTUserName
field. This in particular example the current user and the effective user
names are the same.

Any clues where to look next?




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.