April 10, 2003 at 2:39 pm
hi
We performed a restore of a bunch of databases from another server and now when i try to go in and change the sa pwd i get the following error:
Error 21776: [SQL-DMO] The name 'XXXX' 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.
Now i run the query below to isolate the orphaned users and i get none!
select u.name from master..syslogins l right join
sysusers u on l.sid = u.sid
where l.sid is null and issqlrole <> 1 and isapprole <> 1
and (u.name <> 'INFORMATION_SCHEMA' and u.name <> 'guest'
and u.name <> 'system_function_schema')
- So now i am at a complete loss as to what to do next.
If anyone has any ideas it wil be great!
thanks
Hinal
April 14, 2003 at 8:00 am
This was removed by the editor as SPAM
July 12, 2005 at 1:24 pm
Is this through SQL Server Enterprise Manager? If it is, force a refresh of the users in the database (not the list of users under security) and see if the refreshed list solves the problem.
Tim
Timothy J. Bruce
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply