When you try to give a user access to a database you get the above message. To resolve this you need to have access to SQL Server Enterprise Manager.
Open Enterprise Manager then go to Security>Logins, right-click on the user having this problem then go to Properties. Open the Database Access tab then Unmark or Uncheck the database you're giving the user access to.
Go back to Great Plains then try to give the user access again.