Getting Error 10054 after renaming the server
See the Microsoft Docs article Rename a Computer that Hosts a Stand-Alone Instance of SQL Server.

You'll need to restart the SQL Server service, and use sp_dropserver / sp_addserver to update the server name within SQL Server.