????? ??????? ?????? ??????? ?? SQL Server 2000

?????? ????????? ?????? ?????????
???? ???????: 827422 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ?? ?????? ??? ??????? ?? ?? ????? ??????? ?? Microsoft SQL Server 2000. ????? ??? ??????? ??? ????? ?????? ??????? ?????? ???????? ???? ????? ??????? ???????? ?? ?? ?????? ???????.
???? SQL Server 2000 ?????? ?? ???????? ??????? ??? ???? SQL Server ???????? ??????. ??? ????? ?????? ????? SQL Server ???????? ??? ??? ?????????? ??? ??????? ?????? ????? ??? ???????? (IPC) Microsoft Windows? ??? ?????? ??????? ??????? ?????? ?? ???????? "????? ??????"? ???????. ??? ???? ??? ????? ?????? ????? SQL Server ???????? ??? ????? ??????? ??????, ??? ??????? ???? ????? IPC ??? TCP/IP ?? ?????? ??????? ???????? ???????.

?????? SQL Server 2000 Net-????? DLL? ???????? ?? ???????? ???? ????? ?????. ??? ?? ???? ??? ?????? ?? ???? ???????? ?????? ??? ????????? ?????? ????? ????????? ?????? ??????? ???????? ???? ??????? ???? ???? ????????. ??? ???? ??????? ??? ??? ???? ????? ????? ???? ??????? ????? ???? ?? SQL Server ??? TCP/IP? ??? ????? ?????? Net ???? ??????? TCP/IP-????? (Dbnetlib.dll) ??????? ??????? ??? ????????? ??????. ???????? ??? ???????? ?????? Net ???? ??????? TCP/IP-????? (Ssnetlib.dll) ??? ??????? ??????. ?? ??? ?????????? ??? ????? ??? ???????? TCP/IP ??? ?? ?? ???? ????????? ?????? ????? ????????? ??????.

??? ????? SQL Server 2000? ????? ????? ????? ???? ???? ???????? ???????? "???? ???? ??????? ????????". ????? ????? ????? ???? ???? ???????? ???????? "???? ???? ??????? ????????" (Svrnetcn.exe). ??? ????? ???? ???? ???????? ????? ????? ????? ?????? ?? ????? SQL Server. ??? ???? ??? ???? ???? ?????? ?? ?? ???? ????. ???? ???????? ???? SQL Server 2000 ?????? TCP/IP? ???? ?????? ? "??????? ????????". ?????? ????? ??????? ???????? ????? ??? ??????? ?????? ???????? ???? ????? Net ????? ??? ???? ???? ???????? ???? ?????? ????? ????? SQL Server.

?????? ??? ??????? ?????? ??? ?????? ????? SQL Server ????? ????????? ???? ???????? ??????? ?? "??? SQL Server ??? ??????":
  • ?????? ???????
  • Net-?????? ?????? ???????
  • ????? ???????

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

???? ???? ????? ??????? ???? ?? ????? ?? SQL Server 2000 ???? ?????? TCP/IP? ?????? Windows ?? ?????? ?? ?????? Windows ? TCP/IP.

??? ??? ????? ?? ??????? ?????? ??????? ?? SQL Server 2000? ???? ?? ??? ????? ???? mssqlserver. @ ??? ????????? ???? ?????? SQL Server.

???? ?? ??????? DNS

??? ??????? ????? ????? ????? ?? ???? ??? ?????? (DNS) ??? ????? IP ???? ???? SQL Server. ??? ?? ???? ????? ????? ????? ???? ????? ?? ???? ?????? ??? ???? SQL Server? ??? ???? ????? ?? ???? ?? ????? ????? ???????:
???? SQL ??? ????? ?? ?? ??? ??????
??? ??? ?? ???? ???????
????? ????? ???? SSPI
?????? ?? ?? ??? ?? ????? ????? ??? ?????? ??????? ????? ?????? ????? ?????? ???????? ??? ?????? ?????? IP ??????. ?????? ????? ???? ??????? ???????:
  1. ???? ??? ????? ??? ?? ???? ????????.
  2. ?? ???? ?????? ????? ? ????cmd??? ???? ??? ?? ???? ????????.
  3. ?? ???? ???????? ?? ?????? ????? ??????:
    ping <Server Name>
    ???? ????? IP ???? ??? ???????.
  4. ?? ???? ???????? ?? ?????? ????? ?????? (??? ????? IP ?? ????? IP ???? ??? ??????? ?? ?????? 3):
    ping ?a <IP address>
???? ?? ?? ????? ????? ??? ??? ?????? ??????. ??? ???? ?? ?? ??????? ??????? ??? ????? ????? ?? ?? ?????? ????? ??????? ??? DNS ?? ???? ???? ???? ?? ??????? ?? ???? ???? ?????? ?????? ?? ????? ????. ??????? ??????? DNS ??????? ?????? ????? ?????? ?? ???? ???????:
ipconfig /all
????? ?? ????????? ??? ????? ipconfig? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
223413 ?????? Ipconfig.exe ?? ???? ??????? Windows 2000


?????? ??? ??? ???????? ????? ????? ?????? ??? ????? %systemroot%\system32\drivers\etc\hosts ??? ???? ????????? ??????. ????? ???? ?? ??????? ???????? ??????? ???????? ????? Net "??????? ??????? ???????".

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

?? ???? ?????? ??????? ??? ?? ????? ????? ???????? ??? ???? ????????? ?????? ???? ??? ????. ????? ??? ??????? ????????? ???????? "???? ???? ??????? ????????". ?????? ????? ???? ??????? ???????:
  1. ??? ????? ???? ???? ????? ??????. ??? ?? ????? ????? SQL ??????????? ??? ????????? ???? ???? ?????????????? ???? ??? ??????? ???? ????? "???? ???? ??????? ????????":
    1. ???? ??? ????? ??? ?? ??? ??? ???????.
    2. ??? ??? Microsoft SQL Server? ??? ?? ???? ??? ???? ???? ??????? ????????.
    ??? ?? ??? ????? ????? ???? SQL Server ??? ??????? ???????? ???? ??? ??????? ???? ????? "???? ???? ??????? ????????":
    1. ???? ??? ???? ??? ?? ???? ??? ?????
    2. ?? ???? ?????? ????? ? ???? ??????????? ???? ??? ?? ???? ??? ?????.
  2. ?? ???? " SQL Server ???? ?????? ????????"? ???? ??? ????? ??????? ??? ?? ?? ?????? ???? ???????????? ???? ???? ?????????.

    ?????? ??? ????? ?????????? TCP/IP ????????? ?????? ??????? ??????? ??? ?????.
  3. ???? ??? ????? ??????? ??? ?????? ??? ?? ???? ?? ???? ??????? ????????? ???? ?? ??????? ????? SQL Server.
  4. ???? ?? ????? ????????? ?????? ?? ?? ??? ?????? ?? ????? IP ??????????? ?? ??????? ???? ????.
????? ????? ??? ?????? ???? ??????? ??????? ???????? ??? ?????? ????? IP? ?? ??? ???????? ???????? ???.

?????? ????? ????????? ??????? ?? Microsoft Data Access Components (MDAC) ????? ?????? ?????? "???? ???? ??????? ????????". ?????? ??? ??? ?? ??? ???????? ??????? ?? ??? ???????? ????? ????? ???? ?? MDAC ??? ???? ????????? ???? ???? ?????? ????? ??????.

???? ?? ???? SQL Server ???????? ???? ????

?????? ?? ?? ???? ???? SQL Server ??? ??????? ?? TCP/IP ?? ???????? ??? ???? ??????? ?? ????? ??????? ???? ??? ????? ??? SQL Server ??????. ?? ????? ??? ??? ??? SQL Server ??? ??????? ?????? ??? ???:
2003-11-06 09:49:36.17 server SQL server listening on TCP, Shared Memory, Named Pipes. 
2003-11-06 09:49:36.17 server SQL server listening on 192.168.1.5:1433, 127.0.0.1:1433.


????? ????????? ?? ??? ??? ??? SQL Server? ????? ?????? ?? ?? ???? SQL Server ???????? ??? ????? IP ?????? ???? ?????? ??????. ???? ???????? ????? ???? ??????? ? SQL Server ??? ???? 1433. ????? ???? ??????? "?????? ???????? ????? ????? ??????" ?????? ?? ??????? ???????? ? SQL Server ?????? ??????? ?? SQL Server? ??? ?? ??? ?????????? ??????? ??? ???? SQL ???????? ???? ??? ?????????. ????? ?? ????????? ??? ??????? "?????? ???????? ????? ????? ??????"? ???? ??????? "SQL Server ?????? ????????" ?? "??? SQL Server ??? ??????".

?? ??? ???????? ?? ??? SQL Server 2000 ??????? 1433 ?? ?? ?????? ?????? ??????. ?? ???? ??? ??????? ??? ?????? ??? ????????? ?? ??? ????? ???? ?? ??? ??? ????? ??????? ???????? ????? IP ??? ????. ????? ?? ?? ???? ??????? TCP/IP ??? SQL Server ??????? ??? ????? ????? ????? ??????? ?? ??? ??? ??? SQL Server:
???? 15:49:14.12 2001-11-14 ??????? SuperSocket: ??? ??? ??? ???? TCP ??? 1433.
?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
307197 PRB: TCP\IP ?????? ??? ????????? ?? ??? ????? ???


?? ???? ??? ??????? ??????? ????? SQL Server ???????? ????? TCP/IP? ???? ??????? ???????? ?????? ??????? ??????? ?? ???????? "????? ??????". ????? ????? ?????? ?? ???? ??????? ?????? ??? ???? ?? ????????? ??? ??????? ???? ??? ?????????:
NETSTAT -an
????? ???? ??????? ???? ??? ??????? Portqry ?????? ??? ???? ?? ????????? ??? ??????? ???? ??? ?????????.

?????? ??? ??????? ?????? ??? ?????? ???????? ???? ??????? Portqry? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
310099 ??? ?????? ???????? Portqry.exe ??? ???????
?????? ??? ??????? ?????? ??? ??? ???????? ???????? ????? ??????? TCP/IP? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
306865 ???: SQL Server ?? ?? ???????? ??? ???? ??????? TCP/IP ??? ?? ?????????? ???


?????? ??????? SQL Server ???????? ???? SQL ???? ???? ????? ?????? ????????? ??? ???? ????. ????? ??? ??? ????? ???? ???? ?? SQL Server? ????? ???? SQL ??????? ??? ?????? ???? ?? ???????? ??????. ??? ??? ?? ???? ??? SQL Server ???? ??????? ?? ??? ???? ???? ???? ???? ??? ???? ?????. ?? ??? ??????? ???? ?? ??? ??? ????? ????? ?????? ?????? ?????? ???? ????. ????? ?? ???? ????? ???? ????? ???? ???? ????? ???? ???? ???????? ???????? "???? ???? ??????? ????????".

?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
286303 INF: ???? SQL Server 2000 ????? ???? ??????? ????? ????? ????? ?????? ??????
823938 ????? ??????? ????? ?????? ???? ????? ?? SQL Server 2000

??????? ????? ???????? MDAC

?? ???? ?????? ??????? ???? ???? ????? MDAC. ??? ???? ??????? ?? ??????? ??? ??? ??????? MDAC ????? ????? ?? ????? ???????? ???? ??? ?? ???? ???? ?????? ??? ????? MDAC. ????? ????? ???? ???? MDAC ?????? ?? ????? MDAC ??? ????????? ????? ??.

?????? ??? ??????? ?????? ??? ????? ????? ????? MDAC? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
301202 ?????: ?????? ?? ????? MDAC

?????? ??? ??? ???? ???? ???? ?? SQL Server? ???? ?? ??? ???? ?????? MDAC 2.6 ?? ????? ???? ??? ???? ????????? ????? ??. ?? ????? ????????? ??????? ?? MDAC ??????? ?????? SQL Server. ????? ?? ?? ???? ????????? ?????? ?????.

????? ??????? ?????? ???????? Odbcping.exe ?????? ?? ????????? ?? ???? ?????? ????? SQL Server ODBC.

?????? ??? ??????? ?????? ??? Odbcping.exe? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
138541 ?????: Odbcping.exe ?????? ?? ????? ODBC ??? SQL Server
?????? ??? ??????? ?????? ??? ????? ????? ????? ?????? ODBC? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
289573 PRB: ????? DSNs ?? SQL Server ???? ????????

????? ???? ?????? ??????? ????? SQL Server ???????? ???.udl.

?????? ??? ??????? ?????? ??? ????? ????? ???.udl? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
244659 ?????: ????? ????? ??? ?????? ?????? ?? Windows 2000

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

?? ???? ???? ???? ????? ??? ????????? ?????? ????? ????????? ???? ?????? SQL Server? ???? ?? ??? ??????? ???????? ??????? ?? ???? ???? ???????.

?????? ??? ??????? ?????? ??? ??????? ???? ??? ????? ???????? ?? ???? ???? ?????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ? Microsoft":
287932 INF: ????? TCP ???????? ??????? ? SQL Server ?? ???? ???? ?????
269882 HOWTO: ??????? ADO ??????? ? SQL Server ??? ???? ?????


??? ??? ?????? ???????? TCP/IP ??????? ????? SQL Server? ???? ?? ??? ????? ??????? ?????? Telnet ??????? ??????? ???? ????? SQL Server. ???????? ?????? Telnet? ?????? ????? ?????? ?? ???? ???????:
Telnet <IP Address> <Port Number>
??? ?? ??? ?????? Telnet ??????? ?????? ????? ????? ????? ?? ????? ??? ???? ??????? ??? ????.

?????? ???? ???? ????? ??? ????? ?????? ?? ??? ??? ???? ???????? ???? ?????? ???????? (UDP) 1434 ??? ???? ???????.

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

?? ?? ???? ????????? ????? SQL ????? ???? ??? ????????. ?? ???? ??? ????????? ?? ????? ???? ????? ????? ???????:
??? ????? ?????? ???????? '??? ????????>'
??? ????? ?????? ???????? '????? ?????? NTAUTHORITY\ANONYMOUS'
??? ????? ?????? ???????? 'null'
??? ????? ????? ????? ???? ???? ??? ?????? ?????? ????? ?? ???? ??? ??? ????? ???? SQL Server ?????? ??????? ??????? ???????? ?????? Windows. ?? ????? ????? ????? ??????? ???? ???? ????? ?? ?????? Windows:
????? ????? ???? SSPI
?? ????? ???????? ??????? ??????? ???????? ??????? ?????????:
  • ???? ?????? ?? ?????? NTLM ?? ?????? Kerberos.
  • ????? ??????? ????? ?????? ??????? ??? ???? ??????????????.
  • ???? ?????? ?????? ????? ??? ????????.
????? ?? ????????? ??? ??????? ????????? ???? ????? ??????? ??? ?????????. ????? ???? ????? ?? ??????? ???????? ?????? Windows? ????? ??????? ?????? ???? SQL ??????? ????? SQL Server.?????? ??? ??????? ?????? ??? ????? ??????? ????? ???????? ??? ????? "????? ????? ???? SSPI"? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
811889 ????? ??????? ????? ????? "????? ????? ???? SSPI"
??? ?? ???? ??????? ??? ??????? ?????? SQL Server? ????? ????? ????? ???????:
??? ????? ?????? ???????? '??? ????????>' . ??? ???????? ?????? ????? ??

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

??? ??? ?????? ?? ????? ?? ???? ????? ??? ??????? ???? ???? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ??? ??? ?????? ????? ???? ??? ????. ????? ???? ?? ????? ??? ??????? ??????. ??????? ????????? ?? ???? ???? ???????? ?? ????? ??? ??????. ??? ???? ????? ??????? ????? ?? ???? ???? ?????. ????? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
322756 ????? ??? ???? ???????? ?? ????? ????????? ?? ???? ??????? Windows
  1. ???? ?? ??? ?? ????? ???? SQL Server ???????? ?????? Windows ??????? ???? SQL. ?????? ????? ???? ?? ?? ??????????? ??????? ??? ????????? ???? ???? ?????? SQLServer. ?????? ????????? ????? SQL:
    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode
    ????? ??? ???? SQL Server:
    HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode
    ???? ?? ??? ??? ????? ??? ????? ??????? ??????:
    ?? ??? ??????????? ??? ??????
    ??? ??????????????
    ?????? Windows ???????1
    ??? ????? (?????? Windows ??????? ???? SQL)2

    ?????? ??? ??? ?????? ??? ??????? ??? ?????? ????? ???????? ??? ??? ????? ???? SQL Server ????????.
  2. ?????? ??????? ????? SQL Server ???????? ?????? Windows ?? ?????? ????? ???? SQL Server. ???? ?? ????? ??? ?? ????? ??? ????????? ??? ????? ???? ????? ?? ??????????? ?????. ??? ???? ??????? ?? ???? ???? ???? ???? ???? ????? ?????? ??????????.
  3. ?????? ??????? ????? SQL Server ???????? ????????????. ??? ???? ??????? ?? ?? ???? ????????? ???? ?????? ?????? ?????????? ???????? TCP/IP ????? ???? ?? ???? ????????? ???? ?????? ?????? Windows ??????????? ?????? ??????? ??????? ???????.
??? ??? ?????? ????????? ?? ????? ????? ??? ???? ???? ???? ????? ???? (SSL) ??? ?????? ??????? ????? SQL Server. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
316898 ?????: ????? ????? SSL ? SQL Server 2000 ???????? ???? ?????? ???????? ? Microsoft
322144 ?????: ????????????????? ????? ??? ??????? ????? SQL


??????? ????? ???????? ??????? ??? ???? ??????? TCP/IP

??? ??????? ?????? ????? SQL Server ODBC ???? Microsoft OLE DB ? SQL Server? ?? ????? System.Data.SqlClient ????? ????? ????? ????? ???? ???????? ?????? ????? ????????? ???????? (APIs). ??? ????? ???? ??????? ???????? ????? ?? ??????? ??? ?????? ???????? ?? ???? ????? ??? ????? ???? SQL Server ????????. ?? ??? ???????? ?? ???? ?????? ??? ?????? JDBC ??????? ????? SQL Server. ????? ?? ???? ????? ????? ??????? ? SQL Server ???? ?? ?????? SQL Server. ??? ?? ???? ???? ??????? TCP/IP? ??? ????? ????? ????? ??????? ?? ??? ??? ??? SQL Server:
??? ???? 20:46:21.11 2003-08-07: 17832? ???????: ???? 20?: 6
??? ???? 20:46:21.11 2003-08-07 ??????? ??? ????? ????? ???? ??? ???? ???? (???). ?? ????? ???????.


?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
154628 INF: SQL ????? 17832 ?? ??? ????? ??????? TCP\IP
328476 ?? ????? ??????? TCP/IP ?????? ????? ???? SQL ??? ?????


?????? ????? ?? ????? ??????? ??? ???? ??????? TCP/IP ??? ??? ?????? SQL Server 2000 SP3 ?? SQL Server 2000 SP3a ???? ?? ????? ?? ???? ????? ?????? ??????. ???? ??? 17832 ??? ??????? ????? ????? ?????? ???????? ??????? ????? SQL Server. ??? ??? ???????? ???? ????? ??? ?????? ??????? ??? ????? ??????? ???? ?? ???????? ????? ?? SQL Server 2000 SP3 ? SQL Server 2000 SP3a.

???? ??? ???? SQL Server ?? ??? ???????? ??????

??? ??? ??? ????? ???? SQL Server ???? ????? ??????? ?? ??? ???????? ??????? ???? ????? ????? ???? ??? ?? SQL Server. ??? ??? ???????? ??? ??????? ??? ????????? ???? ???? ?????? ???? SQL? ????? ??????? ???????? ??????? ???. ??? ???? ??????? ??????? ??????? ???????? ??????? ????? SQL Server:
  • ???? SQL Server
  • ?????? ????? ????????? ?? ??? ??????
  • ?????? ?????? ??????
  • ????? ????????? ?????
  • ????? ??????? ?????? ? Microsoft (IIS)
  • ????? ??????? SQL Server
????? ?????? ???? ??? ?????? ??????? ????? SQL Server ????? ????? ????? ???????:
???? SQL ??? ????? ?? "?? ??? ??????"
???? ??? ????? ???? ??? ????? ????? ???? ???????? SQL ?????? ???? ?????? ??? ??? ????? ????? ???? SQL Server ?? ??? ???????? ??????. ??????? ????? ?? ??????? ????? SQL Server ???????? ????? ????? ??? ????????? ???????? ??? ????.

?????? ??? ??? ???? ???? SQL ?? ???? ?? ??? ???????? ??????? ???? ?????? ??? ??? ????? ??? ??? SQL Server ????? ????? ??? ???:
2003/07/31 11:26:43.79 ????? spid3 * * *
11:26:43.80 2003/07/31 spid3 SQL Server ??? ????? ?? ??? ???????? ??????. ??????? ???? ??????? ??????? ??????.

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

??? ?? ???? ??????? ????? SQL Server ???????? ?????? ??????? ???????? ???? ?? ?? ??? ????? ???? SQL Server ????? ????????? ??????? ??????? ???????.?????? ??? ??????? ?????? ??? ????? ?????? ??????? ??????? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
68941 INF: ??????? ??????? ?????? ??????? ???????

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

?? ??? ??? ???? ????? ???? ?? SQL Server? SQL Server ??????? ?? ????? ??????. ????? ????? ????????? ???? SQL Server ????? ????? ??????? ???? ?? ??? ???????. SQL Server ???? ????? ??? ?????? ??????? ???? ??? ??????? ?????????? ???? ?? ??? ?????? ??? ????? ?????? ??? ?? ????? ???? SQL Server. ??? ?????? ????? ?????????? ????? SQL Server ??????? ??????? ?? ??? ??? ??? SQL Server:
?????? ?????????
????? ????? ?????????? ?? ?? ???? SQL Server ???????. ????? ?????? ??????? ????? SQL Server ????? ??? ????? ?? ???? ????? ??? ?????? ??? ???:
????? ??????
?? ?? ???? ???? ???? SQL Server ???? ????? ???? SQL ???????? ????? ????????. ?????? ????? ????? ??????? ??????? ?? ??? ??? ??? SQL Server? ????? ????????? ?? ??? ?? ??? ????:
?????? ?????????
????? ????????? ????? ??????? ?? ???? ???????? ??? ??? ??????? ????? ?????????.

?????? ??? ?????? ??????? ????? SQL Server

??? ????? ????? ?? ??????? ??? ??????? ????? SQL Server? ????? ??????? ???? ?? ???? ?? ????? ??????? ?????? ??? ????? ???????.
  • ?????? ??????? ????? SQL Server ????????? ?????? SQL Server ? Windows ?????????.
  • ?????? ??????? ????? ????? ???????? ???????? SQL Server? ??? ODBC DSN? ???.udl? ???? ??????? SQL? ???? ???????????????? SQL ?????? ???????? isql ?? ?????? ???????? osql.
  • ?????? ??????? ????? SQL Server ???????? ????????????. ????? ????? ?????????? ?????? ?? ???? ????? ???????? ????? SQL Server ???????? ??? ??????????. ????? ???? ????? ?????????? ?? ????? ??????? ?????? ?? ?? ???? ????? tcp:? np:? lpc:? ?? rpc: ??? ????? ??? ???? SQL Server. ??? ???? ??????? ??? ?? ???? TCP/???????????? ???? ??????? ?????? ??????? ???????.
  • ?????? ??????? ???????? ???? ????? ???? ?????? ???????? ?? ????? ?? ??? ???? ??????? ?????? ??????????? ?????.
  • ?????? ????? ????? ???????? ?? ????? IP ?? ?????????? ???? ???? ?????? ???? SQL Server ??? systemroot%\system32\drivers\etc\hostsfile ?? ??????.
  • ?????? ??????? ????? SQL Server ?? ???? ????????? ???? ???? ?????? SQL Server ??????? ??????.
  • ??? ??? ??????? ?? ????????? ???? ?????? SQL Server? ????? ????? "." ?? "(????)" (???? ?????? ????????) ????? ?? ?????? ??? ?? ?? ??????.
  • ?????? ??????? ????? SQL Server ???????? ??????????? IP ???? ??????.
  • ???? ????? ???? ???? ?? ???? SQL Server ????????????? ??? ?????? ??? ?????? ?? ?? ???? ????? ??? ???? ??? ????????? ????? (MyServer\MyInstance 1433? ??? ???? ??????).

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

??? ?? ??? ?? ????? ??????? ???????? ??????? ?? "?????? ??? ?????? ??????? ????? SQL Server 2000" ??????? ?????? ?????? ???????? "?????? ??????" ??????? ?????? ??????. ?????? ??? ??????? ?????? ??? ???? ???? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
148942 ????? ?????? ???? ???? ???? ??????? ?????? "????? ???? ???????"

294818 ??????? ????????? ??? "????? ???? ???????"

169292 ??????? ????? ?????? TCP/IP

102908 ????? ??????? ????? ????? TCP/IP ???????? ???? ??????? Windows NT ?? Windows 2000


?????? ??? ???? ?? ????????? ???????? ?? ???? ??? ??????? ?????? ???? ????? ??????? SQL. ????? ???? ??????? "???? ????? ???? ???????" ?????? ????????? ??? ??????? ???????? ???? ???? ????? SQL Server ????? ???? ???????.?????? ??? ??????? ?????? ??? ????? ??????? "???? ????? ???? ???????"? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
321708 ?????: ??????? ???? ????? ???? ??????? (Netdiag.exe) ?? ???? ??????? Windows 2000

?????

????? ?? ????????? ??? ?????? ??????? ???????? ???????? ? SQL Server? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
319930 ?????: ??????? ????? ??? ?????? ? Microsoft
257434 INF: ????? ?????? ?? ????? ????? ?????? ?? DSN ???? ???? ??? SQL Server DSN ????????
306985 ????? RPC ??? ??????? ???? ???? ????? ???????? ?????? ??????? ???????
313062 ?????: ??????? ?????? ?????? ???????? "????? ?????? ??????" ?? ???? ??????? Windows 2000
313295 ?????: ??????? ????? ??? ?????? ?? ????? ????? ?????? ????? ???? ??????
320728 ?????: ?? ????? "?? ???? ???? ?????? ?? ???????" ?????
328306 INF: ??????? ???????? ?????? ????? "???? SQL ??? ????? ?? ?? ??? ??????"
247931 INF: ?????? ???????? ????????? ????? SQL ?? "????? ?????? ??????"
169377 ????? ?????? ??? ???? SQL ?? "????? ?????? ??????"
328383 INF: ????? ???? SQL ?? ????? ?????????? ??? ?????? ???????
238949 HOWTO: ????? ????? ???? SQL Server ?? ????? ????? ADO
270126 PRB: ????? ????? ????? ???? ??? ?????? ?????? SQL Server 2000 ??? ??? ????? ???? ????? 7.0
316779 PRB: ?? ???? ??????? ???????? "????? ???????? ???" ??? ??????? ?????? IP
216643 INF: ???????/ODBC OLEDB ?????? ??? ????? ??? ???? ????????? ??? SQL Server 7.0
265808 INF: ????? ??????? ? SQL Server 2000 ??? ?????? ???????? ????? ?????? ??????? ??????
191572 INFO: ??????? ????? ???? ??????? ??????? ADO ?? ASP
313173 ???? ???? ????? ??????? ????????? ?? ?????? ????? Microsoft SQL Server 2000 ? JDBC
237844 HOWTO: ????? ???? ????? ODBC ?? ????? Visual Basic ADO
259569 PRB: ????? ???? ??? ?????? ????? ??????? ????? Windows 2000 MDAC

???????

???? ???????: 827422 - ????? ??? ??????: 06/???? ??????/1435 - ??????: 5.0
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbhowto kbsqlclient kbdll kbclientserver kbclient kbdns kberrmsg kbtshoot kbregistry kbmt KB827422 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????827422

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

 

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