Post reply

SQL Server 2012 Enterprise - No Analysis Services on “Add features to an existing instance of SQL Server”

  • July 5, 2012 at 2:09 pm

    #260804

    We upgraded our SQL Server 2012 Express Advanced edition to Enterprise and found No choce for Analysis Services when choosing "Add features to an existing instance of SQL Server"

    We used these queries to confirm that the edition was the Enterprise edition.

    --Version Number

    select @@version

    --Service Pack

    select serverproperty('ProductLevel')

    --Version Number

    select serverproperty('ProductVersion')

    --Edition

    select serverproperty('Edition')

    The queries returned:

    Microsoft SQL Server 2012 - 11.0.2100.60 (Intel X86)

    Feb 10 2012 19:13:17

    Copyright (c) Microsoft Corporation

    Enterprise Edition on Windows NT 6.1 <X64> (Build 7600: Service Pack 1) (WOW64) (Hypervisor)

    RTM

    11.0.2100.60

    Enterprise Edition

    Is there any way to get the installer to include the Analysis Services?

    I hope we don't have to uninstall and re-install SQL server since doing that will make a lot of people unhappy with me. :w00t:

    All help will be appreciated.

    Thanks.

  • July 5, 2012 at 6:41 pm

    #1509452

    Are you able to see SQL Server Data Tools in the SQL Server 2012 installed folder?

    S.R.Kundur

  • July 6, 2012 at 6:29 am

    #1509643

    Hi ksrikanth77,

    Yes, that folder is on the computer. I found:

    C:\Program Files (x86)\Microsoft Visual Studio 10.0\Microsoft SQL Server Data Tools

    I did notice that "SQL Server Data Tools" is on the start menu, and when I click that one it starts our VS 2010 Professional. It's just like selecting "Visual Studio 2010 Professional" from the start menu.

    The shortcut had this in it:

    "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe"

    Could there be something we missed that's not in the installer documentation?

    Thanks.

  • July 6, 2012 at 9:06 am

    #1509745

    I mean to say Click on Start Menu--> All Programs --> Microsoft SQL Server 2012 --> Open SQL Server Data tools, Once it is open you can see the analysis services which you installed. The Business Intelligence is renamed to SQL Server Data Tools in SQL 2012. You might have already cheked this option while installation (Knowingly or Unknowingly). So please open the SQL Server data tools and verify whether Analysis Services is installed or not?

    Regards

    S.R.Kundur

  • July 6, 2012 at 9:15 am

    #1509754

    Hi ksrikanth77,

    I ran the program as described and went to the object explorer and clicked on the icon to connect to a server.

    When the "Connect to Server" box opened the "Server type" was dimmed out with just "Database Engine" showing. Isn't this where we should be able to select the Analysis Services server?

    Thanks.

  • July 6, 2012 at 4:26 pm

    #1509919

    Sorry emadleiman47,

    Its My bad I think I misunderstood your question.

    It appears that the Advance Express Edition of 2012 also does not include SSAS components. Please check the below link and for more clarity.

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    You can also confirm whether SSAS was installed at the first instance by going to this path in your server which will show you the Installed features in your server. "C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\summary.txt"

    Again sorry to say you that I think you need to unistall and reinstall SQL Server 2012 Ent, However I am curious that why cant you try adding SSAS by running the SQL Serve setup again.

    Thanks

    S.R.Kundur

  • July 7, 2012 at 2:06 am

    #1509952

    Hi ksrikanth77,

    The link was helpful to confirm that we chose the correct version of SQL Server but don't know why Analysis Services is not part of the selection of additional features that should be showing during the setup.

    Maybe it is part a a separate installer. I hope Microsoft support will support this product. As a last resort we will have to do a lot of backing up databases, reports, etc then reinstalling to see if it shows up on the installer.

    Thanks for trying to help.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply