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

Problem Statement:

One of my colleague has reported an issue as below while he is trying to restore a database from backup.

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

To my best knowledge, I was seeing this error first time and I was trying to understand about the issue with my google search and there are quite few good posts out there too.

http://blog.patricknielsen.net/2011/01/sql-server-invalid-urn-filter-on-server.html
https://debabratahowlee.blogspot.com/2016/09/sql-server-invalid-urn-filter-on-server.html

But somehow I was thinking something different as I was sure there were no activities at server level. Then I simply closed all open connections and restarted SSMS and tried and it worked perfectly this time. So, I do not have any clue yet what would have happened under the cover, however, am sure there is something gone bad it could be a failover/underlined network or anything that it could not resolve the server name.

If you have any different thoughts, please share in comment section.

I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s