Question about setting up BI SQL/SharePoint
Posted on 2013-11-14
I'm trying to watch a video about BI in SQL and SharePoint. I have downloaded and attached the AdventureWorks DB to my SQL 2012 for the purposes of this vid, and this database does show up in SQL Management Studio. Then, when the vid goes to open up the analysis services from SQL Management Studio, it selects analysis services from the drop down rather than database engine, but I don't have the analysis services option in the drop down.
So the simple question is what do I need to do to get that option to show up in the drop down, even if the answer may not be simple? Obviously, there is something that that is either not installed, or not enabled somehow. I have SQL 2012 and SP 2010 Enterprise that has it's databases stored on SQL Server 2012. Both SP and SQL are running on the same server which is also a DC, because I only have one instance of Windows Server for personal dev purposes on a personal domain. The DC itself is Windows Server 2008 R2.
Thanks in advance. Hopefully an easy question.