RPC Execution Server name does not exist error in AD

RPC Error in AD Migrated PC

While Execute RPC Script in AD Migrated PC it shows error message.

The same RPC Query Execution error in SQL. The server 'Server Name' does not exist. Use SP_helpserver to shaow available servers.

Solution

Rename the SQL Server first using the below query

Check SQL Server Name

SELECT @@SERVERNAME

Default Instance for Drop / Add Server

EXEC sp_dropserver 'Your_OLD_Computer_Name'
GO
EXEC sp_addserver 'Your_NEW_Computer_Name', 'local'
GO

1. Restart the SQL Server services.
2. Execute the below query in each instance to verify the updated system metadata.

Check the renamed server name

SELECT @@SERVERNAME

Execute Below Mentioned query

exec sp_serveroption @server='Your_NEW_Computer_Name', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server='Your_NEW_Computer_Name', @optname='rpc out', @optvalue='true'
go 

Now you can execute the RPC Tool / Query to Update SQL

RPC Tool