This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In services also ananlysis services not showing. i have installed sql server 2014. i have to wriite DAX query but it is not connected in ssms.
In services also ananlysis services not showing.
Then you haven't installed that feature SSAS. Add the feature to your existing installation.
Hi @Mayuri Joshi ,
Have you select Analysis Services from the Feature Tree in Setup?
Which model have you installed?
It seems that you have not installed SSAS successfully.
Check this to re-install for a try or try to repair.
install-analysis-services
You may also find the error log to see more information.
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
hello @ZoeHui-MSFT ,
i have installed sql server 2014. during setup in feature tree there is no analysis service option mentioned. so i think its not installed. my windows os is 2007. thats why i have installed 2014 sql server. now what can do to installed analysis services. please guide me.
during setup in feature tree there is no analysis service
Which edition of SQL Server have you installed? E.g. the free Express Edition don't support SSAS.
my windows os is 2007
There is no such Win Server OS version and even if: Out-of-Support since a long time.
Hi @Mayuri Joshi ,
Please check the Supported Operating System for SQL Server:
Windows 10, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2.
Microsoft® SQL Server® 2014 Service
Please have a double check.
If your system is support for SQL Server, you may follow the tutorial to add the SSAS feature.
If these ways do not work, please check the summary to see more error messages.
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.