Thursday, December 28, 2006

User or role already exists in the current database

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.

Tuesday, December 12, 2006