Thank this author by sharing:
By Shashank Srivastava,
When we change the name of the windows machine on whom the SQL Server is running, the SQL server name does not reflect this change. We need to manually add the new server name and remove the old server name.
We have changed the windows machine name from Ahsi-PC to Shashank but when we look for the SQL Server name it will give the old windows machine name. You can see this in the image below. The new name is listed in Object Exporer, but the old name appears on the right as the result of the query.
The SQL instance name has been changed and matches the windows name change.
The minimum rights required to perform this action are in the setupadmin server role.
How to change Windows Authentication to Sql Server Authenticati
If machine name changes will database keep working
Administration, Setup, Server Change
Changed my app connection string from Windows to SQL Server authentication
The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to ...