| Author |
 Topic  |
|
|
mirza
Indonesia
3 Posts |
 Posted - 08/14/2009 : 09:40:20
|
i'm using iis on winxp sp 2. my problems with XMLA setup are :
1. when using integrated windows authentication on virtual directory security and press the Test button on XMLA setup window i got error :
TestXmla:The remote server returned an error:(401)Unauthorized
when pressing Test connection inside Create UDL, Test Connection succeeded. I could also saw catalog.
here's my complete configuration:
Connection : XMLA
Virtual Directory Name : XMLA
Analysis Services Server Name : localhost
URL : http://localhost/xmla/msmdpump.dll
Security : All users have full access
NT username : mysusername
password : myusername-password
Confirm password : myusername-password
2. when using anonymous access with IUSR user on virtual directory security i got error:
No catalogs found in SERVERNAME. Please check security and try again. Create UDL was fine. configuration:
Connection : XMLA
Virtual Directory Name : XMLA
Analysis Services Server Name : localhost
URL : http://localhost/xmla/msmdpump.dll
Security : All users have full access
NT username :
password :
Confirm password :
i've tried googling but no good result so far. i've even tried this :
http://support.microsoft.com/kb/896861
has it something to do with my FAT32 file system?
please help.thx |
|
|
admin
1637 Posts |
Posted - 08/14/2009 : 12:40:25
|
Which version of Analysis Services are you using (2000, 2005 or 2008)?
Please follow these steps:
1. Open IIS console
2. Right click on XMLA virtual directory
3. Click Properties
4. Click Directory Security tab
5. Under “Anonymous access and authentication control” click Edit…
6. Check Anonymous Access and Uncheck Basic and Integrated Windows
7. For user name enter a Windows user account that has access to your Analysis Services Database including the domain name (like domain1\user1)
8. Enter password
9. Login to the ReportPortal application as an admin.
10. Go to Admin > Connections > Click on XMLA connection and click Test
You might find this page useful for XMLA troubleshooting:
http://www.reportportal.com/FAQ.asp
|
 |
|
|
mirza
Indonesia
3 Posts |
Posted - 08/15/2009 : 01:32:26
|
i use analysis services 2005.
so, i finally get it done but there's another problem comes. btw, here's what i did, i hope this would help others with the same problem:
1. to find out about the correct user who has access to analysis services i opened sql server management studio, select analysis services for server type and left the rest to default. when successfuly login i pay attention to the domain\username. btw, this user need no password to login.
2. setting the virtual directory as you told me and check the Allow IIS to control password to leave the password blank.
3. login to http://localhost/reportportal with user admin and test the connection as you told me, the result was Success!
then i gave a try to do the configuration from start->all programs->reportportal->application setup
when i first got in, the settings was just like what i did on step 2 above but with password. so press the Test button, the result was success. but when i press the Test button for the 2nd time, the problem with authentication showed up again. i went back to http://localhost/reportportal and did the test, the result was a problem with auth. so then i checked virtual directory properties and found that the Allow IIS to control password was unchecked. obiously application setup did the uncheck. so i put the check back again and the test result was Success!.
one problem solved. but here comes another one. after did the success test from http://localhost/reportportal, now i want to design olap report. so i click Design->OLAP Report. i can see Connect to Cube/Open report with Loading... below it but when i click Connect to Cube nothing happen. it seems like the javascript's not working. is the problem with my browser or should there be other settings to do before? i use IE 6.0. I've checked that javascript is already enabled on my IE.
i also notice on other topic of this forum that someone also experienced the same problem. someone else answered him that it could be expired evaluation version. it can't happen to me because i installed reportportal just 2 days ago. please help. thx. |
|
|
|
admin
1637 Posts |
Posted - 08/19/2009 : 00:41:07
|
| You might still have an expired evaluation because it can also expire from the day you downloaded it. Please go to Admin > Settings > Version to see what your installed version is. The current Build is 164. |
|
|
| |
Topic |
|
|
|
Report Portal
XMLA setup problem
