Hi @SQLLover21 ,
According to my test, this error occurs when the computer name is inconsistent with the server name stored in the SQL server instance.
SQL Server Setup sets the server name to the computer name during the installation, it seems the Hostname of the computer has been changed in your environment.
To check this, you can use the following script:
select host_name()
select @@servername
If the result is different, you can use the following script to change it:
EXEC sp_dropserver '<old_name>';
GO
EXEC sp_addserver '<new_name>', local;
GO
After executing the above command, please restart the instance of SQL Server.
See below for more information:
https://learn.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-ver15