Lm th? no ? m? c?ng t?ng l?a cho SQL Server trn Windows Server 2008

D?ch tiu ? D?ch tiu ?
ID c?a bi: 968872 - Xem s?n ph?m m bi ny p d?ng vo.
N?u b?n l m?t khch hng doanh nghi?p nh?, t?m thm x? l? s? c? v h?c t?p t?i cc H? tr? cho doanh nghi?p nh? web site.
Bung t?t c? | Thu g?n t?t c?

Tm t?t

T?ng l?a c?a Windows trn Windows Server 2008 gip ngn ch?n truy c?p tri php vo ti nguyn my tnh. Tuy nhin, n?u cc b?c t?ng l?a ?c c?u h?nh khng chnh xc, cc n? l?c ? k?t n?i v?i m?t tr?ng h?p c?a Microsoft SQL Server c th? b? ch?n. ? truy c?p m?t th? hi?n c?a SQL Server l pha sau b?c t?ng l?a, b?n ph?i c?u h?nh t?ng l?a trn my tnh ang ch?y SQL Server.

Bi vi?t ny s? gip b?n m? c?ng t?ng l?a cho SQL Server trn Windows Server 2008.

? c chng ti s?a ch?a v?n ? ny cho b?n, h?y vo cc "S?a ch?a n cho ti"ph?n. N?u b?n thch ? kh?c ph?c v?n ? ny chnh m?nh, i ?n cc "H?y ? ti s?a ch?a n b?n thn m?nh"ph?n.

S?a ch?a n cho ti

? kh?c ph?c v?n ? ny t? ?ng, b?m vo cc Kh?c ph?c v?n ? ny lin k?t. B?m chu?t Ch?y trong cc T?i t?p xu?ng hp thoai h?p, v sau lm theo cc b?c trong thu?t s? ny.


Kh?c ph?c v?n ? ny
Microsoft Fix it 50169



Lu ?Thu?t s? ny c th? b?ng ti?ng Anh ch?, nhng s?a ch?a t? ?ng c?ng ho?t ?ng cho cc phin b?n ngn ng? khc c?a Windows.

Lu ?N?u b?n khng ph?i trn my tnh c s? c?, lu s?a ch?a n l gi?i php cho m?t ia flash ho?c CD r?i ch?y trn my tnh x?y ra s? c?.

Ti?p theo, h?y vo cc "i?u ny c kh?c ph?c v?n ??"ph?n.

H?y ? ti s?a ch?a n b?n thn m?nh

K?ch b?n ?c th?o lu?n trong ph?n ny m? c?ng t?ng l?a cho SQL Server.

? t?o ra cc t?p l?nh, h?y lm theo cc b?c sau:
  1. B?t ?u Notepad.
  2. Sao chp v dn o?n m? sau vo Notepad:

    netsh advfirewall firewall add rule name="Open Port 80" dir=in action=allow protocol=TCP localport=80
    
    @echo =========  SQL Server Ports  ===================
    @echo Enabling SQLServer default instance port 1433
    netsh advfirewall firewall add rule name="SQL Server" dir=in action=allow protocol=TCP localport=1433
    @echo Enabling Dedicated Admin Connection port 1434
    netsh advfirewall firewall add rule name="SQL Admin Connection" dir=in action=allow protocol=TCP localport=1434
    @echo Enabling Conventional SQL Server Service Broker port 4022
    netsh advfirewall firewall add rule name="SQL Service Broker" dir=in action=allow protocol=TCP localport=4022
    @echo Enabling Transact SQL/RPC port 135
    netsh advfirewall firewall add rule name="SQL Debugger/RPC" dir=in action=allow protocol=TCP localport=135
    @echo =========  Analysis Services Ports  ==============
    @echo Enabling SSAS Default Instance port 2383
    netsh advfirewall firewall add rule name="Analysis Services" dir=in action=allow protocol=TCP localport=2383
    @echo Enabling SQL Server Browser Service port 2382
    netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow protocol=TCP localport=2382
    
    @echo =========  Misc Applications  ==============
    @echo Enabling HTTP port 80
    netsh advfirewall firewall add rule name="HTTP" dir=in action=allow protocol=TCP localport=80
    @echo Enabling SSL port 443
    netsh advfirewall firewall add rule name="SSL" dir=in action=allow protocol=TCP localport=443
    @echo Enabling port for SQL Server Browser Service's 'Browse' Button
    netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow protocol=UDP localport=1434
    @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
    netsh firewall set multicastbroadcastresponse ENABLE
  3. Lu t?p d?i d?ng m?t t?p tin txt b?ng cch s? d?ng tn sau: OpenSqlServerPort.txt
  4. ?i tn cc t?p tin OpenSqlServerPort.txt nh sau: OpenSqlServerPort.bat


Tr?c khi b?n ch?y OpenSqlServerPort.bat script, b?n ph?i sao chp o?n m? ? my tnh c cc b?c t?ng l?a v sau ch?y script trn my tnh . ? ch?y script, h?y lm theo cc b?c sau:
  1. B?m chu?tB?t ?u, b?m voCh?y, lo?iCMD, v sau nh?p voOk.
  2. T?i d?u ki?m nh?c l?nh, s? d?ng cc ?a compact l?nh ? di chuy?n vo m?c tin th thoai m b?n lu cc t?p tin OpenSqlServerPort.bat.
  3. ? ch?y OpenSqlServerPort.bat script, g?OpenSqlServerPort.batt?i d?u ki?m nh?c l?nh v sau nh?n Enter.

i?u ny c kh?c ph?c v?n ??

Ki?m tra cho d v?n ? ?c c? ?nh b?ng cch c? g?ng ? truy c?p vo tr?ng h?p c?a SQL Server t? my tnh khc. N?u v?n ? c? ?nh, b?n ? k?t thc v?i bi vi?t ny. N?u v?n ? khng c? ?nh, b?n c th? lin h? v?i h? tr?.

Thu?c tnh

ID c?a bi: 968872 - L?n xem xt sau cng: 07 Thang Sau 2013 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Windows Server 2008 Datacenter without Hyper-V
  • Windows Server 2008 Enterprise without Hyper-V
  • Windows Server 2008 for Itanium-Based Systems
  • Windows Server 2008 Standard without Hyper-V
  • Windows Server 2008 Datacenter
  • Windows Server 2008 Enterprise
  • Windows Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
T? kha:
kbsqlsetup kbmsifixme kbtshoot kbsurveynew kbfixme kbmt KB968872 KbMtvi
My d?ch
QUAN TRONG: Bai vit nay c d?ch b?ng phn mm dich thu?t cua Microsoft va co th c Cng ng Microsoft chinh sa l?i thng qua cng ngh CTF thay vi mt bin dich vin chuyn nghip. Microsoft cung c?p cc bi vi?t ?c c? bin d?ch vin v ph?n m?m d?ch thu?t th?c hi?n v c?ng ?ng ch?nh s?a l?i ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng nhi?u ngn ng? Tuy nhin, bi vi?t do my d?ch hoc thm chi cng ng chinh sa sau khng ph?i lc no c?ng hon h?o. Cc bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny: 968872

Cung cp Phan hi

 

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