PRB: Ch? Unicode Collating tr?nh t? v Windows NT Logins

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

? Trang ny

TRI?U CH?NG

Khi b?n thm trng m?c ng nh?p Windows NT hi?n c nh m?t ng nh?p Microsoft SQL Server, b?n nh?n ?c thng bo l?i sau:
L?i 15401
Windows NT ng?i dng ho?c nhm 'Domain_name\User_name' khng t?m th?y.
Ki?m tra tn m?t l?n n?a.

NGUYN NHN

V?n ? ny x?y ra b?i v? b?n ci ?t SQL Server b?ng cch s? d?ng m?t ch? Unicode collating chu?i.

CCH GI?I QUY?T KHC

B?n c th? thm ng nh?p m?i ny trong SQL Server b?ng cch g? tn ng?i dng ho?c nhm tn chnh xc nh n ?c nh?p vo trong ng?i s? d?ng qu?n l? tn mi?n. (i?u ny bao g?m vi?c s? d?ng cc tr?ng h?p ban ?u cho m?i th.) B?n c th? sao tn ny kh?i tr?nh qu?n l ng?i dng cho tn mi?n cho SQL Server qu?n l? doanh nghi?p.

THNG TIN THM

Hnh vi ny ?c lin k?t ch? ?n Unicode tr?ng h?p nh?y c?m. Hnh vi ny khng x?y ra n?u b?n ch? s?a ?i th? t? s?p x?p.

Cc b?c ? t?o l?i v?n ?

  1. Ci ?t SQL Server b?ng cch s? d?ng m?t tr?nh t? collating ch? Unicode. H?y ch?c ch?n r?ng b?n b?m vo ? xa cc Ch? hoa h?p ki?m bn c?nh cc Nh?n d?ng Unicode Locale h?p danh sch.
  2. Dng b? qu?n l? ng?i dng Windows NT cho tn mi?n ? t?o m?t ng?i dng m?i ?c ?t tn Domain_name\Test. H?y g? tn ng?i dng ny b?ng cch s? d?ng c? ch? hoa v ch? th?ng ch?.

    Lu ? Trong tn ng?i dng ny, Domain_name ?i di?n cho tn mi?n th?c.
  3. Trong SQL Server Enterprise Manager, b?m chu?t ph?i vo cc ng nh?p bi?u t?ng trong th m?c b?o m?t, v sau nh?p vo ng nh?p m?i trn tr?nh n phm t?t.
  4. Trong cc Tn h?p tho?i, g? tn ng?i dng m b?n ? t?o ? b?c 2. V d?, g? nh sau:
    Domain_name\TEST
    H?y ch?c ch?n r?ng b?n g? tn ng?i dng ny b?ng cch s? d?ng ch? thng. B?ng cch ny, b?n nh?n ?c thng bo l?i sau:
    L?i 15401
    Windows NT ng?i dng ho?c nhm 'Domain_name\TEST' khng t?m th?y.
    Ki?m tra tn m?t l?n n?a.
  5. Trong truy v?n Analyzer, ch?y truy v?n sau y:
    exec master..sp_grantlogin '<Domain_name>\TEST'
    
    Khi b?n ch?y truy v?n ny, b?n nh?n ?c thng bo l?i sau:
    My ch?: Msg 15401, c?p 11, bang 1, th? t?c sp_grantlogin, Line 36
    Windows NT ng?i dng ho?c nhm 'Domain_name\TEST' khng t?m th?y. Ki?m tra tn m?t l?n n?a.

Thu?c tnh

ID c?a bi: 245768 - L?n xem xt sau cng: 12 Thang Hai 2012 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
T? kha:
kbprb kbmt KB245768 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:245768

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