none
Getting "No mapping between account names and security IDs was done" when install full text search feature for SQL 2012

    Question

  • Hi,

    I'm attempting to add the full text search feature to one of our SQL environments.

    Once the install has started it throws this error message twice. "No mapping between account names and security IDs was done". I get options to retry or cancel, cancel seems to just skip and continue the install.

    The install seems to complete successfully once you cancel the error message.

    I've checked the databases and we don't have any users or group assigned to roles that are not in the AD domain.

    I'm stuck as to what else to look for....

    Here is an extract from the error log:

    (01) 2017-02-01 10:33:32 SQLEngine: Loading group properties from local machine.
    (01) 2017-02-01 10:33:32 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.ENOTINGINSTANCE\Setup
    (01) 2017-02-01 10:33:32 Slp: Sco: Attempting to get registry value SQLGroup
    (01) 2017-02-01 10:33:32 Slp: Sco: Attempting to get registry value FDHOSTGroup
    (01) 2017-02-01 10:33:32 Slp: Sco: Attempting to get account from sid S-1-5-80-61038044-1460991423-2496639405-3432405572-984320763
    (01) 2017-02-01 10:33:32 Slp: Sco: Attempting to get account from sid S-1-5-80-1529172933-1289199595-2667646192-4261488767-1522532605
    (01) 2017-02-01 10:33:32 Slp: Sco: LookupAccountSid failed for SID S-1-5-80-1529172933-1289199595-2667646192-4261488767-1522532605
    (01) 2017-02-01 10:33:32 Slp: Prompting user if they want to retry this action due to the following failure:
    (01) 2017-02-01 10:33:32 Slp: ----------------------------------------
    (01) 2017-02-01 10:33:32 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    (01) 2017-02-01 10:33:32 Slp: Inner exceptions are being indented
    (01) 2017-02-01 10:33:32 Slp: 
    (01) 2017-02-01 10:33:32 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    (01) 2017-02-01 10:33:32 Slp:     Message: 
    (01) 2017-02-01 10:33:32 Slp:         No mapping between account names and security IDs was done.

    The SID ending in 605 seems to be for the local service account used to run the full text search daemon.

    Thanks

    Joe

    Wednesday, February 1, 2017 10:52 AM

All replies

  • To clarify we are using the standard: MSSQLFDLauncher$ account to run the service as this seems to be recommended best practice.

    Thanks

    Wednesday, February 1, 2017 10:57 AM
  • Hiya there,

    as first measure, if you didn't restart your physical server/vm and WMI service  as well.

    it seems a permissions issue indeed

    Wednesday, February 1, 2017 10:57 AM