User Security group keeps disapering from database

Question

Hey All

I have an sql server 2007 with several databases on. I have a problem with a security group, it keeps disapering automaticaly from the database where 
the security group is attatched to. Is is very strange. How it is possibel for a user security group just to disapear from its attatcged database?

Answer 1

Hi,
Is it SQL server 2008? there is no 2007 version for SQL server.
Do you mean the windows AD groups are not apearing under Login on server level once you attach the database?

---

Kindly mark the reply as answer if they help

Answer 2

Well there is no SQL Server 2007. We only have following version of SQL Server:

1. SQL Server 2000
2. SQL Server 2005
3. SQL Server 2008 & 2008 R2
4. SQL Server 2012

Assuming you have one of these versions and you are sysadmin of the boxes then the only thing I can think of is that some how your SSMS is corrupt. I suggest you to re-install the client tools to see if it fixes the issue.

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 3

You should consider running a trace, or using DDL event notification to alert you when a user/login gets dropped.

Do you know of any changes to the Windows group, or the login that coincide with the disappearance of the database user? 

---

Thanks, Andrew