I have a server just for SQL Server 2012 and a server for my websites. I'm installing ReportPortal on the server that hosts the websites. One issue I'm working on in determining what I need to do to setup the Data Link Properties for the OLE DB Provider for Analysis Services 11.0. I've installed the OLE DB Provider on the server that hosts the websites, including ReportPortal. What do I put for the Data Link Properties? Do I need port 2383 open on the webserver? I have SQL Browser running on the database server. Thanks for any help.
"C:\inetpub\wwwroot\ReportPortal\xmla.udl" points to the relational engine. Double click to point it to the new server. The required Data Link Properties will be generated for you.
"C:\inetpub\wwwroot\XMLA\msmdpump.ini" point to Analysis Services. Open it in notepad and point it to the new server like:
Report Portal
Data Link Properties Issue on Remote Server
Posted - 09/03/2013 : 09:01:16
