Is it possible to redirect queries to another server?
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".