Error when attempting to log in to Sitecore after security database is moved

  • Logging in to Sitecore XP with some external user (AzureAD, for example) might fail with an unhandled exception after moving the security database. The error occurs due to the missing UserLogins table. The following message can appear in the log:

    Exception: System.Exception
    Message: Invalid object name 'UserLogins'.
    Source: Sitecore.Kernel
    at Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteReader()
    at Sitecore.Data.DataProviders.Sql.DataProviderReader..ctor(DataProviderCommand command)
    at Sitecore.Data.DataProviders.Sql.SqlDataApi.<>c__DisplayClass29_0.<CreateReader>b__0()
    at Sitecore.Data.DataProviders.NullRetryer.Execute[T](Func`1 action, Action recover)
    at Sitecore.Data.DataProviders.Sql.SqlDataApi.CreateReader(String sql, Object[] parameters)
    
  • To resolve the issue, consider the following workaround:

    1. Open Microsoft SLQ Server Management Studio.
    2. Connect to the server hosting the current Security table.
    3. Right-click the UserLogins table.
    4. Click Script Table as, then CREATE To, and then New Query Editor Window.
    5. Run the resulting script against the new Security database to add the UserLogins table.

Applies to:

CMS 9.1 Initial Release - 9.3 Initial Release

CMS 10.0 Initial Release

February 26, 2020
August 04, 2020

Reference number:

371171