How to connect to sql server with dynamic IP Address

All we need is an easy explanation of the problem, so here it is.

I have installed sql server express edition 2014 on my machine. And I am connecting to it with CRM using my local machine’s IP address.

The problem here is my IP address allocated to my machine is dynamic and changes every day when I log in, which makes it impossible for me to connect to CRM (as the IP address changes obviously).

What to do in that case? Any help will be appreciated.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Instead of connecting via IP address, connect to your machine’s name. If you’re connecting locally, you can use LOCALHOST as the name, or just a period (“.”), which connects you to your local default instance.

Method 2

Brent’s suggestions of using your machine name, or LOCALHOST or just “.” are all great ones, I would also suggest using the loop back address of 127.0.0.1

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply