sexta-feira, 17 de agosto de 2012 06:25
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?
Todas as Respostas
sexta-feira, 17 de agosto de 2012 06:33
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
sexta-feira, 17 de agosto de 2012 14:21
Well there is no SQL Server 2007. We only have following version of SQL Server:
- SQL Server 2000
- SQL Server 2005
- SQL Server 2008 & 2008 R2
- 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.
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
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.
sexta-feira, 17 de agosto de 2012 15:14
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?