L?I: "Vi?c ?i tn A Server" ch? ? trong SQL Server sch tr?c tuy?n l Incomplete

D?ch tiu ? D?ch tiu ?
ID c?a bi: 303774 - Xem s?n ph?m m bi ny p d?ng vo.
L?I #: 354825 (SHILOH_BUGS)
Bung t?t c? | Thu g?n t?t c?

TRI?U CH?NG

V d? trong cc ch? ? SQL Server 2000 cu?n sch tr?c tuy?n "Vi?c ?i tn m?t my ch?" l khng ?y ?. Cc t? kha "local" l m?t tch t? cc V d?.

V d? SQL Server sch tr?c tuy?n bao g?m:

sp_dropserver old_name
go
sp_addserver new_name
go
Cc v d? ng l:

sp_dropserver 'old_name' 
go 
sp_addserver 'new_name', 'local' 
go 		

Ch?y cc sp_dropserver th? t?c ?c lu tr? trn m?t my ch? c lin quan ?n t? xa v my ch? ?c lin k?t ng nh?p m?c k?t qu? trong m?t thng bo l?i. Thng bo l?i ni r?ng b?n ph?i lo?i b? cc tin ng nh?p tr?c khi b?n lo?i b? t? xa ho?c cc my ch? ?c lin k?t. ? lo?i b? t?t c? cc t? xa v ng nh?p my ch? ?c lin k?t cho m?t h? ph?c v? khi b?n lo?i b? cc my ch?, s? d?ng cc droplogins ?i s?:

sp_dropserver 'old_name', 'droplogins' 
go 
sp_addserver 'new_name', 'local' 
go

Chu y Sau khi ch?y cc sp_addserver th? t?c ?c lu tr?, b?n ph?i kh?i ?ng l?i d?ch v? SQL Server cho cc thay ?i ? @@ SERVERNAME c hi?u l?c.

SQL Server sch tr?c tuy?n c?ng cho r?ng cc sau:

You do not have to run Setup again to reset the computer name.
				
Tuyn b? tr?c l ch? ng n?u n khng ph?i l m?t ?o h? ph?c v?. ? ?i tn m?t my ch? ?o, b?n ph?i g? ci ?t, v sau ci ?t l?i cc my ch? ?o.

NGUYN NHN

y l m?t vi l? do t?i sao my ch? SQL SERVERNAME c th? l NULL ho?c khng ph h?p v?i cc my tnh hi?n t?i c?a Microsoft Windows NT Tn:
  • My tnh ? ?c ?i tn.

  • M?t h?nh ?nh ?c ch?p c?a SQL my tnh, v sau sao chp vo my tnh khc.

  • Cc sp_dropserver th? t?c ?c lu tr? ?c i?u hnh cho cc ?a phng SERVERNAME.

T?NH TR?NG

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong cc s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho" c?a bi vi?t ny.

THNG TIN THM

? ki?m tra xem n?u b?n c m?t khng ph h?p gi?a my ch? SQL c?a b?n ServerName v c?a my tnh machinename, so snh cc gi tr? t? cc l?i tuyn b? lm theo. N?u cc gi tr? khng ph h?p ho?c n?u @@ SERVERNAME l NULL, b?n c?n ph?i ?i tn my ch? SQL c?a b?n. Vi du:
-- get current SQL Server name\instance name
  SELECT @@SERVERNAME
-- get current machine name and instance name
  SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY ('InstanceName')
				

THAM KH?O

? thm thng tin v? vi?c ?i tn SQL Server 7.0, b?m vo s? bi vi?t d?i y ? xem cc bi vi?t trong cc C s? ki?n th?c Microsoft:
195759 INF: Th?ng xuyn h?i cu h?i - SQL Server 7.0 - SQL Setup

Thu?c tnh

ID c?a bi: 303774 - L?n xem xt sau cng: 26 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2000 Standard Edition
T? kha:
kbbug kbpending kbmt KB303774 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:303774

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