Background Description
When you access Data Analysis the page displays the error "The query could not be processed" and on the next line displays "Safety settings on this machine prohibit accessing a data source on another domain."
Resolution
Ther are more than one possible cause for this problem, however the most likely cause is browser settings. To rule out the most common cause, follow these steps:
- Open Internet Explorer and then click the Tools menu.
- Click "Internet option", and then click the Security tab.
- Click "Trusted sites" -> "Site" and add the Data Analysis site as a trusted site.
- Click the "Custom Level" button. Under Other, enable Access data sources across domains", click OK. - Note: In Internet Explorer 7, this option is under Miscellaneous.
- View the Data Analysis to determine whether this resolved the issue.
Other things to check:
- Store your user credentials for the site using Manage Passwords feature for User Accounts, access this from Control Panel
- Make sure that you have installed MSXML 6 on your workstation (Available from Microsoft Downloads)
- Make sure that you have installed the OLEDB 9 Provider (Available from Microsoft Downloads)
On the Microsoft Download site at http://www.microsoft.com/downloads/ search for the SQL Analysis Services 2005 Feature Pack where you will find MSXML 6 and the OLEDB 9 Provider
For Further Troubleshooting See:
Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service http://technet.microsoft.com/en-us/library/cc197552.aspx
Note: Pay close attention to the sections "Configure the SSP account to have administrative permissions in SQL Server 2005 Analysis Services" and "Configure SQL Server 2005 Analysis Services."
SQL Server 2005 - Analysis Services
http://technet.microsoft.com/en-us/sqlserver/bb671388.aspx