| Author |
Topic |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2006-02-17 : 00:39:17
|
| Hi Guys,here are my "weird" questions again...today, I installed sql2k on one server and patched it with sp4then i noticed that msdb has the guest account, via membership...is this normal?? and why do we need the guest account?? has sql2k beginning to be compromised to push us to move to sql2k5?just asking, but hope someone answers...TIA--------------------keeping it simple... |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-17 : 00:43:16
|
| also, information_schema and system_function_schema in master!what is happening??--------------------keeping it simple... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-17 : 01:32:55
|
"information_schema in master"That's normal, isn't it?"system_function_schema in master"I don't have those - what do they do / where are they from?"msdb has the guest account"I have that on SP3 and SP4 ...  Kristen |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-17 : 02:10:48
|
| information_schema in master is normalsystem_function_schema in master is normalguest account in master and msdb is normal and cannot be removedMake sure that you don't have a guest account in any other database and you are ok. -ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-17 : 03:12:07
|
| hmm... how come i only see them now (i'm in a new environment, all with sp4)?i have not seen these accounts before, I am talking about users being added noh? i thought they were already there when I joined the company and that the guest account is configured the way it was.--------------------keeping it simple... |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-17 : 03:15:23
|
instead of msdb... it's actually model  so since the guest account is in model, then all databases that gets created have it also...and i can't remove it  just like sql2005 --------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-17 : 11:42:25
|
quote:
Originally posted by jen
instead of msdb... it's actually model so since the guest account is in model, then all databases that gets created have it also...and i can't remove it just like sql2005
you should be able to remove the account from model. I only see the guest account in master, msdb and tempdb. This article talks about problems that occur if you delete the guest account http://support.microsoft.com/default.aspx/kb/315523 There is also information there about removing guest account access from your model system db and any of your user databases.-ec |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2006-02-17 : 15:30:18
|
| If it is like my model guest user; you will get an error on dropping it.It appears to be an EM display query issue since the user has no right to model.Edit: select hasdbaccess from sysusers where name = 'guest' returns 0 which means it has no access to model.Tim S |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-19 : 20:09:32
|
and the query would also return the database roles (db_owner, etc)if i patch it up with ms03-031, will this resolve it or it's nothing to resolve?If it's EM displaying the wrong message, then something needs to be patched?TIAquote:
Originally posted by TimS
If it is like my model guest user; you will get an error on dropping it.It appears to be an EM display query issue since the user has no right to model.Edit: select hasdbaccess from sysusers where name = 'guest' returns 0 which means it has no access to model.Tim S
--------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-19 : 20:51:07
|
| jen, when you apply service packs, do you also apply the SP to your workstation where your run EM from?-ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-19 : 21:55:35
|
| on target ECI assumed that the SP was installed on my workstation since we've applied sp4 months before I joined the company. Thanks!--------------------keeping it simple... |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2006-02-21 : 09:47:08
|
| FYI:I have found out what caused the issue "guest account, via group membership" in EM; I duplicated the issue by adding SQLServer2005_BC.msi to my laptop; the problem appeared after that on it.Note:I also added SQL 2000 SP4, SQL 2000 hotfix 2162, sqlncli.msi, SQLServer2005_SQLCMD.msi without the problem happening.Edit: My laptop has ONLY client tools no server components.I was looking at an SQL 2000 SP4 with hotfix 2162 model DB.Tim S |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-22 : 07:34:45
|
| hmm... unusual...mine only appeared on all of the new databases after i've installed sql2005 express on my workstationbut for previous databases, there were noneand these accounts also appear on sql2005--------------------keeping it simple... |
|
|
|
|
sp4 and guest account...