Lm th? no ? thi?t l?p my ch? SQL ? l?ng nghe trn nhi?u c?ng TCP t?nh

D?ch tiu ? D?ch tiu ?
ID c?a bi: 294453 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

TM T?T

Bi vi?t ny m t? cch kch ho?t m?t tr?ng h?p m?c ?nh SQL Server ? l?ng nghe trn c?ng TCP nhi?u.

THNG TIN THM

?i v?i m?i th vi?n pha my ch? m?ng, SQL Server thi?t l?p m?t ch? ? "nghe trn" ring bi?t. N?u my ch? tr? nn trn ng?p v?i cc yu c?u k?t n?i, k?t n?i khch hng ?c thi?t l?p l?i v bu?c ph?i thi?t l?p l?i m?t phin lm vi?c m?i. ? tng hi?u su?t c?a my ch? SQL Server ? x? l? ?ng th?i nhi?u k?t n?i hn yu c?u, thm TCP c?ng l?ng nghe ngy c th? ?c thm.Thm c?ng TCP b? sung, h?y lm theo cc b?c sau:
  1. B?t ?u cc ti?n ch SQL Server m?ng trong SQL Server 2000. Ch?n TCP, b?m Thu?c tnh, v sau nh?p thm c?ng cch nhau b?ng d?u ph?y; V d?: 1433,5000.
  2. D?ng l?i v sau kh?i ?ng l?i my ch? SQL Server, v xem xt errorlog. Errorlog c?a b?n nn trng gi?ng nh sau:
    SQL server listening on TCP, Shared Memory, Named Pipes.<BR/>
    SQL server listening on 157.54.178.42:1433, 157.54.178.42:5000, 127.0.0.1:1433, 127.0.0.1:5000.
    					
  3. S? d?ng cc SQL Server khch hng m?ng Utility ? s?a ?i cc khch hng c?a b?n ? ly lan xem qua t?i c?ng TCP. V d?, hai my ch? Web, c? hai ang k?t n?i ?n my ch? SQL cng trn c?ng 1433, by gi? c th? chia t?i trn 1433 v 5000. i?u ny cho php cc qu?n tr? vin ? tch lu l?ng truy c?p trn nhi?u c?ng v tng thng l?ng k?t n?i.
Chu y Th?c hi?n cng m?t thao tc trong SQL Server 2005, s? d?ng cng c? qu?n l? c?u h?nh my ch? SQL.

Thu?c tnh

ID c?a bi: 294453 - L?n xem xt sau cng: 25 Thang Tam 2011 - Xem xt l?i: 3.0
p d?ng
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition
T? kha:
kbinfo kbmt KB294453 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? 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 ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. 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. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:294453

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