asked 6 years ago viewed 4158 times active 5 years ago Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title? edit -- Above is the fix I used to workaround this issue, has any one found any other work arounds or resolutions to this issue? current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Does a byte contain 8 bits, or 9? http://crudlet.org/unable-to/sql-server-unable-to-determine-if-the-owner.html
Please try again later or contact support for further assistance. Sql Server Unable To Determine If The Owner Error 15404 If the problem persists, please contact your domain administrator. Interview question "How long will you stay with us?" Depowering a high AC PC without killing the rest of the group Theorems demoted back to conjectures Minimum font size for mobile Would society of simultaneous hermaphrodites have gender roles?
Not the answer you're looking for? Error Code 0x5. [sqlstate 42000] (error 15404)). Unable to determine if the owner(xyz\Administrator) of job “abcde” has server access0How to properly re-add a windows administrator user to SQL Server1Installing SQL Server 2008 SP2 fails in 2003 cluster setup1Why Article Number:38430 Products: Education_Edge_EE Financial_Edge Raiser_s_Edge This is a Microsoft SQL Server error. Unable to determine if the owner (domain\username) of job testjob has server access (reason: Could not obtain information about Windows NT group/user 'domain\username'. [SQLSTATE 42000] (Error 8198)) when backing up the
share|improve this answer edited Jan 8 '13 at 14:34 Raj More 30.7k1987161 answered Jan 3 '13 at 18:44 Bacon Bits 11.4k11526 add a comment| up vote 2 down vote We encountered http://stackoverflow.com/questions/1234570/could-not-obtain-information-about-windows-nt-group-user Does "Excuse him." make sense? Unable To Determine If The Owner Of Job Has Server Access Error 15404 Now I am trying to execute Maintenance Plan and I am getting following error, Unable to determine if the owner (x-x-x-x\Administrator) of job Backup.DB Backup has server access (reason: Could not Unable To Determine If The Owner (sa) Of Job Has Server Access I can logon to each server as CBMIWEB\johna.
Friday, March 11, 2011 10:18 PM Reply | Quote 0 Sign in to vote Hi, I would recommned you drop your lcoal administrator account in SQL Server (
No proxy account. ALL RIGHTS RESERVED. Can you run this command and post the output here xp_logininfo 'xx\administrator' Thanks, Leks Friday, March 11, 2011 8:02 PM Reply | Quote 0 Sign in to vote I login as http://crudlet.org/unable-to/sql-server-scheduled-job-unable-to-determine-if-the-owner.html I believe it's the reason.
Later you can change the Job Owner back to CBMIWEB\johna." share|improve this answer answered Sep 24 '10 at 22:57 DaniellaMercuryFan 2041415 Thanks for coming back to post the correct Ssrs Unable To Determine If The Owner Of Job Has Server Access Thanks, BV Friday, March 11, 2011 9:27 PM Reply | Quote 0 Sign in to vote It seems like there is some issue in your account that you are trying to This could be caused by a name resolution failure.
You cannot delete your own posts. Please let me know if that helps.Best Regards, Chunsong Feng Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a SQL Server > SQL Server Security Question 0 Sign in to vote Hello, Please help me with following case, SQL Server 2008 Web Edition SQL Server Service running as -> Local Ssis Unable To Determine If The Owner Of Job Has Server Access So, John...
The "owner" of the job is also CBMIWEB\johna which is a domain userid in the local Administrators group of each machine (both TUNA and MOJITO). 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 See here: brentozar.com/blitz/jobs-owned-by-user-accounts . have a peek here There is a credential on MOJITO defined for CBMIWEB\johna.
Attachments SOL98791_98791_0 See More LiteSpeed for SQL Server Articles Feedback submitted. You cannot send emails. Relevant troubleshooting info SSRS report subscriptions are executed as SQL Jobs that the Report Server web UI creates for you behind the scenes. How do I debug this?
Browse other questions tagged sql sql-server replication sql-server-agent or ask your own question. When looking at the job that was created for my report subscription, I saw that it always failed with the error: The job failed. Unable to determine if the owner (domain\login) of job MaintenancePlan - ABC.Full backup has server access (reason: Could not obtain information about Windows NT group/user 'domain\login', error code 0x5. [SQLSTATE 42000] That was the database integrity is maintained –openshac Aug 2 '11 at 9:18 add a comment| 2 Answers 2 active oldest votes up vote 5 down vote I was running into
Description Error: The Job failed. Thursday, September 04, 2014 1:51 AM Reply | Quote 0 Sign in to vote Hi, Change the owner of the sqlagent Job for the maintenance plan to sa and Keep it. Please let me know what could be the reason?