Can't add NT group into Security

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Can't add NT group into Security

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2008-01-24 : 13:18:40

Hi there

I got this very weird issue on of our SQL2005 box. For some reason, can't add an NT group. Adding NT user is no issue at all.

It keeps saying:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Login 'EEE\EEE-SL-SQL-MAX_QRY-DBOWNER'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Windows NT user or group 'EEE\EEE-SL-SQL-MAX_QRY-DBOWNER' not found. Check the name again. (Microsoft SQL Server, Error: 15401)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

The SQL Version is SP2 - 9.0.3042. BTW ... I've renamed the actual group name for security purpose.

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-01-24 : 14:01:26

http://support.microsoft.com/kb/324321

maybe this helps

dewacorp.alliances

452 Posts

Posted - 2008-01-24 : 14:13:11

quote:
Originally posted by sodeep

http://support.microsoft.com/kb/324321

maybe this helps

Thanks Sodeep. What I found with this box is that when you try to login (terminal service client), the box won't accept the domain account for some reason (can't contact the domain). Actually sometimes is working and sometimes isn't ?!?!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-24 : 22:41:01

Communication error, check dns and/or wins. Rebooting can fix the problem in most case.

dewacorp.alliances

452 Posts

Posted - 2008-01-25 : 03:31:52

We found what the problem is. It may relate to SID corruption in Active Directory. So the way to fix it is by going to local box itself and change from the domain back to workgroup and reboot and change back in to the right domain.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources