I am trying to alter permissions to some of my users using GUI. When I press Script Out or OK, I am receiving this error attached. Has anyone experienced this error and what did you to resolve this issue?

I am trying to alter permissions to some of my users using GUI. When I press Script Out or OK, I am receiving this error attached. Has anyone experienced this error and what did you to resolve this issue?

Hi @SQLLover21-0870,
According to my test, this error occurs when the computer name is inconsistent with the server name stored in the SQL server instance.
SQL Server Setup sets the server name to the computer name during the installation, it seems the Hostname of the computer has been changed in your environment.
To check this, you can use the following script:
select host_name()
select @@servername
If the result is different, you can use the following script to change it:
EXEC sp_dropserver '<old_name>';
GO
EXEC sp_addserver '<new_name>', local;
GO
After executing the above command, please restart the instance of SQL Server.
See below for more information:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-ver15
17 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index