Null User
-
I have a null user somewhere on my server. Is there a simple query that would show me which DB it is? I have an article for my error which I am trying to resolve:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q218172&
Thanks!
Neil
-
Not sure, but I think running sp_change_users_login 'report' may help.
Andy
-
I was hoping to find somethign that ran that on all the databases. Right now none of these databases show a DBO user which I can't imagine is good!
Right?
Neil
-
I dont think its that bad. Been a while since I have seen it, drawing a blank. Did you try the sp_change I posted earlier to see if it found anything?
Andy
-
Try
sp_MSForEachDB '
PRINT ''----------------------------''
PRINT ''?''
PRINT ''----------------------------''
EXEC
..sp_change_users_login ''report'''Should give a nice output for all the DBs and allow you to see what data is from where.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
-
Hi,
the following query will show u null user that is BUILTIN\Administrators:
"select * from syslogins"
SaNaZ
-
I don't see a syslogins table in any of my databases and the query you posted returns an Invalid Object Name error. Any idea why? I am running 2000.
Mercy,
Afshin
-
The syslogins table is in the Master DB. Open Query Analyzer and run it from there. I could not see it in EM either. I presume it must be hidden, somehow?! Is that the case...? Anyone? If so, why?! I'm Just curious plain now!
Aside from BUILTIN\Administrators being NULL, Domain Groups are also NULL.
Clive Strong
-
Yes, I looked in that database in EM and didn't see the syslogins table either. Also, what is a domain group?
-
Another thing, I just ran the query in the master database and the results shows that the BUILTIN user does not have a NULL name or loginname. Is this the same for you? The name and loginname columns in my database are filled with the "BUILTIN/Administrators" value.
-
There is a syslogins table in master. It may be materialized, so do not use EM. Use Query Analyzer to run "select * from syslogins"
A domain group is an NT group.
None of mine are NULL.
Check sysusers table in each database and look for a NULL or for a sid not matching in master.dbo.syslogins.
Steve Jones
-
Syslogins is a view. The table is sysxlogins.
Andy
-
I removed the one null user but I still have the problem below:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q218172&
Any ideas?
Neil
-
Neil,
I went to the site and they have posted a workaround for your problem. Have you tried the workaround and did it work?
-
To work around this problem, use the sp_changedbowner stored procedure to change the owner of any databases owned by a login that does not exist on the new server to a login that does exist on the server.
How do I determine that?
Neil
..sp_change_users_login ''report'''Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply