Hi all,
i am also facing the same problem..
when i moved script for linked server creation from dev touat enviroment , after changing the server name as per uat script runs but when i try to check the connection it says "Cannot create an instance of OLE DB provider "MSOLAP" for linked server " please helpme if any one has a solution to this problem.