Re: The name 'guest' was not found in the Users collection
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 03/25/04
- Next message: Barb: "Re: Generate SQL Script for Stored Procedures"
- Previous message: Adam Machanic: "Re: The name 'guest' was not found in the Users collection"
- In reply to: Mike B.: "The name 'guest' was not found in the Users collection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 25 Mar 2004 08:48:48 -0600
I haven't seen this error for the guest user before. Guest is not
associated with a login so there shouldn't be an orphaned user issue. The
only thing I can think of is that the guest was removed by updating system
tables directly.
You might try adding the guest user to the problem database(s) using
sp_adduser 'guest'. For databases other than master and tempdb (where the
guest user must be enabled), you can then disable 'guest' with sp_dropuser
if your users don't need to access the database(s) via guest.
-- Hope this helps. Dan Guzman SQL Server MVP "Mike B." <anonymous@discussions.microsoft.com> wrote in message news:133ea01c41273$cf421510$a401280a@phx.gbl... > Error 21776: [SQL-DMO]The name 'guest' 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 inherited a SQL server with orphaned guest users. Has > anyone seen this error before? Any ideas on fixing the > problem?
- Next message: Barb: "Re: Generate SQL Script for Stored Procedures"
- Previous message: Adam Machanic: "Re: The name 'guest' was not found in the Users collection"
- In reply to: Mike B.: "The name 'guest' was not found in the Users collection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
