Hi,
I create a new database - works fine
I issue: sp_addlogin myname, password, database - works fine
I issue sp_grantdbaccess, myname - seems to work fine
In EM, I open property sheet of this login - go to database access tab where I clearly see that access has indeed been granted. But when I hit "OK" to close out, I get the error:
error 21776 [SQL-DMO] the name myname was not found in the users collection. If the name is a qualified name, use [] to separate various parts of the name, and try again.
I can not "uncheck" it here - just get the same error message. I can use sp_revokeaccess and then get back into it in EM and it works fine. This problem does not happen if I just check it in EM to start with instead of using the SP. Any ideas anyone?
TIA,
Ken
Ken B. Matson
GCom2 Solutions