user mapping error

  • Hi All,

    We have recently migrated SQL 2012 EE to SQL 2017. We are on Microsoft SQL Server 2017 (RTM-CU22) 14.0.3356.20 (X64) EE.

    Using SSMS, I have logged into SQL 2017 instance as a sysadmin role member and when I go to a specific login -> right click --> Properties -> User Mapping , I see the below message.


    Does anyone also faced this issue ? any way to fix this?

    And by the way, there are no orphan users in any of the database. Question is why it is showing this message?

    SSMS version is below :

    Microsoft SQL Server Management Studio 14.0.17277.0

    Microsoft Analysis Services Client Tools 14.0.1016.262

    Microsoft Data Access Components (MDAC) 10.0.17763.1

    Microsoft MSXML 3.0 6.0

    Microsoft Internet Explorer 9.11.17763.0

    Microsoft .NET Framework 4.0.30319.42000

    Operating System 6.3.17763



  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • One or more of your databases will not be in an online state so you cannot map a user to it.  to prevent any errors SQL gives you the warning so you cant map a user to a database not in the right state

Viewing 3 posts - 1 through 3 (of 3 total)

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