SQL Server: Invalid Urn filter on server level: filter must be empty, or server attribute must be equal with the true server name

SQL Server Setup sets the server name to the computer name during installation. If someone change the hostname of the computer after installing MSSQL, the MSSQL server name does not change and this causes error message "Invalid Urn filter on server level: filter must be empty, or server attribute must be equal with the true server name".

To check this, execute following:
1. Open cmd, type hostname and execute.
2. Open SQL management studio, in the new query window type SELECT @@SERVERNAME AS 'Server Name' and execute.

Result of 1 and 2 will not match.

To correct the server name, from (as an example) “ServerApp” to “ServerDB”, run this query in SQL management studio.
sp_dropserver 'ServerApp';
GO
sp_addserver 'ServerDB', local;
GO

Restart the server and run the SELECT query again to see the change.

For more information, click here.