Report Portal

quote:

---

[i]Originally posted by admin[/i]
[br]The problem can be caused by security, SSAS provider or incompatible msmdpump.dll files.

1. Are you able to connect to SSAS using a UDL file? Create a text file (Test.txt), rename it to Test.udl and duoble click on it. select Microsoft OLE DB Provider of Analysis Services put your server info and click Test.

I get an error ''Test connection failed because of an error in setting the window handle property. Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Continue with test connection?''



2. Copy a sample text file (Test.txt) to in C:\inetpub\wwwroot\XMLA folder. Try to view the file in browser (like http://www.reportportal.us/xmla/Test.txt)

I can connect and see test.txt file and it's content.

Please try to set XMLA manually:
https://www.youtube.com/watch?v=tJGGyg1dDHY

---

quote:

---

[i]Originally posted by admin[/i]
[br]The first error ("error in setting the window handle property") can be safely ignored. Do you see a message after this error?

---

quote:

---

[i]Originally posted by admin[/i]
[br]Is your SSAS server installed on your web server?

Yes.

Is XMLA virtual directory setup to have Anonymous authentication only?

Yes.

1. Copy msmdpump.dll and related files (usually located in C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\bin\isapi) to C:\inetpub\wwwroot\XMLA

2. Open "C:\inetpub\wwwroot\XMLA\msmdpump.ini" in notepad. Change Local to [Your Server Name]

---

quote:

---

[i]Originally posted by admin[/i]
[br]Did you copy msmdpump.dll and related files to C:\inetpub\wwwroot\XMLA folder?

---

quote:

---

[i]Originally posted by admin[/i]
[br]What happens when you try to view msmdpump.dll in browser?
(like: http://www.reportportal.us/xmla/msmdpump.dll)

---