Invalid Urn filter on server level SQL Server error

Question

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?

Answer 1

Hi @SQLLover21 ,

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://learn.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