Blog Post: ???????????????? SQL Server ??? ???????? ???????. ????? 2.

? ?????????? ????? ?? ???????????? ?? ?????? ?????????????? SQL Server ??????, ??????? ????? ???????? ??? ?????? netstat ? ?? ??????????????, ? ?????????, ????????????? ?????????????? ???? TCPView, ??????? ???????????? Artem ? ???????????? ? ?????. ? ?????????, ? ????????-????????????? ???????? ??????????? ??????? ?????????????? ? ???????? ????. Netstat ??????? ?????? ? ???, ??? ???? ?????-?? ???????, ??????? ??????? ?? ??????-?? ?????. ????????, ?? ????? 192.168.0.2 ??????? SQL Server, ??????? ??????? ?? ????? 1433, Analysis Services, ??????? ??????? ?? ????? 2383 ? ?.?.:

???.1

?? ???? ??? ????? ??????? ?? ????????, ?? ??? ????? ???????????? ??????? ??????, ?? ?????? ??????? ?? ???????. ? ???????? ??????? ????????? ??????? ?????????????? ?????? ?? 192.168.0.2 ? ?????? 192.168.0.1:

if exists(select 1 from sys.servers where name = 'Denalium') exec sp_dropserver @server = 'Denalium', @droplogins = 'droplogins'

exec sp_addlinkedserver @server = N'Denalium', @srvproduct = N'', @provider = N'SQLNCLI', @datasrc = N'192.168.0.2'

exec sp_addlinkedsrvlogin @rmtsrvname = 'Denalium', @locallogin = null, @rmtuser = 'sa', @rmtpassword = 'passw0rd'

exec sp_tables_ex @table_server = 'Denalium', @table_catalog = 'Adventure Works 2008R2'

?????? 1

????????? ???????? ??????????? ? ???????:

Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 41

The OLE DB provider "SQLNCLI10" for linked server "Denalium" reported an error. The provider did not give any information about the error.

Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "Denalium".

??????, ??? ??????? ?? ??????????, ?????? ??????????, ??????????????, ???????, ??? ??????? ???????? SQL Server??? ??????, ?????????? ????, ???????????, ?????????? ?????????, ??? SQL Server 192.168.0.1 ????? ???????? ??????????? ?? SQL Server 192.168.0.2. ?????????????, ???? ?? 192.168.0.1 ???????????? ???? 1433 ?? 192.168.0.2:

???.2

?? ?????, ??? ?? ??????. ? ?????? ?????? ?????????????? ??????? Microsoft?????? ???? PortQry, ??????? ????? ??????? ? Microsoft Downloads, ????? ????????????? ? ?????????? ?????. PortQry ????? ?????????????? ? ???????? ??????????? ??????????? ????????? ???????. ????????, ? ??? ????? ???????? ?????? ??????, ???????????? SQL Server ? ??? ???????????? (??. ? ??????? ?????) ? ??????????, ??? ?? ??? ??????, ??? ???:

c:\temp\portqryv2\portqry.exe -n 192.168.0.2 -p TCP -o 1433,1434,80,443,4022,21,137,138,139,135,2383,2382

c:\temp\portqryv2\portqry.exe -n 192.168.0.2 -p UDP -o 1434,500,4500

???.3

????? ???????? ???????? ??????: c:\temp\portqryv2\portqry.exe -n 192.168.0.2 -p TCP -r 137:139 ? ?.?.

????????? ?????? - ??? ??????, ????? ? ?????? ?????? ???? ????????? ??????? SQL Server (????? ??????? ?????????????? ??????, ????????? ??????????????, ?????????? ? ??????-????????, ...). ??? ?????? ????? ?????????? ?? ???.1, ????? ??????, ???? ????? SQL Server, ?.?. ?? ????? ?????? ?? ??????? = ??????? ???????? ????????????. ??, ??-??????, ??????? ????? ???? ?????, ??-??????, ?? ??? ??? ????? ????? ????????? ? SQL Server, ???, ????????, ????? 135, 80 ? ?.?. ????? ???????? ?????? - ??? ???????? ?????????????? ?? ????????, ????????? ???????? ? ??????????, ? ????? ????? ??? (???????? ??????) ??????????????. ??? ?????? ????? ?????????, ??? ??????? ????????????? ??????? ? ???????? ??????. ?? ???????? 192.168.0.2 ??? ? Control Panel -> Administrative Tools -> Windows Firewall with Advanced Security (??? wf.msc ?? ????????? ??????); ????? ? ????? ?????? ?? ?????? ? ?? ???????????? ???? ??? ?? ?????? ?????? ???????? Properties. ? ??????????? ?????????? ???? ??????? ? ??????? ???????? Private Profile, ?????? ??? ?????????? ?? 192.168.0.1 ? ???? ?????? ????????? ? ????? ???????, ? ???????? ??? ???? Windows Firewall:

???.4

?????? sp_tables_ex ?? ?????????????? ?????? ????????:

???.5

??????, ???????? ????????????? ? ???, ??? ?? ???????? 192.168.0.2 ????????? ?????-?? ??????????? ?????. ???????? ??????, ?????. ??? ????? ?? ???.4 ??????? ??????? ??????? ?? 192.168.0.2 ? ??????? Private, ??????? ?????? Customize ? ?????? Logging ? ??????? ?????????????? ??????????? ??????? ???????

 

???.6

????? ???????? ????????? sp_tables_ex ? ???????? ????????????, ????? ?? ?????????? ???????. ???????? ? ????????? ????????? ????, ??????? ?? ???.6 ?????? ? ???????? ???????:

???.7

???????? ??????? ?????????? ? ??????? ???????: ????, ?????, ???????? (DROP ????????, ??? ????? ??? ?????????), ???????? (TCP, UDP, ICMP, ?), ? ?????? IP ??? ?????, ?? ?????, ? ?????? ?????, ?? ?????, ?????? ?????? ? ?.?. ? ??????? Path ??????????? ???????????. RECEIVE ? ?????? ?????? ????????, ??? ?? ????????? ? 192.168.0.2 ??? ???? ???????? ????????????. ??????? ???????????? ??????? ?? ????? 500 ? ?????? - ??? IPSec. ???????? 1433 ? ???? ????????? ????????, ??? SSMS ?? 192.168.0.1 ?????????? ?????? ? ??????? ?? 192.168.0.2, ??????? ??????????? ?? ????????? SQL Server. ????? ???????? 1433 ?? 192.168.0.2:

netsh advfirewall firewall add rule "SQL Srv" dir=in action=allow enable=yes profile=private protocol=tcp remoteip=192.168.0.1 localport=1433

???.8

??? ????????? ??????? (???.5).

 

Ana Hickmann Mischa Barton Jamie Lynn Sigler Stacy Keibler Rihanna