Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I've just configured SQL Server 2008 R2 Express on Server 2008 R2, with the idea to administrate it remotely via the Routing and Remote Access VPN.

Everything is fine via the VPN and the connection works, however, the service fails to start following a restart of the system because its listening to an IP address that isn't in existence until the VPN is connected, which isn't ideal.

Is there any way to prime the IP prior to the first VPN connection, or any other way around?

share|improve this question

1 Answer 1

You would need to statically assign an IP address on the server that is in the same subnet as what your VPN connection is on. But that's not what I'd recommend.

The networking should really be fixed so that the subnet you're using for VPN can talk to an internal subnet the SQL box already knows about. Then change SQL to listen bind to an address in that internal subnet.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.