Sign in
 
Home20122008 R2200820052000LibraryForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server >
> 
> 
SQL Server Standard 2012 with SP1 - Adding Instance Feature - Instance Directory Wrong?

Answered SQL Server Standard 2012 with SP1 - Adding Instance Feature - Instance Directory Wrong?

  • Wednesday, January 09, 2013 12:36 PM
     
     
    Sign In to Vote
    0

    I installed a named instance of SQL Server 2012 Standard Edition (with SP1) yesterday, my customer has come back to me saying that the instance requires the 'Full-Text and Semantic Extractions for Search' feature for the associated application to operate correctly.

    I have run the SQL Server 2012 Setup and attempted to add the feature to the instance.

    My problem is that it appears the installer wants to add the feature to the wrong disk. When I performed the original installation I set the Shared feature directory to E:\Program Files\Micorsoft SQL Server, the Shared feature directory (x86) to E:\Program Files (x86)\Micorsoft SQL Server and the Instance Directory to E:\Program Files\Micorsoft SQL Server. I have confirmed these paths both in the installation configuration file and that the files are actually located in these places.

    When trying to add the feature the installer states that it will install to the Instance Directory C:\Program Files\Micorsoft SQL Server. There does not seem to be anwhere to configure this, I would expect the feature to be installed in the existing Instance Directory E:\Program Files\Micorsoft SQL Server.

    Any help gratefully received.

     

All Replies

  • Wednesday, January 09, 2013 1:26 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Even when you specify SQL Server setup to perform installation on another drive, setup will install some binaries on the system drive anyway.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Wednesday, January 09, 2013 1:55 PM
     
     
    Sign In to Vote
    0

    Thanks, I'm aware of that, my point here is that the Instance Directory is set to C:\Program Files\Microsoft SQL Server when attempting to add the feature to the existing instance which is already installed in E:\Program Files\Micorsoft SQL Server

    From the ConfigurationFile.ini for the orginal installation of the instance:

    ; Specify the installation directory.

    INSTANCEDIR="E:\Program Files\Microsoft SQL Server"

    From the ConfigurationFile.ini for the addition of the feature to the instance:

    ; Specify the installation directory.

    INSTANCEDIR="C:\Program Files\Microsoft SQL Server"

     
  • Wednesday, January 09, 2013 2:24 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Are you sure you selected the existing instance and you are not creating a new one? Make sure on the “Installation Type” page of SQL Server setup you selected “Add features to an existing instance of SQL Server 2012”.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Wednesday, January 09, 2013 2:37 PM
     
     
    Sign In to Vote
    0

    Yes I am sure I am modifying the existing instance.

    Thanks.

     
  • Thursday, January 10, 2013 8:33 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi John,

    Please refer to the following document to add feature to a installed SQL Server instance. After choosing the instance during “Installation Type” tab, we don’t need to specify the installation path.

    Add Features to an Instance of SQL Server 2012 (Setup)
    http://msdn.microsoft.com/en-us/library/cc281940.aspx

    TechNet Subscriber Support
    If you are     TechNet Subscriptionuser and have any feedback on our support quality, please send your feedbackhere.

    Allen Li
    TechNet Community Support

     
  • Thursday, January 10, 2013 9:35 AM
     
     
    Sign In to Vote
    0

    This is the summary screen for the original instance installation, with the instance directory highlighted:

    This is the summary screen from the instance installation

    This is the summary screen for the addition of the Full-Text feature to the existing instance, with the instance directory highlighted:

    This is the summary screen for the addition of the Full-Text feature

    There appears to be something wrong with the installer, as it is setting the Instance Directory incorrectly.

    I'm hoping there is some way of adding the feature in the correct location, without me having to remove the instance entirely and re-install it.


     
  • Thursday, January 10, 2013 9:44 AM
     
     
    Sign In to Vote
    0

    Allen,

    Thanks for your response. The problem is that the installer for whatever reason is saying that the instance is on the C: drive when in fact it is actually on the E: drive, and I am not able to correct this.

    I have posted a couple of screenshots above to clarify.

     
  • Thursday, January 10, 2013 12:53 PM
     
     Answered
    Sign In to Vote
    0

    I worked around this problem by removing the instance, and re-installing it with both the 'Database Engine Services' and 'Full-Text and Semantic Extractions for Search'

    I feel that the root of this may be a bug in the installer?