Error 15404 Sqlstate 42000
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQLSTATE 42000- Error 15404 with ADS SQL Server > SQL fehlercode 0x5 sqlstate 42000 fehler 15404 Server Security Question 0 Sign in to vote Hello, I'm having trouble
Sqlstate 42000 Connisloginsysadmin
running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS
Sqlstate 42000 Error 15404 Sql Server 2008 R2
account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2. Here is the error message: == The job failed. Unable
Sql State 42000 Error 15404
to determine if the owner (ADS\me) of job eFASRtest has server access (reason: Could not obtain information about Windows NT group/user 'ADS\me', error code 0x5. [SQLSTATE 42000] (Error 15404)). == also this message in log: == [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ADS\me, error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin) == I already error sqlstate 42000 syntax error or access violation 1064 tested the suggested: execute as login='ads\me' and I get the same error on both (my local installations and production) appreciate your help Tuesday, August 07, 2007 2:56 PM Reply | Quote Answers 0 Sign in to vote Most likely the machine account doesn’t have permission to query the AD. I would recommend requesting access to the AD administrator or change SQL Server and run the service as a low-privileged domain account that has proper permissions on the AD. -Raul Garcia SDE/T SQL Server Engine Thursday, August 09, 2007 5:57 AM Reply | Quote Moderator All replies 0 Sign in to vote Which service account is the SQL Server running with ?Jens K. Suessmeyer---http://www.sqlserver2005.de--- Tuesday, August 07, 2007 5:45 PM Reply | Quote Moderator 0 Sign in to vote We are using the Local system account Tuesday, August 07, 2007 9:01 PM Reply | Quote 0 Sign in to vote Most likely the machine account doesn’t have permission to query the AD. I would recommend requesting access to the AD adminis
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » sqlstate 42000 error 22029 SQL Agent Job Fails when domain user is owner... SQL Agent Job Fails sqlstate 42000 error 22029 transaction log when domain user is owner Rate Topic Display Mode Topic Options Author Message huskerwendyhuskerwendy Posted Wednesday, July 30, 2008 4:19 sqlstate 42000 error 50000 PM SSC Eights! Group: General Forum Members Last Login: Tuesday, August 10, 2010 1:22 PM Points: 961, Visits: 409 I can't execute any jobs with a domain user as the owner. As a work https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9dddf08e-929c-43b4-bc10-ac8f36cbb023/sqlstate-42000-error-15404-with-ads?forum=sqlsecurity around, I've been using sa as the owner, but for this job it won't work because I have to access some directories on the network and we want to give those permissions to a specific login. Does anyone know what I need to do in order to execute a job with a domain user as the owner? Error Message:The job failed. Unable to determine if the owner http://www.sqlservercentral.com/Forums/Topic543954-146-1.aspx (domain\user.name) of job jobname has server access (reason: Could not obtain information about Windows NT group/user 'domain\user.name', error code 0x5. [SQLSTATE 42000] (Error 15404)).Thanks! Wendy Schuman Post #543954 Deepak-405225Deepak-405225 Posted Wednesday, July 30, 2008 9:33 PM SSC-Addicted Group: General Forum Members Last Login: Friday, October 26, 2012 2:14 PM Points: 402, Visits: 598 You can try as follows,1. Keep the job owner as sa (sysadmin) and in the job step use xp_cmdshell2. Ensure that the Sql Service account has necessary permissions to the folders you wish to access because xp_cmdshell for a sysadmin will run under the context of Sql service account.Also please check if this link helps, http://support.microsoft.com/kb/241643/ - Deepak Post #544043 huskerwendyhuskerwendy Posted Thursday, July 31, 2008 12:27 PM SSC Eights! Group: General Forum Members Last Login: Tuesday, August 10, 2010 1:22 PM Points: 961, Visits: 409 Hi Deepak,I got it to work as you mentioned by keeping the job owner sa and then giving the necessary permissions to the directories to the SQL Server Agent service account. I didn't need to do anything with xp_cmdshell because the job is actually executing an SSIS package.Thanks! Wendy Schuman Post #544631 Alan SpillertAlan Spillert Posted Wednesday, July 7, 20
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://dba.stackexchange.com/questions/54553/how-to-clear-an-error-15404-after-a-db-restart-besides-rebooting Learn more about Stack Overflow the company Business Learn more about hiring developers or https://www.experts-exchange.com/questions/28535234/New-agent-jobs-fails-with-Could-not-obtain-information-about-Windows-NT-group-user-'DOM-USER'-error-code-0x6e-SQLSTATE-42000-Error-15404.html posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody state 42000 can ask a question Anybody can answer The best answers are voted up and rise to the top How to clear an Error 15404 after a DB restart (besides rebooting) up vote 6 down vote favorite 3 Every so often (e.g. ~months) a SQL Server Agent hourly Job will begin reporting an Error 15404 and continue to do so until intervened with. [298] SQLServer Error: 15404, Could not state 42000 error obtain information about Windows NT group/user 'DOMAIN_NAME\SomeDomainAccount', error code 0x6e. [SQLSTATE 42000] (ConnIsLoginSysAdmin) Sometimes the first failure occurs immediately after a manual restart of the SQL Server Engine and SQL Server Agent services. The problem can be cleared by rebooting the machine. The Job Owner is the name listed in the error message and is a SQL Server Admin. The SQL Server Engine Service account looks to be a service account (I believe it is the default install account (one notch better than generic NetworkService to prevent interference between Engine/Agent instances): NT Service\MSSQL$INSTNAME It would be one thing if the job always failed but since the job succeeds after a reboot it makes me think that a service account like is supposed to be working and that there is some A/D timing issue or possibly a bug. 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. A machine reboot clears the problem. An immediate subsequent restart of the engine and agent no longer cause the job to fail. Link: How to troubleshoot a SQL Server 8198 error sql-server sql-server-agent active-directory jobs share|improve this question edit
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > New agent jobs fails with : Could not obtain information about Windows NT group/user 'DOM\USER', error code 0x6e. [SQLSTATE 42000] (Error 15404) Want to Advertise Here? Solved New agent jobs fails with : Could not obtain information about Windows NT group/user 'DOM\USER', error code 0x6e. [SQLSTATE 42000] (Error 15404) Posted on 2014-10-10 MS SQL Server MS SQL Server 2008 1 Verified Solution 3 Comments 2,961 Views Last Modified: 2014-10-15 Our windows engineer installed SQL Server 2012 and created an instance of SQL Server. I'm trying to get things set up for backups, etc. The creations of the maintenance plans and agent jobs are successful. However, when I try to execute them, they fail with the following errors: Log Job History (LOCUS System Database FULL Backups.Subplan_1) Step ID Server DEVLOCKDB1\LOCUSSYSTEM Job Name LOCUS System Database FULL Backups.Subplan_1 Step Name Duration 00:00:00 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message The job failed. Unable to determine if the owner (LOCUS\locusadmin) of job LOCUS System Database FULL Backups.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'LOCUS\locusadmin', error code 0x6e. [SQLSTATE 42000] (Error 15404)). I found mention of this kind of error when there has been service packs and hot fixes applied without reboot. That is not the case here. Thanks. 0 Question by:data_bits Facebook Twitter LinkedIn Google LVL 26 Active 2 days ago Best Solution byZberteoc To resolve this issue: Launch Microsoft SQL Server Management Studio and connect to the database. In the Object Explorer, navigate to SQL Server Agent > Jobs. Right click the maintenance plan that Go to Solution 3 Comments LVL 26 Overall: Level 26 MS SQL Server 21 MS SQL Server 2008 15 Message Active 2 days ago Accepted Solution by:Zberteoc2014-10-10 To resolve this issue: Launch Microsoft SQL Server Management Studio and connect to the database. In the Object Explorer, navigate to SQL Server Agent > Jobs. Right click the maintenance plan that you used during the initial creation of the job and click Properties. Note: The maintenance plan has the format MaintenancePlan_Name.Subplan_x. Navigate to Job Properties > General Page