Re: Permission to Users under DB
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 08/02/02
- Next message: Sue Hoegemeier: "Re: Permission to Users under DB"
- Previous message: Dan Guzman: "Re: Permission in database"
- In reply to: Patrick Wang: "Re: Permission to Users under DB"
- Next in thread: Donna Lambert [MS]: "RE: Permission to Users under DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Fri, 02 Aug 2002 08:23:54 -0600
Yes, sysadmin means that the login is a member of the fixed
server role System Administrator.
In regards to your error, you are likely running into one of
the following:
PRB: Cannot Change SA Password in Enterprise Manager
http://support.microsoft.com/?scid=kb;en-us;Q218172
BUG: DBO User Does Not Display in Enterprise Manager
http://support.microsoft.com/?scid=kb;en-us;Q305711
Either way, they are both basically due to the account
mapped to dbo not having a matching login.
-Sue
On 1 Aug 2002 20:18:02 -0700, patrickwang@hknetmail.com
(Patrick Wang) wrote:
>Dear Sue,
>
>For Sysadmin privilege, do you mean that one has "System
>Administrator" selected under "Server Role" ?
>
>Besides, I find that when I double click SA, I get the following error
>message:
>"Error 21776:[SQL-DMO]The name 'dbo' was not found in the users
>collection".
>
>However, when I go to Database Administration, I find that DBO is
>assigned for all databases in that Server.
>
>Morever, I have no problem in granting privilege to any users when I
>log in as SA in my local workstation (Just running SQL Server Personal
>Edition on my W2K workstation).
>
>Thanks
- Next message: Sue Hoegemeier: "Re: Permission to Users under DB"
- Previous message: Dan Guzman: "Re: Permission in database"
- In reply to: Patrick Wang: "Re: Permission to Users under DB"
- Next in thread: Donna Lambert [MS]: "RE: Permission to Users under DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
