Could not obtain information

From: Gary D. Rezek (gary.d.rezek_at_REMOVEsdstate.edu)
Date: 11/16/05

  • Next message: Dan Guzman: "Re: why does my transaction log fill very fast?" 
    Date: Wed, 16 Nov 2005 11:20:56 -0600

    Hi All,
    We've just recently changed/upgraded server boxes and went from Windows 2000 Server to Windows 2003 Server with
    SQLServer 2000 sp4 installed on both. The Startup Service Account settings for both SQLServer and SQLServer
    Agent is 'System Account'. On the original machine backups worked without a flaw, but with the new machine I
    receive the following error:

    <<error from SQL Agent Error log>>
    [298] SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'DOMAINNAME\username'.
    [SQLSTATE 42000] (ConnIsLoginSysAdmin)

    When remoted into the new machine with 'DOMAINNAME\username' and doing an "exec xp_logininfo
    'DOMAINNAME\username'" in Query Analyzer I get the same error as follows:

    <<error from Query Analyzer>>
    Server: Msg 8198, Level 16, State 24, Procedure xp_logininfo, Line 58
    Could not obtain information about Windows NT group/user 'DOMAINNAME\username'.

    I've looked at kb241643 and kb834124 and realize there is a workaround, but this same account gets locked by AD
    at least a couple of times a day when I try and use it to login to this and/or other machines I administer (this
    account is an admin account used strictly for administration purposes, I have an individual account that I use
    for my desktop and laptop). It seems to have began shortly after I had to change the password for this account.
    I believe, the error and the lockout are related (my inexperience shows as I do not have anything concrete to
    make that assumption) so I would really like to know why this is happening and how to correct it.
    Thank you.

    gdr 

    -- 
Gary D. Rezek
University Nerworking Systems and Services
South Dakota State University
  • Next message: Dan Guzman: "Re: why does my transaction log fill very fast?"

    Relevant Pages

    • Re: Cannot connect to the Internet
      ... My Windows 2000 pro PC is connected to the internet (Local Area ... Connection 2 Status icon shows "Connected" with a speed of 10..0 ... The master browser has received a server announcement from ... Posted via a free Usenet account from http://www.teranews.com ...
      (microsoft.public.mac.virtualpc)
    • Re: Using EFS with Network Shares and SFU 3.5
      ... It does not take EFS into account. ... could again use the sharing server audit logs to see if success ... Read extended attribute and Read data, since the NFS client may ... Windows and *nix clients. ...
      (microsoft.public.windows.server.security)
    • Re: Error 10061, 0x800ccc0e, bug?
      ... It's definitely the April Windows update!!!! ... Checked program files after restore and the updates are gone and OE is ... receive mail after changing account in windows. ... Mike, the error indicates that you are failing to connect to the server, ...
      (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
    • Re: Permission Errors
      ... Windows 2003 server but suddenly I cannot get the web service to work, ... >a domain account so that it can be validated on the win2k server machine. ... >|>webservice failed with permission error when perform the file accessing ...
      (microsoft.public.dotnet.general)
    • Re: IIS 6 CreateObject premissions issue
      ... You have a web application running on Windows 2003. ... This exact same design works on a Windows 2000 server environment. ... LogonMethod metabase property tells IIS how the anonymous user account ... the Anonymous account is configured to run under the IUSR_SERVERNAME ...
      (microsoft.public.inetserver.iis.security)