PRB: SQL Server ?i l? khng B?t ?u v hi?n th? cc l?i 18456

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

Tri?u ch?ng

b?n ghi d?ch v? ?i l? SQL Server B?t ?u v b?n c th? th?y thng bo l?i sau trong tr?nh Tr?nh xem s? ki?n c?a Windows:
SQLServerAgent c th? khng th? kh?i ?ng (l? do: khng th? k?t n?i ?n my ch?; Khng SQLServerAgent th? kh?i ?ng).
Ngoi ra, n?u b?n c? g?ng ? B?t ?u b?n ghi d?ch v? ?i l? SQL Server t? dong lnh (v d?, C:\MSSQL7\BINN\>sqlagent - c - v) b?n c th? xem cc thng bo l?i sau y trong C:\MSSQL7\LOG\SQLAGENT.TRONG t?p tin:
7/13/99 2: 07: 43 PM-? [129] SQLServerAgent B?t ?u d?i s? ki?m sot b?n ghi d?ch v? Windows NT
7/13/99 2: 07: 43 PM-! [298] SQLServer l?i: 18456, k nh?p th?t b?i cho ng?i s? d?ng 'DomainName\UserName'. [SQLSTATE 28000]
7/13/99 2: 07: 43 PM-! [000] Khng th? ? k?t n?i v?i my ch?; SQLServerAgent khng th? kh?i ?ng
7/13/99 2: 07: 44 PM-? [098] SQLServerAgent ch?m d?t (b?nh th?ng)

Nguyn nhn

B? k nh?p BUILTIN\Administrators khng c quy?n truy c?p vo SQL Server ho?c ? b? xo b? k nh?p BUILTIN\Administrators t? SQL Server v cc b?n ghi d?ch v? SQLAgent B?t ?u t? trong ti kho?n LocalSystem.

V?n ? khng x?y ra n?u cc b?n ghi d?ch v? SQLAgent B?t ?u trong m?t ti kho?n tn mi?n ho?c my tnh, m li?t k m?t cch ring bi?t trong SQL Server Enterprise Manager v c ?c quy?n ngi quan tri h thng (General).

Cch gi?i quy?t khc

? a cc ti kho?n BUILTIN\Administrators tr? l?i vo SQL my ch?, B?t ?u SQL Enterprise Manager. i ?n \Servername\Security\Logins v c?p quy?n truy c?p cho ng?i dng BUILTIN\Administrators.

N?u b?n th?c s? mu?n t? ch?i truy c?p cho SQL Server b?i qu?n tr? vin Windows NT, b?n c th? lo?i b? cc ti kho?n BUILTIN\Administrators. ?u tin thm ti kho?n k nh?p b?n ang s? d?ng cho cc b?n ghi d?ch v? ?i l? SQL nh l m?t SQL Server k nh?p v gn vai tr? ng?i ngi quan tri h thng (sa) cho ti kho?n . Sau thu h?i quy?n truy c?p vai tr? ng?i ngi quan tri h thng (General) t? cc ti kho?n BUILTIN\Administrators, ho?c xo ti kho?n BUILTIN\Administrators hon ton t? cc tin k nh?p trong SQL Server Enterprise Manager.

? bi?t thm chi ti?t, xem SQL Server sch tr?c tuy?n ch? ? "Xem v thay ?i vai tr? vin," l c s?n t?i MSDN Web site sau:
http://MSDN.Microsoft.com/en-US/Library/aa905209.aspx

Thng tin thm

Lu ? r?ng khi b?n ch?y cc b?n ghi d?ch v? b?ng cch b?m vo Panel iu khin, sau ch?n b?n ghi d?ch v? m khng c b?t k? l?i h?u ch. B?n c?n ph?i ki?m tra tr?nh Tr?nh xem s? ki?n c?a Windows ho?c B?t ?u cc b?n ghi d?ch v? t? d?u ki?m nh?c l?nh ? xem chng.

Thu?c tnh

ID c?a bi: 237604 - L?n xem xt sau cng: 03 Thang Mi Hai 2012 - Xem xt l?i: 4.0
p d?ng
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
T? kha:
kbsqlsetup kbprb kbmt KB237604 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: 237604

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