Error: "The SQL Server has a server name mismatch..." during Instance Configuration.
説明
Error received during Instance Configuration:
"The SQL Server has a server name mismatch, possibly caused by the computer being renamed after the Instance was installed. Would you like to fix this now? Note: fixing this now causes the SQL Server Service to be restarted."
原因
The value stored in @@servername is different than the actual name of the server. The computer name was renamed after the SQL Server was installed.
対策
The SQL Server table sysservers must be modified, you may be able to still connect to the SQL Server after renaming the computer name, but this SQL Server must be edited.
Manually run this procedure from SQL Server Query Analyzer:
Prerequisite: 1) set @OldName to the current value of @@servername (find this out by running 'select @@servername' in query analyzer) 2) set @NewName to the actual server name ----------------------------- Declare @OldName varchar(256) Declare @NewName varchar(256) set @OldName='OLD_SERVERNAME' select @OldName=isnull(srvname,'') from master.dbo.sysservers where srvid=0 set @NewName='NEW_SERVERNAME' Exec master.dbo.sp_dropserver @OldName Exec master.dbo.sp_addserver @NewName,'local'
NOTE: This procedure requires a SQL Server services restart.
Refer to SQL Server Books on Line and Microsoft to solve this problem. This is not a LiteSpeed problem but the environment has to be adjusted for LiteSpeed to work properly.
追加情報
Applies to SQL Server version 7 and 2000 and all version of Windows and LiteSpeed for SQL Server.
