Error 298 Sql Server
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums sql server error 229 Answered by: SQLServer Error: 15404 with Active Directory SQL Server
Sql Server Error Log
> SQL Server Security Question 0 Sign in to vote Hello, I'm having trouble sql server error 233 running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query
Sql Server Error 53
ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2. Here 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. sql server error 2 [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 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 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
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product at My https://support.software.dell.com/messagestats/kb/104271 SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=122295 are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue Search Sign In Sign In Create Support Account Products ActiveRoles Boomi sql server Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security sql server error Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads () Support Knowledge Base MessageStats Could not obtain information about Windows NT group/user :Domain\Account (104271) × Return Title Could not obtain information about Wind
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 | 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, 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 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 ro