Thursday, December 28, 2006

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.