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.
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.
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?
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.
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