Solved

Firewall forward Ip to other

Posted on 2015-02-10
3
95 Views
Last Modified: 2015-02-11
Hi I need help with this scenario, my company get a new ISP comcast ethernet, but the public IP configuration is different  we use a DMZ port kinda like new network, so that means the internal IP will be different for my servers, I have many user with ODBC connections point to my SQL but now my SQL will be different IP segment , so exist way to keep the IP in that ODBC and forward to the new SQL ip?


Current SQL IP: 10.1.1.101
New IP with new ISP : 10.10.10.101

my problem is too many (400) users to change manually the ODBC IP
0
Comment
Question by:PLCITS
3 Comments
 
LVL 5

Accepted Solution

by:
R. Toby Richards earned 500 total points
ID: 40601311
If ODBC is configured with the server's name then the client ODBC's should get the new IP from DNS. If not, then another option would be to create a logon script that changes the client's ODBC settings:

regedit /s \\somefileserver\odbc.reg

where "odbc.reg" contains:

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\YourODBCName]
"Server"="YourServerName"
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 40601391
If you have a sophisticated router/firewall for accessing the DMZ, it could perform IP address translation for the old to the new IP. But that is a setup full of pitfalls.
Best option is as posted above.
0
 
LVL 10

Expert Comment

by:Rafael
ID: 40602427
I would look at updating the route table and possibly the TNS host file.  That can be scripted to cut your time in half when updating.
0

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever set up your wireless router at home or in the office to find that you little pop-up bubble in the bottom right-hand corner of Windows read "IP Conflict - One of more computers on the network have been assigned the following IP address"…
Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question