Unable to Install SQL Server Analysis Service due to The folder path specified is invalid Error
I have been trying to install SQL Server Analysis Service as standalone default instance and it kept failing with the below mentioned error. It reports this error for Data, Log, TempDB and Backup folders.
The folder path specified is invalid. Please enter a valid folder path. Folder Path = “C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data”.
As part of troubleshoot process, I have tried below options.
– Ran the setup by right clicking on the setup and choose “Run as Administrator” but still I hit the same error.
– I have granted Local administrator permissions to My account and SQL Server Analysis Service account, but still got the same error.
– I deleted the folder MSAS11.MSSQLSERVER from below path and attempted the install, but still had the same error.
C:\Program Files\Microsoft SQL Server\
– Copied the SQL Server setup media to local drive.
– Made sure there is no disk corruption.
– Verified and the disk or the folders are not compressed nor encrypted nor Read_Only.
– Disabled Anti-Virus and rebooted the server, but still had same error.
– Researched about this error, but did not find any conclusive solution.
– Later I have downloaded another latest SQL Server Media from the MSDN site and extracted the content using Magic ISO tool and ran the installation by “Run as Administrator” and this time the installation proceeded further and completed successfully.
So, the issue here appears to be with the SQL Server Setup Media which seem to be buggy or corrupted.
If above solution does not work for you, then you may first see if even Analysis Services is required to be installed and is it being used by any users or applications, if not, you can just avoid the installation altogether.
What is SQL Server Analysis Service?
Analysis Services is an online analytical data engine used in decision support and business intelligence (BI) solutions, providing the analytical data for business reports and client applications such as Excel, Reporting Services reports, and other third-party BI tools. A typical workflow for Analysis Services includes building an OLAP or tabular data model, deploy the model as a database to an Analysis Services instance, process the database to load it with data, and then assign permissions to allow data access. When it’s ready to go, this multi-purpose data model can be accessed by any client application supporting Analysis Services as a data source.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.