???? SQL Server 8198 ?????? ???????? ?? ?????? ???? ????

???? ?????? ???? ??????
???? ID: 834124 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ???? ??? ????????????? ?? ?????? 8198 ?????? ???????? ?? ?????? ???? ?? ??? ????? ?? ???? ???? ???????, ?? ???? ??? ???? 8198 ?????? ?? ???? ?? ???? ?? ?? ???? ?? ???? ????? ??? ??, ??? ???????? ???? ?????? ?? ??? ??????? ?? ???? ???

????, ?? ???? ?? ????? ???? ?? 8198 ??? ??? ?????? ??????? ?? ???? ??? ????, ???? xp_Logininfo ?????? ???????? ????????? ?? ???? ??? ??? ??????? ???? ?? ??? ???? ??? ???? ???? ????? 8198 ?????? ???????? ?? ?????? ???? ?????



?? ??? 8198 ?????? ??????? ?? ???? ??

?? ?? ???? ?????? ?? ?? Microsoft Windows NT ????? ?????????? ???? ?? ??????????? ?? ?? ???? ?? ??? SQL ????? ?? ??? ?????? SQL ????? ??????? ?? ???? ???, ?? ????? ??? ?? ???? ?? ?? ???? ?? ?????? ????? ??????? ?? ???? ???

?????? ????? 1

?????: ????? 8198, ???? 16, ????? XX, ????????? <stored procedure="" name="">, ?????? <line number=""></line></stored>
Windows NT ????/?????????? '<domain\account name="">' ?? ???? ??? ??????? ??????? ???? ?? ???? </domain\account>



?????? ????? 2

ODBC ?????? 8198 (42000) Windows NT ????/?????????? ?? ???? ??? ??????? ??????? ???? ?? ??? ' <domain\account name="">'.</domain\account>



?????? ????? 3

????? ??? ????? Unable to determine if the owner (<domain\account name="">) of job <job name=""> has server access (reason: Could not obtain information about Windows NT group/user '<domain\account name="">'. [SQLSTATE 42000] (Error 8198)).</domain\account></job></domain\account>


To resolve the credentials of a Windows NT domain user account, SQL Server uses thexp_logininfo?????? ????????? ???????? ??? Here is a list of the common scenarios where you may notice that thexp_logininfosystem stored procedure fails and causes the 8198 error.
  • When you use anxp_sendmailextended stored procedure.
  • When you set up replication.
  • When you run a SQL Server Agent job.



Information about the Xp_logininfo system stored procedure

Xp_logininfois a system stored procedure. Thexp_logininfosystem stored procedure is not a SQL Server extended stored procedure, contrary to its name. Thexp_logininfosystem stored procedure invokes several Microsoft Windows API calls to retrieve information about the Windows domains and the Windows user accounts.

Based on the Windows API call that caused the failure, thexp_logininfosystem stored procedure may return the 8198 error with a relevant SQL Server state value. The SQL Server state value indicates the nature of the failure.

SQL Server may run thexp_logininfo?????? ???????? ????????? Windows ?? ???? ??? ??????? ??????? ???? ?? ??? ????? ?? ?????????? ????, ??? ?? ?????????? ?? ?????? ??? ?? ???? ????? ?????, ??? ?? ?? 8198 ?????? ????? ??????? ???? ?? ?? ?????? ????? ?? ??????xp_logininfo???????? ????????? ????????? ?? ??? ??? ??????, ????? ?? ?????? ?? ???? ????? ???????? ?? ?????? ???? ?? ??? SQL Profiler ????? ???? ?????? ???

?? ???xp_logininfo?????? ???????? ????????? ???? ??, ?? ??????? ???? SQL ????? ?????? 8198 ?????? ????? ??? ??? ?? ?????????? ???? ????xp_logininfo?????? ???????? ????????? ?????? ??? ??, SQL ????? ?? ????? ?? ????xp_logininfosystem stored procedure to retrieve information about the Windows domains and the user accounts when it is required. In the following error message, theXXvalue indicates the SQL Server state at the time when the failure occurred.

Server: Msg 8198, Level 16, State XX, Procedure <stored procedure="" name="">, Line <line number=""></line></stored>
Could not obtain information about Windows NT group/user '<domain\account name="">'. </domain\account>


The following table lists some of the common SQL Server state values that you may notice in the error message when an 8198 error occurs.

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
SQL Server statePossible cause
21Thexp_logininfo?? Microsoft Windows NT ???????? ?????? ??? ??? ???????? ?? ???????? ????????? ????????? ????? ???? ???? ??? ???
Windows ????? ??? ?? ???? ??? ?? Windows ???? ??? ??? separates ???????? ("\") ???? ???????? ???
22SQL ????? ???? Windows ???? ?? ??? ?? ???? ??? ??????? ??????? ???? ?? ??? Windows ???????? ?????? ?? ?????? ?? ???? ??? ??? ?????? ??????? ????
24SQL ????? ???? ?????? ???? Windows ???? ?? ??? ?? ???? ??? ??????? ??????? ???? ?? ??? Windows ???????? ?????? ?? ??, ?? ?? ????? ????? ???? ??? ???
25SQL ????? ???? ?? ???? Windows ???? ?? ??? ?? ???? ??? ??????? ??????? ???? ?? ??? Windows ???????? ?????? ?? ?????? ?? ???? ??? ??? ?????? ??????? ????
26??? ?????? ??????? ??? ?? SQL Server ???? ?? Windows ???????? ?????? ?? Windows ?? ???? ??????? ???? ?? ???? ??? ??????? ??????? ???? ?? ??? ?????? ?? ?? ???? Windows ?????????? ??? ????? ??? (Windows ?????????? ???????? ??????? ?????? ???? ?? ???)?
27??? ?????? ??????? ??? ?? SQL Server ???? ?? Windows ???????? ?????? ?? Windows ?? ???? ??????? ???? ?? ???? ??? ??????? ??????? ???? ?? ??? ?????? ?? ?? ???? Windows ?????????? ??? ????? ??? (Windows ?????????? ???????? ??????? ?????? ???? ?? ???)?


8198 ?????? ????? ?? ?????? ??????

???????xp_logininfo?????? ???????? ????????? ????? ???? ?? ???? SQL ????? ?? ?????? Windows NT ????? ?????????? ???? ?? ??????????? ?? ?? ???? ?? ???, Microsoft ??????? ???? ?? ?? ?? ?? ????? SQL Profiler ?????? ????? ?? ???????? ???? ?? ??? ????? ???

???? ??? 8198 ?????? ?? ???? ?? ???? ?? ?? ???????? ?? ?? ???? ???
  • ??????? ?????????
  • Windows ?? ??????? ???? ?? Windows ??????? ???? ?? ??? ?? ??? ???????
  • EVERYONE ???? ?? ??? ??????
  • ???xp_sendmail???????? ????????? ?????? ????????? ?????
  • SQL ????? ????? ????? ???????
  • ???? ??????????? ??????????? ?????
?? ?????? ?? ???? ??? ???? ??????? ???????? ??? ?? ?????? ?? ??? ?? ?????? ????? ?? ?? ?????? ?? ?? ???

??????? ????????

??? SQL ????? ????? ???? ???????? ????????? ?? ????? ?? ??? ????? ???? ???? ?? ?? Windows ???? ?? ????? Windows ????? ??? ??, ?? ?? 8198 ?????? ??????? ?? ???? ??? ?????? ?? ?? ???? ?? ??? ????????? ???? ?? ????? ????????? ???? ???:
  • ?? Windows ?? ??? ??????? ????? ???? ?? ??????
  • TCP/IP ????? ?? ??????? ?? ??????? ???? ?? ??? ?????? ??? ?? ?? Windows ????? ?? ????? ?? ?? ????

    ???:Windows ????? ?? ??????? ????? ????? ???? ???, ??? ?? ??? ?? ??????? ?? ???? ??, 8198 ?????? ?? ?? ?? ?? ????? ?? ??? ??????? ????? ???? ????? ???
???????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
179442????? ?? trusts ?? ??? ?? ??????? ?? ???????? ???? ????
???????? ???? ?? ???? ???? ???????? ??? ?? ????????? ?? ???? ??, ?? ??? ??????? ???? ?? ??? ???????????? ?? ???? ???? ????? ?? ????? ??? ?? ?? ???? ???????? ?? ??????? ????????? ????? ?? ???? ??? ?? ???? ????? ??? ?? ????????? ????? ???? ???? ?? ???? ??, ?? ?????? ??????? ?? ??????? ?? ???? ???

???:??? ?? ???? ???? ????? ?? ??? ?????????? ??????? ?????? ????? ???? ?? ??? Windows Explorer ?? ?????, ????????? ???? ?? ???? ?????? ??? ?? ???? ????? ?? ??? ?? ??? ????? ?? ???? ??? ???



Windows ?? ??????? ???? ?? Windows ??????? ???? ?? ??? ?? ??? ??? ??????

???????? ????????? Windows ??????? ???? ?? Windows ??????? ???? ?? ??? Windows ?????????? ?? ??? Windows ??????? ???? ?? Windows ??????? ???? ?? ????? ??? ?? ???? ?? ?? ??? ??? ???? ??? ?? ????? ?? ??? ?? 8198 ?????? ??????? ?? ???? ??:
  • Windows ????? ????
  • ???????? ????
  • ???? ???? Windows ????? ?? ????????? ????? ???? ????? ?? ???

?? ?????? ?? ?? ???? ?? ??? ????? ??????? ??? ?? ??? ?? ??????
  • Windows ??????? ???? ?? ??? ?? Windows ??????? ???? ?? ??? ??????
  • Windows ??????? ???? ?? Windows ??????? ???? ?? ?????? ?? ?? ??? ?? ??? ??? Windows ????? ?? ?????????? ?? ????????
???????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
233161BUG: Xp_logininfo ???? 8198 ??????


??? Windows ?? ??????? ???? ?? ???? Windows ??????? ???? ?? ?? EVERYONE ??????? ???? ?? ??? ??? ???? ??? ?? ?? ???? ?????????? ?????? ????? ??? ??, ?? ?? 8198 ?????? ??????? ?? ???? ??? ??????? ???? ???? ?? ??? Windows ???? ?? ??? ????? ?? ???? ?? ???? ???

??????? ???? ??? ??? ????? ???? ??? ?? ?? ?????? ?? ????????? ?? ??? ?????????? ????????? ??????????? ???????Windows ?????????? ?????? However, if you manually create a Local group or a Global Domain group and you name it EVERYONE, the EVERYONE group will be in the list of groups in????? ?? ??? ?????????? ???????.

To resolve this problem, delete the EVERYONE group that you created manually.


???xp_sendmailextended stored procedure failure

Thexp_sendmailextended stored procedure may fail and return the 8198 error if the client computer that is running thexp_sendmailextended stored procedure is not in the same domain as the SQL Server computer, and the two domains do not have a trust relationship.

?? ?????? ?? ?? ???? ?? ??? ????? ??????? ??? ?? ??? ?? ??????
  • ??????? Windows ????? ??? ?? ?? ?? ?????????? ??? ?? ??????? ???? SQL Server ????????? ???? ?? ??? ??? ?? ?? ??? ????? ?????????? ??????
  • ?? SQL Server ????????? ???? ???????????-Windows 2000 ???? ????? ??????? SQL ????? ??????? Windows ????? ????

    ???? Pre-Windows 2000 ???? Access ?? ????? ???? ???? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
    303973TO HOW: Pre-Windows 2000 ???? ????? ???? ?? ??? ???????????? ?? ?????

SQL ????? ????? ????? ??????

??? ?? Microsoft Windows ?????? NT ????????? ???? ???? SQL Server ????? ????? ?????????? ?????????? ???? ??, ?? ?? 8198 ?????? ??????? ?? ???? ??? ?? ?????? ?? ???? ?? ?? ?? Microsoft Windows 2000 ???????? ?????? ?? ???????? ?? SQL ????? ?? ??? ?? ?? ???????? ?? ????? ???? ??, ???????-Windows 2000 ???? ????? ????.

?? ?????? ?? ???? ??? ???????? ??????? ?? ??? ?? ????? ?? ???????? ?? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
241643PRB: Windows NT ?????????? ?????????? ?????? ????????? ???? ????? ?? ?? 8198 ?????? ?????


??????????? ???????????? ??????

?? ?? ????????? ?? SQL ????? ??????? ?? ???????? ????, ????????? ????? ??????? ???? ?? ???? ??? ?? 8198 ?????? ??????? ?? ???? ???
??? ????????? ????? ??????? ???? ???? ??, ?? ????????? ????? ????? ?? ??? ????? ??? ?? ?? SQL ????? ????? ????? ?? ?????? ?? ???? ????? ?? ????? ?? ?????? ??? ??? ?? 8198 ?????? ?????? ???? ??? ????? ?? ???? ???

????? ???? ?? ??????? ?????? ?? ?? ?????? ?? ????? ???? ???
  • SQL ????? ???? ?? Windows ????? ?? ???????? ???????????? ????????????? ?? ??? ???? ?? ?? ???? ???? ?? ????? ???? ??? ?? ?????? ???,xp_logininfo?????? ???????? ????????? ?? SQL ????? ???? ?? ??????? ?????? ?? ????? ?? ????? ???? ??? ??????? ???? ????? ??? ?????????? ?? ??? ?? ????????? ???? ?? ??? ???????????? ????????????? ???????? ???? ??xp_logininfo?????? ???????? ????????? ???? ??, ?? ???? 8198 ???????

    ?? ?????? ?? ?? ???? ?? ??? ???? Windows ????? ???? ?? ??? SQL Server ?? ???? ?? ????????? ???? ??????
  • SQL ????? ?????? ?? SQL Server ????? ???? ??????? ?? ?? ???? Windows ?? ????? ??????????? ??????? contexts ??????

    ?? ?????? ?? ?? ???? ?? ??? ?? ?? ????? ?? ??????? ?? ???? ????:
    • SQL ????? ?????? ?? SQL Server ????? ???? ?? ????? ?? ??? ?? ?? Windows ????? ?????????? ???? ?? ????? ?????
    • ??????? ?? ?? ??????????? ????? ?????????? ??? ?? ??????? ?? ?? Windows ????? ?????????? ???? ??????

??????

???????? ??????? ?? ???, ????? ???? ???????? ?? ????? ?? ?????? ?? Microsoft ???????? ??? ?????::
830596FIX: ???? ?? ?????? ????? ??????? ?? xp_logininfo ???????? ????????? ???? ????????? ????
241643PRB: Windows NT ?????????? ?????????? ?????? ????????? ???? ????? ?? ?? 8198 ?????? ?????
233161BUG: Xp_logininfo ???? 8198 ??????


?? ???? ??? ???????? ??????? ?? ???xp_sendmail???????? ????????? ????????? ??, ????? Microsoft ??? ???? ?? ???? ??:

xp_sendmail


?? ???? ??? ???????? ??????? ?? ???xp_logininfo?????? ???????? ????????? ?? ???, ????? Microsoft ??? ???? ?? ????:

xp_logininfo


???

???? ID: 834124 - ????? ???????: 05 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2000 Standard Edition
??????: 
kbhowtomaster kbstoredproc kberrmsg kbsecurity kbsqlservmail kbuser kbtsql kbquery kblogin kbauthentication kbservice kbserver kbdatabase kbsysadmin kbinfo kbmt KB834124 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:834124

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com