error: "Interop.OWC10- exception HRESULT:0x80040E4D"

[r388042]

Hi,

I have created an OLAP reporting in ASP.NET using SQL Server 2000, Analysis
Services and OWC.
I have downloaded the code in:
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx

After modifications, this application runs but I have an error when I want
to load a custom report and when I want to apply cutom grouping.

This error is displaying:
<err> Interop.OWC10-Exception HRESULT:0x80040E4D.</err>

I odn't understand where is the problem.
Have anybody ideas?

 

[Uday Takbhate [MSFT]]

Here are the error details..
Error Result : 0x80040E4D ( -2147217843 )
ID Defined as : DB_SEC_E_AUTH_FAILED
Error Type : OLE HRESULT Error
Facility : FACILITY_ITF 0x00000004 ( 4 )
Severity : SEVERITY_ERROR 0x00000001 ( 1 )
Code : 0x00000E4D ( 3661 )
Source Error file : Oledberr.h
Message Text : Authentication failed

The problem I suspect is OWC10 could not access SQL server. To fix this
problem you may add domain name and "$" to userid on SQL, then the OWC
client could access the database

Thanks,
Uday Takbhate [MSFT]
Microsoft Developer Support
--------------------

 

[kas]

Hi All,
I've tried the code, I didn't have any problem, if I specified my
connection string as the following (IIS and Analysis Services on the
same box):
<add key="OLAPConnectionString" value="Provider=MSOLAP.2;Data
Source=localhost;Initial Catalog=Foodmart 2000;" />

But, I'll have the [<err> Interop.OWC10-Exception
HRESULT:0x80040E4D.</err>] problem if my IIS and SQL Analyst Services
is not in the same machine.

Have anyone manage to do so? Approciate for your feedback.

Thanks,
Kas

 

[Uday Takbhate [MSFT]]

This exception is more of a authentication exception.
Please refer to this article for more information on the security
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
#ERAA

Regards,
Uday Takbhate [MSFT]
Microsoft Developer Support
--------------------

From: "kas" <[email protected]>
Newsgroups: microsoft.public.office.developer.web.components
Subject: Re: error: "Interop.OWC10- exception HRESULT:0x80040E4D"
Date: 6 Sep 2005 02:16:34 -0700
Organization: http://groups.google.com
Lines: 16
Message-ID: <[email protected]>
References: <[email protected]>
<[email protected]>
NNTP-Posting-Host: 210.19.57.10
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1125998199 11800 127.0.0.1 (6 Sep 2005 09:16:39 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Tue, 6 Sep 2005 09:16:39 +0000 (UTC)
In-Reply-To: <[email protected]>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;

NET CLR 1.1.4322),gzip(gfe),gzip(gfe)

X-HTTP-Via: 1.0 proxy.mesiniaga.com.my:8080 (squid/2.5.STABLE4)
Complaints-To: (e-mail address removed)
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=210.19.57.10;
posting-account=T3wjRA0AAAA7SZ5HLruAzKcoVYTgylrQ
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.office.developer.web.components:3373
X-Tomcat-NG: microsoft.public.office.developer.web.components

Hi All,
I've tried the code, I didn't have any problem, if I specified my
connection string as the following (IIS and Analysis Services on the
same box):
<add key="OLAPConnectionString" value="Provider=MSOLAP.2;Data
Source=localhost;Initial Catalog=Foodmart 2000;" />

But, I'll have the [<err> Interop.OWC10-Exception
HRESULT:0x80040E4D.</err>] problem if my IIS and SQL Analyst Services
is not in the same machine.

Have anyone manage to do so? Approciate for your feedback.

Thanks,
Kas

 

[kas]

Hi All,

Just to share with you guys. I've modified the code a bit as follows
(use MDX queries) and manage to get the report using the same
Connection String.

<WebMethod()> Public Function LoadCustomPivotTableReport(ByVal _
strCity1 As String, ByVal strCity2 As String) As String

Dim m_XML As String
Dim strOLAPConn As String =
ConfigurationSettings.AppSettings("OLAPConnectionString")
Dim objPT As PivotTableClass = New PivotTableClass
Dim objPTView As PivotView
Dim fldCity, fldName, fldProdFamily As PivotField
Dim fSetCustomers, fSetProduct As PivotFieldSet

Try
' set the connection string and data member
objPT.ConnectionString = strOLAPConn
objPT.DataMember = "Sales"
'objPT.AllowPropertyToolbox = False
''objPT.AllowFiltering = False
objPT.AllowFiltering = True
objPT.AllowDetails = True
objPT.AllowGrouping = True
objPT.CommandText = "with member [Measures].[Store Sales
Last Period] as '([Measures].[Store Sales], Time.PrevMember)' select
{[Measures].[Store Sales Last Period]} on columns,
{TopCount([Product].[Product Department].members,5, [Measures].[Store
Sales Last Period])} on rows from Sales where ([Time].[1998])"

objPTView = objPT.ActiveView
objPTView.TitleBar.Caption = ""


m_XML = objPT.XMLData

objPT = Nothing
Catch err As Exception
m_XML = "<err>" & err.Source & " - " & err.Message &
"</err>"
Finally

End Try

Return (m_XML)
End Function

Regards,
Kas.