I have a LAN in which clients connect to the SQL Server installed on a server with the IP address of 192.168.1.10 (
I have another SQL Server instance installed on another server with the IP address of 192.168.3.11 (
The servers are routed to each other so I can connect to one instance by SSMS from the other server.
The problem is I need to connect from the clients in the LAN (192.168.1.0) to the instance installed on
Is there a way to create an alias instance on
SERVER_A which points to the instance installed on
SERVER_B? So I can connect to
SERVER_A and it redirects me to
I have an application and I can't change how it talks to the database. So I have to create all the Tables, Views and SPs again on
SERVER_A and redirect them to tables, views, and SPs on
SERVER_B. I want to use something like aliasing. However the problem is I can connect to the instance locally but not remotely when I use alias instance name.