November 25, 2011 at 12:01 pm
Hello all,
Does anyone have an idea why this is being generated in the windows event log in regards to one of my databases.
An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'domain\user', error code 0x6ba.
this message is being created 10 times a sec 🙁
I have the sql broker set for this database and that domain account is the DB owner .
Any ideas?
John
November 25, 2011 at 12:11 pm
Sounds like an issue accessing the domain controller and verifying that domain user. When you created the login, did you create it exactly the same as what is in AD? The validation that SQL Server does is case-sensitive and if the login/user don't match with AD exactly it will fail.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 25, 2011 at 12:22 pm
Hello... thanks for your reply !
So this is not the problem 🙁
I
've confirmed the database dbo domain account was created in uppercase by default in AD and therefore is the same with the windows login that it's complaining about
November 29, 2011 at 8:39 am
I have verified a few things on AD regarding the account and still getting this message when putting online the particular DB.
Not sure which permissions are wrong but I do notice that the account user and schema in the server login is set to DBO / DBO for the particular database. This doesn't seem right and I can't change it either.
I don't even see the domain account when opening the database / security / logins screens...
any ideas ?
much appreciated
November 29, 2011 at 11:32 am
Can you change the owner of the database to 'sa' - and then add this user with db_owner rights?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply