October 4, 2006 at 2:46 pm
I get this error message when I try to log on from my local laptop 'Error 21776 : {sql-dmo} . The name was not found in the Databases collection. If the name is a qualified name, use [] to separate various parts of the name, and try again'.
October 4, 2006 at 2:54 pm
It sounds like you're trying to log in with a default database that has been dropped or you're specifying a database that no longer exists when you log in.
October 5, 2006 at 5:38 am
I get this error sometimes. It seems to happen when the owner of a Database does not exist as a login on the SQL Server.
For example, I transferred a Database to a new server, without transferring logins, and the owner of the DB was 'DOMAIN\username' instead of 'sa'
Every time I tried to view properties of the 'sa' login, I had this 21776 error.
So I just ran EXEC sp_changedbowner 'sa' on the database, and it fixed the problem
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply