set SQL to listen to multiple id address

[gensan]

Hi,

I have a server in location A (LocA) which I want to access in LocB via VPN. As I understand it, SQL server dynamically reads what is the available IP add and listens using that IP.

Here's my problem. during startup, the VPN IP Add is not yet available. So SQL server does not assign the ip add. When I look at the log, it says that is is listening at xxx.xxx.xxx.8 How do I force SQL to listen to xxx.xxx.xxx.9 even if that IP add is not yet available (VPN connection not yet established.

Thanks in advance.

 

[NoCoolHandle]

How about stopping and restarting the MSSQLSErVICE after the VPN has reconnected?

Can you hardcode your ip?

 

[gensan]

Yes, that's what we normally do. But it's still better if we do not have to restart the service.

What do you mean "hardcode" my IP. The IP add of the VPN is static.