Install sql_as_oledb.msi (Analysis Management Objects (olap oledb) ) can be downloaded via sql server 2012 feature pack 1 folder. Install as well as Web server.
The below configuration is needed to make the ini file point to the OLAP server.
1. Log in to Analysis Server and copy the below files
at <drive>:\Program Files\Microsoft SQL Server\<instance>\OLAP\bin\isapi:
MSMDPUMP.DLL,
MSMDPUMP.INI, and
a Resources folder
2. Log in web server and paste those files in below location
C:\inetpub\wwwroot\OLAP
In the msmdpump.ini the FQDN (Fully qualified domain name) of the Analysis Server name is to be used (because KERBEROS authentication implemented by is using FQDNs, e.g. UAT01SQL2012.wolterskluwer.com).
More Information in below
http://msdn.microsoft.com/en-us/library/gg492140.aspx
The below configuration is needed to make the ini file point to the OLAP server.
1. Log in to Analysis Server and copy the below files
at <drive>:\Program Files\Microsoft SQL Server\<instance>\OLAP\bin\isapi:
MSMDPUMP.DLL,
MSMDPUMP.INI, and
a Resources folder
2. Log in web server and paste those files in below location
C:\inetpub\wwwroot\OLAP
In the msmdpump.ini the FQDN (Fully qualified domain name) of the Analysis Server name is to be used (because KERBEROS authentication implemented by is using FQDNs, e.g. UAT01SQL2012.wolterskluwer.com).
More Information in below
http://msdn.microsoft.com/en-us/library/gg492140.aspx
No comments:
Post a Comment