Please resolve error message "Not a valid login"

• enriquemallon

  Ten Centuries

  Points: 1239

  More actions

  September 20, 2014 at 3:54 am

  #299602

  I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users, fill out the user information, and click OK. Management Studio throws the the error message "is not a valid login or you do not have permission”.

  How can I add this user?

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  September 20, 2014 at 4:06 am

  #1746865

  enriquemallon (9/20/2014)

  ---

  I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users, fill out the user information, and click OK. Management Studio throws the the error message "is not a valid login or you do not have permission”.

  How can I add this user?

  Quick thought, try starting SSMS by using "Run as Administrator"