Solution to the error of MSSQL2005 server after reinstallation and rename under the Out-of-Star Virtual Host Management System

The error message is:
"The server 'BBB' is not found in ". Verify that the specified server name is correct. If necessary, execute the stored procedure sp_addlinkedserver to add the server to."
Or:
"This cursor does not include the table being modified, or the table cannot be updated with this cursor."

The reason is that after installing the system, the name of the computer was changed. The original name was "AAA" and the new computer was "BBB".
Solution:

first step:
Open SQL Server Management Studio and create a new query:
select * from
GO
//The original computer name can be obtained here. Then record it (copy it)
(For example, the original name is AA)

Step 2:
Create a new query:
sp_dropserver [AAA]
GO
sp_dropserver [BBB]
GO
//Here we delete the original name and the current name.

Step 3:
Create a new query:
sp_addserver [BBB],local
GO

//This is the new server name BBB

Step 4:
Create a new query:
sp_serveroption 'BBB','data access', 'true'
GO
Restarting the server is done.
Note that the server must be restarted!