Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name

SELECT @@servername AS 'ServerName'

using this line the show new change server name. Then I closed the window of SQL server then open it and type the new change server but show error. Please help me.... I use SQL Server 2008 r2. Windows authentication

Click Here

SELECT  HOST_NAME() AS 'host_name()',
@@servername AS 'ServerName\InstanceName',
SERVERPROPERTY('servername') AS 'ServerName',
SERVERPROPERTY('machinename') AS 'Windows_Name',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS 'NetBIOS_Name',
SERVERPROPERTY('instanceName') AS 'InstanceName',
SERVERPROPERTY('IsClustered') AS 'IsClustered'

EXEC sp_DROPSERVER 'JAYANTA'
EXEC sp_ADDSERVER 'SIASERVER', 'local'

Right click on the server

click Properties

Go to the Security page

Under Server authentication choose the SQL Server

and

Windows Authentication mode radio button

Click OK

Restart SQL Services