Is it possible to redirect queries to another server? I want to set up a server that redirects queries. It would receive incoming SQL Server traffic, redirect to the actual SQL Server, and return results back to the client. 

Is this possible? What are my options?
First Things that come to my mind:

1 Linked Servers
You can use a linked Server and forward all requests to it, but then the calling Code or Programm must use prepared procedures or views that use the linked Server. 

2 SQL alias, but I guess this is not what you are looking for. 

But I wonder why would you do that? I can't See advantages.

Think about license Costs. They may double if you Do this kind of scenario in a production Environment. 

Monitoring and tracing : administrative effort increases and again Costs. 

And Security. It's Trick to configure linked Server connection to reuse the calling Logins to make sure you dont Open All Gates to anyone who can access the "Proxy".