Home > Error Code > Error 15404 Could Not Obtain

Error 15404 Could Not Obtain


Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Server is now a member of Domain B (AD).  Also, all accounts involved now belong to Domain B. See here: brentozar.com/blitz/jobs-owned-by-user-accounts . See More MessageStats Articles Feedback submitted. http://strobelfilms.com/error-code/error-15404-could-not-obtain-information.html

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 or other way to aproach privileges?1Sql Server 2008 Backups not quite running2How to schedule daily backup in MSSQL Server 2008 Web Edition0Scripting a database copy from MS Sql 2005 to 2008 Copyright © 2002-2016 Redgate. The offending line of SQL was a CREATE ASSEMBLY statement, AUTHORIZATION [dbo], PERMISSION_SET = EXTERNAL_ACCESS; –redcalx Apr 9 '15 at 9:34 More info.

Error 15404 Sqlstate 42000

SharePoint 2013: Event 8193: A failure was reporte... ► May (15) ► April (13) ► March (8) ► February (11) ► January (14) ► 2013 (88) ► December (12) ► November Verify that SQL Server service account has permission to query the AD.     -Raul Garcia    SDE/T    SQL Server Engine Tuesday, April 10, 2007 1:10 AM Reply | Quote We added a script to the VM cloning/deployment process that re-creates the SQL login.

You cannot post EmotIcons. Report Abuse. SharePoint 2013: Add a Link to My Site Quick Launc... Error Code 0x534 Sqlstate 42000 Error 15404 Account Information: Account Name:[email protected] Account Domain:BETA.CORP Logon GUID:{00000000-0000-0000-0000-000000000000} Service Information: Service Name:cifs/DC1.alpha.corp Service ID:S-1-0-0 Additional Information: Ticket Options:0x40810000 Ticket Encryption Type:0xffffffff Failure Code:0xc Transited Services:- Solution: Enable 'Allowed to authenticate'

How do I debug this? Sql Server Could Not Obtain Information About Windows Nt Group/user Error Code 0x5 Is this behaviour of GPIO pins normal? My solution was that owner of database was domain user. http://www.sqlservercentral.com/Forums/Topic1270039-1550-1.aspx Is ATC communication subject to FCC profanity regulations?

On the Properties dialog, select this account in the Group or user names list. Error Code 0x5. [sqlstate 42000] (error 15404)). You cannot delete other posts. Maintaiance plan was giving me error . SharePoint 2013: The option for the SharePoint 201...

Sql Server Could Not Obtain Information About Windows Nt Group/user Error Code 0x5

Autodiscover HTTP 400 Microsoft's UK datacentres: what you need to know Blogroll biz blog risual support blog Meta Log in Entries RSS Comments RSS WordPress.org Contact Info Risual House, 12 Parker http://dba.stackexchange.com/questions/54553/how-to-clear-an-error-15404-after-a-db-restart-besides-rebooting You cannot rate topics. Error 15404 Sqlstate 42000 You cannot edit your own topics. Error Code 0x5 Sqlstate 42000 Connisloginsysadmin share|improve this answer answered Jun 21 '15 at 19:12 SQL Nerd 1094 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google

You cannot delete other topics. http://strobelfilms.com/error-code/error-15404-could-not-obtain-information-about-windows-nt-group-user.html Are zipped EXE files harmless for Linux servers? 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 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 Error Code 0x6e. [sqlstate 42000] (error 15404)).

Not the answer you're looking for? Also check SQL Server Configuration Manager for SQL Server Agent account. SharePoint 2013: App Management Shared Service Pro... http://strobelfilms.com/error-code/error-15404-could-not-obtain-information-about-windows-nt.html I try my best to get jobs and maintenance plans out of my name [as the dba] before I leave a position so the new guy coming in doesn't need to

Too many advisors Could large but sparsely populated country control its borders? Could Not Obtain Information About Windows Nt Group/user Error Code 0x534 Has my macOS Sierra system been infected by unknown users? Help, my office wants infinite branch merges as policy; what other options do we have?

You cannot post JavaScript.

An admin that left the company created these maintenance plans. Request unsuccessful. Username: Password: Save Password Forgot your Password? Could Not Obtain Information About Windows Nt Group/user Error Code 0x54b more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

revdnrdy Posting Yak Master USA 220 Posts Posted-03/23/2009: 17:37:21 I am not sure but perhaps you have an orphaned user?What happens when you run this command?EXEC sp_change_users_login 'Report'If it Windows will save the credentials it looks up for later use. I'm not certain how to confirm that the SQL Agent account is the account actually querying ADS, also. this content Ensure that Read is enabled and all its subpermissions (eg, Read account restrictions, Read general information, etc).

OK × Welcome to Support You can find online support help for*product* on an affiliate support site. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Technically speaking it means "run under the service account", but to do so, we reference it with an account labeled "sa". Click continue to be directed to the correct support content and assistance for *product*.

Hot Network Questions Why did it take longer to go to Rivendell in The Hobbit than in The Fellowship of the Ring? 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. 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 Verify connection to the domain listed, and verify the user/group listed. - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA,

Which I guess is correct, under the circumstances. You asked this 7 years ago and it's still helping people like me today. –PowerUser Dec 6 at 17:44 add a comment| 7 Answers 7 active oldest votes up vote 30 Here is a screenshot of it: share|improve this answer answered Jan 12 '10 at 22:27 djangofan 2,95843248 add a comment| up vote 0 down vote I had the same problem . 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.

It has to be an account AD will authenticate, like a domain account or the NETWORK SERVICE account(provided the machine is joined to the domain). Disabling and enabling Read automatically enables all the Read subpermissions. SQL Agent job owner = Domain B\Developer Agent job runs successfully.  Domain A\SQLAgentAcct while logged into Domain A is able to get information about Domain B\Developer.  I assume because of the Browse other questions tagged sql sql-server replication sql-server-agent or ask your own question.

share|improve this answer answered Mar 4 '15 at 0:51 mniles 111 add a comment| up vote 0 down vote I had to connect to VPN for the publish script to successfully 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 However, when we finally deleted the account (in AD) the Maintenance jobs started to fail. I changed owner of database to sa user and everything works fine even if domain is not available.

Perhaps something is corrupting the cache. You cannot delete your own topics.