Text Quote Post |Replace Attachment Add link Text to display: Where should this link go? Repairing "1718 (0x6b6)" For Free Processing "14054 (0x36e6)" For Fre... Check The Instruction to Resolve. That way, the job will never fail due to permissions like this. his comment is here
Then change it back to AD\Administrator and click ok. Click OK. 1 Message Author Comment by:data_bits2014-10-10 Comment Utility Permalink(# a40373436) Zberteoc, This works as you have outlined. Join the community Back I agree Powerful tools you need, all for free. Also, I was unable to get transactional replication to work with either a VA or an MSA--in both cases the Job History log always showed an authentication error.
Could Not Obtain Information About Windows Nt Group/user 0x5
change the service account for the SQL Server agent service to account with proper permissions. Join the community of 500,000 technology professionals and ask your questions. Thanks for helping!as is Marked as answer by Arthur_LiMicrosoft contingent staff, Moderator Monday, February 20, 2012 7:58 AM Friday, February 17, 2012 5:46 PM Reply | Quote All replies 0 Sign How to respond to your boss's email about a coworker's accusation?
Browse other questions tagged sql sql-server replication sql-server-agent or ask your own question. Who created the Secret Stairs as a way into Mordor and for what purpose? So unfortunately it's not the answer in this particular case... –Mike Aug 6 '12 at 4:31 add a comment| up vote 1 down vote accepted I tried the other two answers Could Not Obtain Information About Windows Nt Group/user Error Code 0x54b hth Marcin Friday, February 17, 2012 4:20 PM Reply | Quote 0 Sign in to vote The error you are getting indicates Access denied - so check first the security context
Try changing the permissions to give everyone full control to see if that fixes the problem. Unable To Determine If The Owner Of Job Has Server Access Error 15404 SQL Server Jobs Error: The job failed. The number of ways of selecting 6 shoes from 8 pairs of shoes so that exactly 2 pairs of shoes are formed What does ''overdue for a spurt'' mean? Windows could not obtain the name of a domain controller.
A service account is the next best thing, as long as you have it configured right and it's never at risk of being locked-out or disabled. –NateJ Jan 15 at 16:42 Could Not Obtain Information About Windows Nt Group/user Error Code 0x6ba Comment on this post Follow me via RSS Subscribe Subscribe to be notified of future posts. Covered by US Patent. Now we have some trouble with setting up replication, generally we have error: "Could not obtain information about Windows NT group/user 'DOMAIN\user', error code 0x5", when try to start or delete
Unable To Determine If The Owner Of Job Has Server Access Error 15404
Please help! First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Could Not Obtain Information About Windows Nt Group/user 0x5 You cannot send private messages. Could Not Obtain Information About Windows Nt Group/user Error Code 0x5. Sqlstate 42000 (error 15404 It could be because the AD server is busy, down or cut off from the network, or that the SQL Server service account doesn't have rights.
A job uses this stored procedure: msdb.dbo.sp_sqlagent_has_server_access @login_name = 'OLD\Administrator' Which uses this one: EXECUTE master.dbo.xp_logininfo 'OLD\Administrator' Which gives this SQL error 15404 select text from sys.messages where message_id = 15404; Why are static password requirements used so frequently? Navigate to Job Properties > General Page. the service RPC cannot restart manually, that why we have to restart the box to resolve the problem.(Sorry don't know how to change the color for more clear reading)[color=#FF0000]This computer was Could Not Obtain Information About Windows Nt Group/user Error Code 0x534
I just add to checklist for this problem: check domain controller is accessible share|improve this answer answered Aug 4 '14 at 11:26 Rail 47247 add a comment| up vote 1 down Could Not Obtain Information About Windows Nt Group/user 0x6e Note that I haven't changed my password recently. –redcalx Apr 9 '15 at 9:46 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote accepted Not a You cannot edit other events.
Set the value of Owner to SA.
October 19 2016 Though MAC computer turns hot topic recent years, windows os computers are still used most frequently among users from worldwide.
Solution of Error Information 0x6e SmartPCFixer is possible to significantly improve the speed of the machine if you address all of the problems just mentioned.
Unable to determine if the owner (AD\Administrator) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'AD\Administrator', error code 0x6e. [SQLSTATE 42000] (Error
MS SQL Server Advertise Here 685 members asked questions and received personalized solutions in the past 7 days.
Can anybosy shed light on what could have happened?
The Agent should be running under an account that is recognized by STAR domain controller. share|improve this answer answered Apr 25 '15 at 17:42 Pete 698 add a comment| up vote 0 down vote For me, the jobs were running under DOMAIN\Administrator and failing with the What is the term for the opposite of "bleed" in printing? Xp_logininfo Could Not Obtain Information About Windows Nt Group/user Launch the Smart PC Fixer tool and make a full scan for your computer or laptop. 3.
Browse other questions tagged security active-directory permissions replication sql-server-2012 or ask your own question. MS SQL Server MS SQL Server 2008 MS SQL Server 2005 Getting Server / Database / Connection Information via T-SQL (SQL Server) Video by: Steve Via a live example, show how What's a word/phrase like "compulsion" or "addiction" that is more about guilt than physiology or anxiety? Each time a job is started, SQL Server verifies the identity of the job owner and checks that it has permission to execute the job.
security active-directory permissions replication sql-server-2012 share|improve this question edited Aug 4 '12 at 16:47 MDMarra 87.4k23149294 asked Aug 4 '12 at 16:24 Mike 5493926 add a comment| 3 Answers 3 active Services that run as virtual accounts access network resources by using the credentials of the computer account in the format (domain_name)\(computer_name)$. share|improve this answer edited Aug 7 '12 at 17:04 answered Aug 7 '12 at 13:06 Mike 5493926 add a comment| up vote 0 down vote Verify that the computers network service The problem can be cleared by rebooting the machine.
Not the answer you're looking for? Are electric bike speed limitations set in stone? Post #1510783 mandavlimandavli Posted Friday, November 1, 2013 2:19 PM Valued Member Group: General Forum Members Last Login: Thursday, October 30, 2014 11:15 AM Points: 52, Visits: 146 We have jobs The Job Owner is the name listed in the error message and is a SQL Server Admin.
Why are static password requirements used so frequently? What Should You Choose SmartPCFixer ? Thanks for helping!as is Marked as answer by Arthur_LiMicrosoft contingent staff, Moderator Monday, February 20, 2012 7:58 AM Friday, February 17, 2012 5:46 PM Reply | Quote 0 Sign in to Restarted SQL - ran the jobs and they are now working again.
We're doing something similar and we have a shared folder set up with permissions for the SQL Server agent account to be able to write to that directory. Restarting SQL Server didn't resolve the issue, but rebooting the machine did. hth Marcin Thanks for reply, Service account is simple AD user, created before installing MSSQL Server, it has only 'Domain Users' group membership.