SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 xp_logininfo error message


SQL Server 2005 xp_logininfo error message

Author
Message
Scott E-381021
Scott E-381021
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 575
If anyone has a valid solution, I am all ears.

Here is the issue....when you run xp_logininfo, for some AD accounts (or run a SQL job as the owner being an AD account) you get the following error message:

Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user 'mydomain\UserA', error code 0x5.

The OS is Server 2003 Enterprise Edition SP1. SQL Server 2005 SP2 Cummulative update package #2



UserA is an admin on the server and has SA rights in SQL Server......exact error message.

UserB is not an admin on the server and has datareader only permissions in a single db, and xp_logininfo will validate UserB just fine.


This is not a case sensitive username issue in this specific isntance, as noted on this website. I have tried every possible combination, and none of them work!

I have tried dropping the login and recreating it..exact same error message.
Chand00
Chand00
Right there with Babe
Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)

Group: General Forum Members
Points: 762 Visits: 1257
Hi,

Which authentication you are using sql or windows (for you not for usera and userb) and what permissions does ur account have

Thanks
Chandra Mohan N

Thanks
Chandra Mohan

Scott E-381021
Scott E-381021
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 575
Both windows and SQL login....either way, for some accounts it will work and for others it won't.
Rudyx - the Doctor
Rudyx - the Doctor
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4765 Visits: 2503
I would have youe AD folks compare the two accounts - my guess is that 0x5 is an access denied message.

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Scott E-381021
Scott E-381021
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 575
Well, let me throw one more factor in the mix here.....

This is on a SQL active\ passive cluster. For one physical node, it will work for some accounts...on the other node (when it is the active node) it will work for those accounts on the 1st node and on the 2nd node in addition to some accounts that would not work on the 1st node.

Any ideas???
Rudyx - the Doctor
Rudyx - the Doctor
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4765 Visits: 2503
Scott - this makes sense only when one is checking accounts that are local server only, and only if both nodes local accounts are not the same. 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 either physical node node.

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Matt Lavery
Matt Lavery
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 62
I've come across a similar issue which I have found is caused by changes in the security of Windows 2008 (specifically the API calls used to perform domain lookups). Given the time that this was posted I am guessing that you could be using Windows 2008.

The scenario I found is documented in my blog.
http://matticus-au.blogspot.com/2009/08/windows-2008-and-xplogininfo.html


Matt
mwfurugl
mwfurugl
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 169
This is what I have found to be true in a similar issue. Yes, this post comes many years after the original post; but I happened across this forum thread today while researching my issue.

I discovered this application event log error message reoccurring on Windows Server 2008 R2 Standard server running SQL Server 2008.

Log Name: Application
Source: MSSQLSERVER
Date: 11/30/2012 2:33:48 PM
Event ID: 28005
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: ServerName.Domain.Company.com
Description:
An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\UserAccount', error code 0x5.

From query analyzer I executed the following T-SQL code and received a similar error message.

xp_logininfo 'DOMAIN\UserAccount'

Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user ‘DOMAIN\UserAccount’, error code 0x5.

It is standard practice at my company to run the SQL Server database engine service using a domain service/user account. It is my understanding that when the xp_loginfo command is executed, whatever account is running the database engine service is used to query Active Directory to validate the user account name supplied to the extended stored procedure xp_logininfo.

It is also standard practice at my company to organize various domain user accounts and groups into different Active Directory containers. The issue here was that the service account running the database engine service did not have permissions to read the container in which the end user account resides. 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 permissions.

Working with my domain admin, the solution was to grant read permission (in Active Directory) on the end user account to the SQL Server database engine service account.
rakeshyadav
rakeshyadav
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 70
I've have faced the similar issue which I have found is caused by SQL service account which was locked. My SQL Service account was running under a domain account and it got locked due to certain reason and we're not informed. While querying using xp_loginfo we're getting this error. After diagnosis we came to know about account locking. Post unlocking the service account on domain issue got resolved.

Regards
Rakesh
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search