A number of people have had issues with PowerPivot installation failures in CTP3. Hopefully, we have resolved all of these for RTM, but I can tell you that setup is still a bit tricky. To give you something of an understanding, the “New Farm” installation option is responsible for getting your machine up and running with as few steps from you as possible. It installs SQL Relational Engine & AS, then configures SharePoint using the newly installed Relational Engine, then configures AS integration with SharePoint. In can be especially tricky in the case of patching and so forth since technically speaking SQL Server does not have to be running to be patched but we cannot interact with SharePoint if SQL Server is not running. We have done a lot of work to try and get this right, but I am not foolish enough to think that there will be no issues. Any issues you hit should be reported to the appropriate forums and perhaps followed up with CSS if necessary, but to get you started on installation issues, this is what you want to look at:
In the %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Log you will see a list of folders with Date-like names. Search inside them for a file called detail.txt (easiest way is probably “dir /s /b detail.txt”). You want to go to the most recent directory with this file and open up this file and search for the string ”Running Action: ASSPI_Install_ASSPIInstallStartupFinalize”. This is the beginning of the section in which we do our configuration of SharePoint with Analysis Services. I will admit that the logging has not been “scrubbed” so grammatical errors might abound, however you should be able to glean some potentially useful information from it. I tend to look for exceptions with stacks. Even if you can’t figure out what the error means, it will be useful to include in any “help” postings and might get you faster turnaround.
Please make sure, even if you figure out what is happening and are able to “workaround” it, that you report any issues so that we can continue to improve the experience.
Thanks
Lee
My configuration failed, I am not sure what’s hapenning, can some one help please
Thanks
Sanjeevi
2010-09-02 14:45:34 AS: Performing configuration task 3 of 3
2010-09-02 14:45:34 AS: Finalizing the SharePoint Products configuration…
2010-09-02 14:45:34 AS:
2010-09-02 14:45:34 AS: Successfully completed the SharePoint Products configuration.
2010-09-02 14:45:34 AS:
2010-09-02 14:45:34 AS: Total number of configuration settings run: 3
2010-09-02 14:45:34 AS: Total number of successful configuration settings: 3
2010-09-02 14:45:34 AS: Total number of unsuccessful configuration settings: 0
2010-09-02 14:45:34 AS: Successfully stopped the configuration of SharePoint Products.
2010-09-02 14:45:34 AS: Configuration of the SharePoint Products has succeeded.
2010-09-02 14:45:34 AS: Running function ConfigureNewFarm().
2010-09-02 14:45:34 AS: Enterring function SetSecurityAccessPermissions
2010-09-02 14:45:34 AS: Action: (Utility) Detecting Instance Name
2010-09-02 14:45:34 AS: Result: (Utility) POWERPIVOT
2010-09-02 14:45:34 AS: Action: (Utility) Detecting Service Name
2010-09-02 14:45:34 AS: Result: (Utility) MSOLAP$POWERPIVOT
2010-09-02 14:45:34 AS: Action: (Utility) Detecting Service Status MSOLAP$POWERPIVOT
2010-09-02 14:45:34 Slp: Sco: Attempting to open SC Manager
2010-09-02 14:45:34 Slp: Sco: Attempting to open service handle for service MSOLAP$POWERPIVOT
2010-09-02 14:45:34 Slp: Sco: Attempting to close service handle for service MSOLAP$POWERPIVOT
2010-09-02 14:45:34 Slp: Sco: Attempting to close SC Manager
2010-09-02 14:45:34 Slp: Sco: Attempting to get service status for service MSOLAP$POWERPIVOT
2010-09-02 14:45:34 Slp: Sco: Attempting to open SC Manager
2010-09-02 14:45:34 Slp: Sco: Attempting to open service handle for service MSOLAP$POWERPIVOT
2010-09-02 14:45:34 Slp: Invoking QueryServiceStatus Win32 API
2010-09-02 14:45:34 Slp: Sco: Attempting to close service handle for service MSOLAP$POWERPIVOT
2010-09-02 14:45:34 Slp: Sco: Attempting to close SC Manager
2010-09-02 14:45:34 Slp: Sco: Returning service status Running
2010-09-02 14:45:34 AS: Result: (Utility) Running
2010-09-02 14:45:36 Slp: Error: Action “Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction” threw an exception during execution.
2010-09-02 14:45:36 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. —> Microsoft.AnalysisServices.ConnectionException: A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. —> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:2382
2010-09-02 14:45:36 Slp: at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
2010-09-02 14:45:36 Slp: — End of inner exception stack trace —
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
2010-09-02 14:45:36 Slp: at Microsoft.AnalysisServices.SharePoint.Integration.EngineServiceInstance.GetBackupDirectoryPath()
Hi Sanjeevi,
Is this install being done on a “clean” machine, or does it already have something like an existing instance of SQL Server installed? When you installed, what account did you chose to have SQL Browser running as? For some reason, SQL Browser is not responding to our request but I am not sure yet why. Let me know about the machine.
Thanks
Lee
[...] Read more… [...]