Home > Error Code > Xp_logininfo Error Code 0x534

Xp_logininfo Error Code 0x534

Contents

If this is your case, please try the solution mentioned in this article.Hope this helps. Email Address Meta Log in Entries RSS Comments RSS WordPress.org Load More...Follow on Instagram © 2016 Tomas Lind Proudly powered by WordPress Theme: Waipoua by Elmastudio Top ↑ Skip to Content DOMAIN02) you may find that SQL Server running on a computer in the Child Domain will report the following error when you perform specific operations from a SQL Server running either What is the result if you run "xp_loginfo 'domain2\id2','all'"?2. Check This Out

they are trusted each other under same forest. Thanks! Since it is a cluster and is running on Domain accounts, any account that is a domain account executing xp_logininfo will return the same result whether the clustered instance resides on Admin privilege are returned first, and within the privilege they are returned in the order of creation.

Xp_logininfo Could Not Obtain Information About Windows Nt Group/user

These were though due to the accounts for those services being different to the main service account for the related application. Terms of Use. Service Accounts: Active Directory Permissions Iss... Service Accounts: Active Directory Permissions Iss...

Blogger Template by Anshul. An earlier post, “my guess is that 0x5 is an access denied message” is correct (according to my domain admin); but it refers to Active Directory permissions and not SQL Server You may download attachments. Could Not Obtain Information About Windows Nt Group/user Error Code 0x5 After that, create two SQL logins for them in your SQL Server instance and try running xp_loginfo again.

You cannot upload attachments. MS SQL Server, C#, Powershell, SCOM and other technical interests.... no problem for most of other users from the same domain. You cannot edit other events.

It seems that it does not work here. If this issue persists, please send me your SQL Server error logs (%programfiles%\Microsoft SQL Server\MSSQL(.n)\MSSQL\LOG)for further information.Best regards,Charles WangPlease remember to mark the replies as answers if they help and unmark RegardsRakesh Post #1392819 « Prev Topic | Next Topic » Permissions You cannot post new topics. It is also standard practice at my company to organize various domain user accounts and groups into different Active Directory containers.

Error Code 0x8ac

Error: 15404, State: 19. In Services panel, locate your SQL Server service, double click it and check the Lon On tab. Xp_logininfo Could Not Obtain Information About Windows Nt Group/user RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus." Post #690315 Matt LaveryMatt Lavery Posted Thursday, August 20, 2009 9:03 PM Forum Newbie Group: General Forum Members Last Login: Tuesday, October Could Not Obtain Information About Windows Nt Group User Error Code 0x8ac We need to either run the SQL service under domain account or use SQL authentication Legacy ID 2010051901002853 Terms of use for this information are found in Legal Notices.

The subscription tasks would fail with this error and adding the SQL Server service account to the BUILTIN\Windows Authorization Access Group fixed the error. his comment is here Since SQL Server instance need to contact domain2's DC to retrieve the user information, the SQL Server service account need to have permission to read the user informaiton in your domain2. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? That has been the only other case where I have seen this behaviour. Could Not Obtain Information About Windows Nt Group User Error Code 0x2147

While querying using xp_loginfo we're getting this error. You cannot post or upload images. Since xp_loginfo need to access domain controller to retrieve user information, it is required that the server can contact your domain2's DC is required.4. this contact form RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus." Post #689907 Scott E-381021Scott E-381021 Posted Friday, April 3, 2009 6:05 PM Forum Newbie Group: General Forum Members Last Login: Saturday, November

To view the results for only one user, use the first parameter (@acctname): EXEC xp_logininfo 'AsusBook\Tomas', 'all' The last parameter (‘all') is used to specify whether to report information about all The statement has been terminatedbut I just don't get how to solve it. -I've tried to use the profiler but didn't find any information that will help me to solve.-One of is it a SQL issue or Active Directory issue?

Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me Matt Lavery I have been working in I.T.

Valid values are admin, user, or null. Thank you very much for your help. You cannot edit your own topics. I found this article which clearly outlines the SSRS Email Delivery issue.Reference MaterialHow to troubleshoot a SQL Server 8198 errorhttp://support.microsoft.com/kb/834124xp_logininfo (Transact-SQL)http://msdn.microsoft.com/en-us/library/ms190369.aspxSome applications and APIs require access to authorization information on account

I even tried adding the user as sysadmin. You cannot edit HTML code. To workaround this issue, please try deleting the two accounts and re-creating them so as to re-generate new SIDs for them.After that, create two SQL logins for them in your SQL navigate here privilege char(9) Access privilege for SQL Server.

In this situation, the xp_logininfo system stored procedure is run by using the security context of the SQL Server service. Education Services Maximize your product competency and validate technical knowledge to gain the most benefit from your IT investments. Provide feedback on this article Request Assistance Print Article Products Subscribe to this Article Manage your Subscriptions Search Again Situation Error message "Could not obtain information about Windows NT group/user error You cannot post JavaScript.

Powered by Blogger. You cannot post IFCode. Prior to this I worked for WebCentral / MelbourneIt as a Senior DBA and Technical Lead within the Microsoft SQL Server team. You cannot edit other posts.

Because the account does not have sufficient administrative credentials to enumerate the properties of the user in the domain, the xp_logininfo system stored procedure fails, and you receive the 8198 error. Monday, March 01, 2010 3:58 PM Reply | Quote 0 Sign in to vote For the second user, this errormayhappen when when you run EXEC xp_logininfo 'DomainName\DoaminAccount' to retrieve information regarding Supported Products A-Z Get support for your product, with downloads, knowledge base articles, documentation, and more. Valid values are user or group.

What is the result if you run "xp_loginfo 'domain2\id2','all'"?2. My SQL Service account was running under a domain account and it got locked due to certain reason and we're not informed. I am a very committed Touch Football Referee and currently officiate at an international level.I also have a number of other hobbies/passions:- Music (song writing and performing)- Photography- Personal Training / In this case, Keberos authentication is also required, so you need to also make sure that your SQL Server will use Keberos authentication.You mayuse a domain useras the service account, manually