July 21, 2008 at 2:00 pm
We have a specific database that about once a month looses all of the logins associated with it. In SQL Enterprise Manager under the specific database if you go to "Users" the list is empty until you detach and re-attach the database. Then it is fine again for another few weeks.
We have been unable to determine where these users are going, they are not being deleted because a re-attachment of the database wouldn't correct it if they are deleted. All the SID's match between the Master databases and the sysusers table.
July 21, 2008 at 6:06 pm
Are these SQL accounts or Domain accounts?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 8:32 pm
They are all SQL accounts
July 21, 2008 at 10:12 pm
Rats. It's much easier to come up with reasons why it might lose the SID mapping to AD.
Have you tried SELECT * FROM SYSUSERS when this happens?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply