After renaming the Windows server, issue a sp_dropserver, sp_addserver and restart MSSQL services.

use master

go

exec sp_dropserver 'old server name'

go

sp_addserver 'new server name', 'local'

go