Home > Error Code > Error 15404 Could Not Obtain Information About Windows Nt Group/user

Error 15404 Could Not Obtain Information About Windows Nt Group/user

Contents

Would presence of MANPADS ground the entire airline industry? You can then run "EXECUTE AS USER = ‘domain\user'" on SQL Server to check. SharePoint 2013: Event 8193: A failure was reporte... ► May (15) ► April (13) ► March (8) ► February (11) ► January (14) ► 2013 (88) ► December (12) ► November SQL Agent service running as Domain A\SQLAgentAcct. weblink

What's the correct term to describe baby food? You cannot send private messages. If nothing else, it poses job security as it doesn't seem to be part of general knowledge that domain ownerships cause problems later on down the line. When IT is asked about the A/D configuration, the response is usually "nothing has changed." Restarting the engine and agent services can cause the job to start failing. website here

Error 15404 Sqlstate 42000

Explain it to me like I'm a physics grad: Greenhouse Effect How can I turn rolled oats into flour without a food processor? Maintaiance plan was giving me error . You may read topics.

Could not obtain information about Windows NT group/user 'ALPHA\myaccount', error code 0x5. The domain account used is set as a server admin and as sysadmin.Setting the jobs to run under 'sa' is a workaround, but best practice is not to use 'sa' and Output the first position in your program for each input character The female equivalent of "don't break my balls" What is this picture in Thrawn's study of? Could Not Obtain Information About Windows Nt Group/user Error Code 0x54b You cannot edit your own topics.

See here: brentozar.com/blitz/jobs-owned-by-user-accounts . Error Code 0x5 Sqlstate 42000 Connisloginsysadmin Kitts & Nevis St. Post #1270039 MannySinghMannySingh Posted Wednesday, March 21, 2012 8:34 AM SSChasing Mays Group: General Forum Members Last Login: Friday, December 16, 2016 12:00 PM Points: 647, Visits: 763 Try to use my review here So, it looks like the service account has permission to check itself in ADS, but not other ADS objects. (Assuming the SQL Server Service account is the account actually making the

All actions I do from domain admin account 'Administrator' (also MSSQL Server administrator - specified during install) Whe I log on with SQL service account, in same tab I can see Could Not Obtain Information About Windows Nt Group/user Error Code 0x2 You cannot edit other topics. OK × Contact Support Your account is currently being set up. Restarted SQL - ran the jobs and they are now working again.

Error Code 0x5 Sqlstate 42000 Connisloginsysadmin

The errors received from SQL Agent logs did not mention the service account's name, just the name of the user (job owner) that couldn't be authenticated (since it uses the service The Agent should be running under an account that is recognized by STAR domain controller. Error 15404 Sqlstate 42000 SSMS or EM can have an option to change the service account. –Remus Rusanu Aug 5 '09 at 19:09 2 +1 for keeping me from having to talk to my Error Code 0x6e. [sqlstate 42000] (error 15404)). Thanks for the clarification.      It seems like it is a limited account on the AD and doesn’t have permission to query, hopefully the AD admin will be able to

SharePoint 2013: How to move Central Administratio... have a peek at these guys I may not have it completely right but that's the gist I get. sql sql-server replication sql-server-agent share|improve this question edited Feb 18 '11 at 1:09 asked Aug 5 '09 at 17:13 Raj More 30.7k1987161 1 I changed the owner in job properties You cannot post events. Could Not Obtain Information About Windows Nt Group/user Error Code 0x534

Were defendants at the Nuremberg trial allowed to deny the holocaust? What I can se is that the user failing is \Administrator not \Administrator. Disabling and enabling Read automatically enables all the Read subpermissions. http://strobelfilms.com/error-code/error-15404-could-not-obtain-information-about-windows-nt.html Does gunlugger AP ammo affects all armor?

Perhaps something is corrupting the cache. Could Not Obtain Information About Windows Nt Group User Error Code 0x6e I'm too cold, turn up the temperature Is ATC communication subject to FCC profanity regulations? If your on Vista or Windows7, personally, I would restart the SQL server running as the proper user account.

SQL Server Developer Center   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)

Perhaps there should be something in Connect.Microsoft.com to suggest that it become a best practice and that the interface do it for us when we create the job if it runs Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). You cannot edit your own events. Error Code 0x534 Sqlstate 42000 Error 15404 If the computer name changed from OLD to NEW.

Does it have necessary rights? If this query fails then we will need to find out what part of the AD queries the account is restricted to perform.     -Raul Garcia    SDE/T    SQL When executing a maintenance plan I get the same error. http://strobelfilms.com/error-code/error-15404-could-not-obtain-information.html Is it bad form to write mysterious proofs without explaining what one intends to do?

Wife Works in LA. You cannot delete other posts. You cannot rate topics. Thanks for helping!

You cannot post topic replies. Powered by Blogger. Domain B\SQLAgentAcct has sysadmin rights in SQL.  Also belongs to Domain Users domain group and the local Administrators group. An immediate subsequent restart of the engine and agent no longer cause the job to fail.

Failing that try changing it to run under a SQL Account such as the sa account so that it doesn't need to check for domain credentials before running the job. Click OK. Instead of this function I ended up using select 1 from sys.database_principals u inner join sys.database_role_members ur on u.principal_id = ur.member_principal_id inner join sys.database_principals r on ur.role_principal_id = r.principal_id where r.name Enter the SQL Server servicedomain account and click OK.

A published paper stole my unpublished results from a science fair What to do when using your private key from another computer? Vincent & Grenadines Suriname Swaziland Sweden Switzerland Tanzania Thailand Togo Trinidad y Tobago Turkey Turks & Caicos Islands Uganada Ukraine United Kingdom United States Uruguay US Virgin Islands Venezuela Yemen Zambia