user mapping error

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  November 22, 2020 at 5:53 am

  Go to Answer

  #3812636

  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

  Regards,

  Sam

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  November 23, 2020 at 6:10 am

  #3812880

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

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

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 23, 2020 at 9:12 am

  Answer

  #3812909

  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