So you’re trying to configure PowerPivot for SharePoint 2013 and you see an error in you log files or cmd window along the lines of
Exception calling “Open” with “0” argument(s): “The connection cannot be opened because the redirector service did not provide required database information.”
This could be because you are working/testing with an Excel spreadsheet that has a data connection that is external to your domain and because your server is not open to the internet, you see the error.Derek Halstead is a SharePoint consultant, educator and author, as well as the founder and principal of Certified Solutions Australia and CoolWriteups.com. He has 16 years of experience in the IT industry, with over ten years focused on Microsoft SharePoint. He can be reached by using the Contact Me link in the top menu.