Error De Sql Server 15404
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQLServer Error: 15404 with Active Directory SQL Server > SQL Server Security Question 0 Sign in to vote Hello, I'm having trouble running jobs sql server error 15404 could not obtain information about windows nt with my active directory (ADS) account. I've setup my SQL services to run under an error de sql server 17 ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2. Here error de sql server 18456 is the error message: == The job failed. Unable 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 sqlserver error 15404 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 have done a *lot* of searching and cannot find the solution. I believe the 0x5 code is access denied. The same job runs if I change the owner to a SQL login that's not an ADS account. I'm not certain how to confirm that the
Sqlserver Error 15404 Could Not Obtain Information About Windows Nt Group
SQL Agent account is the account actually querying ADS, also. Any help would be greatly appreciated! Thanks, -Tony Monday, April 09, 2007 7:04 PM Reply | Quote Answers 2 Sign in to vote In my working scenario, the SQL Server service was running as a domain user in Domain A. In the non-working scenario, the SQL Server service is running as a local account that does not have domain access to Domain B. I set it up this way because I thought it was the SQL Agent account that was actually doing the AD query. I changed the SQL Server service to run as a domain user account and the agent jobs now appear to be working when a domain account is the owner. I am going to do some more testing, but I think that the SQL Server service account was my problem. Thank you very much, Raul. Wednesday, October 10, 2007 4:27 PM Reply | Quote All replies 0 Sign in to vote Correct, the error code 0x5 is ERROR_ACCESS_DENIED, and from the whole error message I would guess that it is the SQL Server service account the one failing to issue the query to the AD. Verify that SQL Server service account has permission to query the AD. -Raul Garc
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
Sqlserver Error 15404 Connisloginsysadmin
About Us Learn more about Stack Overflow the company Business Learn more about sqlserver error 15404 could not obtain information about windows nt group/user ' hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss sqlserver error 15404 could not obtain information about windows nt group/use Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Could not obtain information https://social.msdn.microsoft.com/Forums/sqlserver/en-US/841a5446-6689-4612-8629-5029a341a77e/sqlserver-error-15404-with-active-directory?forum=sqlsecurity about Windows NT group user up vote 20 down vote favorite 2 I am creating a SQL Server Replication using a script. When I try to execute The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Could not obtain information about Windows NT group/user 'STAR\moorer7', error code 0x5. [SQLSTATE 42000] (Error 15404)). This is a job created http://stackoverflow.com/questions/1234570/could-not-obtain-information-about-windows-nt-group-user by a script that defines replication. How do I debug this? 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 29.8k1786155 I changed the owner in job properties to 'sa' then the issue solved. –Alex Aug 13 at 7:25 add a comment| 7 Answers 7 active oldest votes up vote 30 down vote accepted Active Directory is refusing access to your SQL Agent. The Agent should be running under an account that is recognized by STAR domain controller. share|improve this answer edited Mar 24 '14 at 20:20 atticae 5,29263890 answered Aug 5 '09 at 17:30 Remus Rusanu 206k25268405 @Remus Rusanu:The agent is running under a local machine account as MyWorkstation\SqlServerAccount –Raj More Aug 5 '09 at 17:58 8 @Raj: Actually since is the SQL Server itself that is connecting to the AD, you need to change the account under which SQL is running. 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). SSMS or EM can have an option t
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=122295 | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums SQL Server Administration (2005) SQL Error 15404: Could not obtain information... Reply to Topic Printer Friendly Author Topic Earp Starting Member 1 Posts Posted-03/23/2009: 14:55:09 I'm getting the following message in the SQL Sever Logs:Date 3/23/2009 2:43:00 PMLog SQL Agent (Current - 3/23/2009 2:43:00 PM)Message[298] SQLServer Error: 15404, server error Could not obtain information about Windows NT group/user 'domain\projserver', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)But the user it is trying to find information about is not a valid user in Active Directory or a valid SQL server login. It was at one time, but the user was deleted. I'm not sure if a database is still looking for this user, but I checked the permissions for each DB and none list this "projserver" account. This account was one we server error 15404 originally set up during a Project Sever installation, but the databases were erased and the software was re-installed. So my guess is that something somewhere is still looking for this account. But I'm not sure where to look. Any ideas?Also, under Permissions on a few of the Project Server databases, under Permissions, a user or role named "U_MSP_DAL_Cert" was listed, but if I clicked on Effective Permissions, I get the following error:An execption occurred while executing Transact-sQL statement or batch. --> Cannot execute as the database principal because the "U_MSP_DAL_Cert" does not exist, this type of principal cannot be impersonated, or you do not have permission.No idea what this error means either. Any help on it? 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 comes back with any rows then those id's are orpahned users.If it comes back with no results then everything is fine.r&r lapers Starting Member 1 Posts Posted-02/22/2012: 07:47:38 I had same error message. My solution was that owner of database was domain user. So if domain not available I got this error. I changed owner of database to sa user and everything works fine even if domain is not available. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums Ne