Hosted server with multiple network connections issue
Hi, I have recently started using the NSMS and find it very useful. I have just tried to install it onto our qa servers, Win 2k8, and have run into a problem. I have 2 seperate network connections, one for public use, one a private connection for the hosting provider to manage backups and whatnot.
When installing the server I am not able to choose which connection to choose and it seems to always choose the hosting companies private connection. I was able to get around this by uninstalling the software and then disabling the hosted connection and then installing the server. Worked great. As soon as I enable the connection and reset the NSMS the server once again attempts to use the hosted connection and will not start the NSMS.
Is there any way to configure the server to use a specific connection? Thanks,