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

?????? ????????? ?????? ?????????
???? ???????: 832109 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ????? ???? ????? ????? ?? Microsoft Systems Management Server (SMS) 2003 ?? ?????? ???? ?? ???? ?? ???????? ???????:
  • ?????? ????? ????????? ??? ???? ?? ???? ???? ????? SMS ?????? ???????? ???? ?? ??? ????? ?????? ???? SMS ??? ????? ????????? ???????.
  • ?????? ????? ????????? ??? ???? ?? ???? ???? ????? SMS ?????? ???????? ???? ??? ????? ????? SMS ???????? ??? ?????? ??? ????????? ???? ??? ????????.
  • ??? ??????? ??????? ???????? ???? ???????.
  • ??? ????? ??????? ??????? ?? CAS.log ??? ??????? ???? ?????? SMS ??? ??? SQLERROR ??? ???? SQL:
    ??? ????? ?????? ???????? '(?????)'. ?????: ??? ???????? ?? ????? SQL Server ????? ??
  • ?? ????? ??? ??? IIS ??? ???? ????? 401 ???.
?? ???? ????????? ??????? ?? ???? ????? ?? ??? MP_GetAuth.log. ???????? ??? ?? ??? ??? ???? SMS ????? ????? ??? ????? ??? ???? ??? ?? \ %windir% ???? \system32\CCM\Logs\ ?? ?? ???? \SMS_CCM\Logs\. (%windir% ?? ?????? ?????? ???? ???? ???????.)
<![LOG[CMPDBConnection::Init(): IDBInitialize::Initialize() failed with 0x80004005]LOG]!>
<![LOG[Raising event: [SMS_CodePage(437), SMS_LocaleID(1033)] instance of
MpEvent_ConnectDatabaseFailed {
      ClientID = "GUID:F4AB9DD6-362A-44B4-BAFA-6797AD71C79F";
      DatabaseName = "SMSDBname";
      DateTime = "20030919053031.203000+000";
      ErrorCode = "0x80004005";
      MachineName = "MPcomputername";
      ProcessID = 5124;
      ServerName = "SMSservername";
      SiteCode = "sitecode";
      ThreadID = 3512;
      Win32ErrorCode = 0;
};
]LOG]><time="00:30:31.219+000" date="09-19-2003" component="MP_GetAuth_ISAPI" context="Auth" 
type="1" thread="3512" file="event.cpp:522">
CMPDBConnection::Init(): IDBInitialize::Initialize() failed with 0x80040e4d $$<MP_GetAuth_ISAPI><Wed Feb 4 17:19:29.240 2004 Eastern Standard Time><thread=2664 (0xA68)>

?????

?? ??? ???? ???? ????? ?? ??????? ????? ???? Microsoft SQL Server. ?? ???? ??? ???????? ?? ??? ???:
  • ??? ??? ???? ????? ???????? ??????? ??? ???? SQL.
  • ???? ????? ?? ??????? SQL ?????? ??????? ??? (SPN).
  • ???? ????? ?? Kerberos ?? ???????? ???? ??? ?????? (DNS).

???? ??????

??????? ?????? ??? ??? ??????? ?? ???????? ?? ????? TCP ??? ????? ????? ??? ???? ????? ???? SQL. ???? ??????? ????? ??????? ?? ??? ???? ??????? ?? ?????? Kerberos ?????? TCP.

?????? NTLM ?????? ??????? ??????? ???????. ??? ?? ???? ??????? ?? TCP ??? ????? ??? ?? ???????, ????? ???? "????? ???? ???????" ?????? ?????? ??????? ?????? ????????. ??? ????? ????? ??? ???? ????? ???? ??? ?? ???????, ??? ???? ??? ?? ???? ?????? Kerberos ????? ????? ??????? ??????? ???????? ?? ??? ??????? ????? ?? ????? ?????.

?????? ????? ??? ??? ??????? ??? ??????. ???? ??? ???? ?? ???? ??? ????? ????? cliconfg ?? ???? ??? ?????. ???? ??? ??? ????? "???????? ???? ??????". ????? ??? NetBIOS ???? SQL ?? ????? ??????? Alias ?? ??????? ???????. ??? ?? ??????? ?????????.

??? ???? SQL ????? ?????? ???????? Network Server ????? ?? ??????? ?? ???? ????? ??????????. ???? ??????? ????????? SQL ?? 10 ?????. ???? ????? ??? ???? ???? ??? ??? ???? ????? ??????. ???? ??? ??? ????? ????.

??????? ????

???????? ??? ??????? ???? ??????? ?? ??????? ???? ??? ??.

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

???? ??????? ??????? ???????? ??? ??????? ???? ?? ???? ????? ??? ???????? ??????? ??????? ?????? ?????? SQL. ?????? ????? ???? ??????? ???????:
  1. ?? ???? ???? ????? ???? ??? ???? ?? ???? ??? ????? ? ????? cmd ?? ?? ???? ??? ?????. ??? ??? ???? ???? SMS ??? ??? ???? ????? "? ????? ??? ?????? 4. ?? ???? ????? ???? SMS ?? ??? ???? ????? "? ????? ??? ?????? 2.
  2. ??? ??? ???? SMS ?????? ?????? ???????? ? ??? ????? ???? ???? ??????? ???? ??? ??????? ??? ???? ?????? ??????. ?????? ????? ???? ?? ??? ?? ???? ??????? ?? ?? ???? ????? ??????? ENTER:
    AT FutureTime / interactive cmd
    ?? ????? ???? ????? ??? ???? ???? ????? ???? ???? ??? Svchost.exe.

    ?????????? ?? ???? FutureTime ?? ?? ??? ??? ???? ?? ????? ?????? ?? ??????? 24 ????.
  3. ?? ???? ???????? ???? ?????? ??? ?? ???? ENTER:
    osql -S SQLServer -d SMSdbname -E
    ?????? SQLServer ?? ??? ?????? ???? ???? ?????? SQL Server ? SMSdbname ?? ??? ????? ?????? SQL ???? SMS.

    ??? ??? ??? ????? ??? ???? ????? ???????? ??????? ?????? ?????? SQL. ?? ????? ??? 1> ????? ??? ????? ????. ???? exit ?? ?? ???? ENTER ?????? ??? ???? ???????. ?? ???? ???? ????? ????? ??????? ????? ??? ?????? 4:
    ??? ????? ?????? ???????? '(?????)'. ?????: ??????? ??? ????? SQL Server ????? ??.
  4. ?? ???? ???? ????? ????? "??? ????? ??????" ?????? ?? ?????? 3 ??? ????? ???? ??????? ?? ??? ??? ???? ???? (FQDN). ??? ???? ??????? ????:
    osql -S SQLServer.europe.corp.microsoft.com -d SMSdbname -E
    ?? ???? ??? ????? ??? ??????? DNS ?????? ??? ???? ????????? ???? ?????.
  5. ??? ??? ????? ?? ???? ???? ?????? ?? ??? ???? ???? MSSQLServer ?????? ???? ?????? ??? ????? ?????? ???????? ?? ?????? ?????? ??????? ???? "?????? ??????" ??? ????? ??????? "????? ??????" ?? ????? ???? ?? ?? ?????? ??????? ??? ????. ??? ??? ??? ???? ????? ?????? ???????? ???? ?????? ???? ?? ?? ??? ????? ???? ?????? ??? ?????? "?????? ??????". ????? ????? ??? ???? ??????? ??????? ?? ??????? ??????? ?? "????? ??????? ?? Microsoft:
    829868?? ???? ?????? "?????? ??????? 2003 ???? ?????" ??????? ?????? SQL ?????? ??? ???? SQL

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

  1. ?? ?? ??? ????? ???? ??? ?????? ??????? (SPN) ???????? ?????? ???? ?? ??? ????? ????? SQL. ??? ??? ???????? ??? ????? ??? ?????? ?????? ??????? (FQDN) ???????? SPN NetBIOS ??????. ?????? ????? ????? ??????? ?????? ???????? SetSPN ?? Windows 2000 Server Resource Kit. ?????? ?????? ???????? SetSPN ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&DisplayLang=en
    ??? ????? ?????? ???????? SetSPN ??? ???? ??????? ?? ???? SQL Server. ??? ???? ??????? ?????? ?????? "????? ??????". ????? ?? ??? ??? ????? ????? SQL ????? ???? ?? ????? ??????? ????. ???????? ?????? ???????? SetSPN ?????? SPNs ??????? ?????? ???? ??????? ???????:

    ??? ????? ???? SQL ??? ???????? ???? ??????
    • ?????? SPN FQDN ?? ???? ???? ??????? ???? ????? ??????:
      setspn - MSSQLSvc / SqlHostname.mydomain.com: 1433 SqlServiceAccount
    • ?????? SPN NetBIOS ?? ???? ???????? ???? ????? ??????:
      setspn - MSSQLSvc / SqlHostname: 1433 SqlServiceAccount
    ??? ????? ???? SQL ??? ??? ???? "?????? ??????"

    ??? ??? ??? ????? SQL Server ??? ???? ?????? ??????, ??? ???? ?????? SPN ?????? ?? SQL Server. ??? ????? SPN ???????? ??? ??? ????? SQL Server ? ????? ??? ????? ???? SQL. ??? ??? ??? ????? SQL Server ??? ???? ?????? ????, ??? ????? SPN ??????.

    ????? SPN

    ?? ???? SPN ????? ????????? ???? ???? ?????? SQL Server ????? ???????. ????? ??????? ?????? ?????? ?? SPNs ???????? ?? SQL Server ?????? SPN ????:
    1. ????? ???? MSSQL.
    2. ????? ????? SETSPN -L computer name ???? ???? SPNs. ??????? ????? ??? ???:
      MSSQLSvc/MySQLServer dasaccount1 
      MSSQLSvc/MySQLServer:1433 
      MSSQLSvc/MySQLServer.MyDomain.com dasaccount1 MSSQLSvc/MySQLServer.MyDomain.com:1433 
      
      ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
      319723????? ??????? ?????? Kerberos ?? SQL Server

      ?? ???? ????? ???? MSSQL ??? ???? "?????? ??????", ??? ????? SPN ??? ????? ???? MSSQL. ????? ??? ?? ??? SPN ?? ????? ????? SETSPN -L ? ??? SPN ?????. ??? ??? ??? ????? ???? MSSQL ??? ???? ?????? ????, ?? ???? ??? ??? ?? SPN ??? ????? ????? SETSPN -L. ????? ?? ???? ????? ?? ??? ???? SPN ????? ?? ??. ?? ???? ????????? ?????? ?? ?? SPN ??? ???? ????? ?????????? ?? SPN ??? ?? ???? ?? ??????? ?? ? c ??? 1i.
    3. ??? ?? ??? ??? ??????? ????? ??? MSSQLSvc ??????? ????? SETSPN D ????? ?????????. ??? ???? ??????? ???? ?? ???:
      ?D SETSPN MSSQLSvc/MySQLServer DAS account SETSPN -D MSSQLSvc / .com MySQLServer.MyDomain <DAS account >
    4. ????? ????? SETSPN -L computer name ??? ???? ?????? ?? ???? ?? ???? ????? ?? MSSQLSvc.
    5. ??? ??? ??? ????? ???? MSSQL ??? ???? "?????? ??????", ???? ?? ?? ???? ??? ??????? SQL Server ???? "?????? ??????". ????? ????? ??? ??????? ??? ????? ??????? ???? ?? ???? ?????? ????? ???? ?? ????? SQL Server ???????.
    6. ??? ??? ??? ????? ???? MSSQL ??? ???? ?????? ???? ? ????? ?? SPN ???????? ????? SETSPN -A ??? ???? ??????.
    7. ????? ????? ???? MSSQL.
    8. ??? ????? ???????? ??????? ????? servicePrincipalName ??? ??? ?????? ???? ???? ?? ????? SPNs ??? ???? ????. ?????? ????? ?? ?????? ????? ??????:
      computer name SETSPN -L
    9. ??? ?? ????? ?? SPNs ???? ???? ??? ?????? ??????? SMS ???????? ???????? ?? ??? "?????? ?? ??????".
  2. ?? ???? ??????? ???? ?? ????? ?????? ?????? SMS_SitetoSQLConnection ??? ?????? ????????? ?? ?????? ???? SMS ????? ???????? ?????? ??? ??????? ??? ?????? ???????. ???? ???? ??? ????? ??? ???????? ??? ?????? ???? SMS_SitetoSQLConnection ??? ????? ????. ??? ??? ????? ??? ?????? ??????? ?????? ?????? ? ??? ????? ????? ?????? ?????? ??????? ?? ???? ???? ????? SMS:
    4908 ???? ??? ????? ???????? ???? ????? ???? ?????? "%1" ??? ?????? Access SQL "%2" ??? SQL Server ?????? "%3".
  3. ?? ???? ????? ????? ????? ??????? ?????? ????? Kerberos. ?????? ?????? Kerbtray ?? Windows 2000 Server Resource Kit ???? ????? ??????? ?????? ???????? ????? Kerberos. ?????? ?????? Kerbtray ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=4e3a58be-29f6-49f6-85be-e866af8e7a88&displaylang=en
    ????? ?? ????????? ??? ????? ??????? ?????? Kerbtray ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    232179????? Kerberos ?? ???? ??????? Windows 2000
  4. ???? ?? ??? ???? DNS ?????? ????? ?? ????? TCP/IP ????? ???? ?????.
  5. ??? ?? ??? ??? FQDN ?????? ????? ?? ???? ????? ????? ????? ??? ???? ????? ????. ?????? ????? ????? ????? ???? ??????? ???????:
    1. ???? ??? ???? ?? ???? ??? ????? ????? ncpa.cpl ?? ???? ??? ?????.
    2. ???? ??? ?????? ?????? ??? ??????? ???? ???? ?????? ?? ???? ??? ?????.
    3. ?? ???? ?????? ????? ??? ??????? ???? Internet Protocol (TCP/IP) ??? ?????? ??? ??????? ??????? ??????? ?? ???? ??? ?????.
    4. ?? ??????? ???? ???? ??? ?????? ?????? ?? ???? ??? ????? ??????? DNS.
    5. ???? ??? ????? ?????? DNS ??????? (??? ???????) ???? ??? ?????? ????? ?? ?? ???? ?????? ????? ??? ???? ??????? ?????? ??? ??? ???????.
    6. ???? ??? ????? ????? ?? ???? ??? ?????.

?????

?????? ??? ???? ?? ????????? ??? ????? ?? ?????? ??????? SMS ?? ???? SQL ???? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
829868?? ???? ?????? "?????? ??????? 2003 ???? ?????" ??????? ?????? SQL ?????? ??? ???? SQL
????? ?? ????????? ??? ??????? SPNs ?? "Active Directory" ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
298718????? ??????? SPNs ?? ??????
????? ?? ????????? ??? Kerberos ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
266080?????? ??? ??????? ???????? ???? ????? Kerberos
326985????? ??????? ???????? ???????? ?? Kerberos ?? IIS

???????

???? ???????: 832109 - ????? ??? ??????: 26/????/1428 - ??????: 13.3
????? ???
  • Microsoft Systems Management Server 2003 Enterprise Edition
????? ??????: 
kbmt kbsoftwaredist kbclient kbsecurity kbinfo KB832109 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????832109

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

 

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