asked on

SQL Server Management Studio Express 2005; whitelisted IP address keeps changing

My hosting provider whitelists my IP address so I can connect to the SQL server. However, my IP address keeps changing all the time via my provider---Qwest----sometimes 2 or 3 times a day.

How can I get my IP address to remain static so I can maintain a consistent connection with my Management Studio on a day to day basis? Is there some other way to connect? Can I use my network's control panel settings to define a static unchanging IP that will override the dynamic changing IP situation I am currently having?

Thanks.....

ASKER CERTIFIED SOLUTION

dbidba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

HainKurt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jazjef

ASKER

HainKurt:
This looks really good..... I can customize the internal name of my router via my router control panel right? I'm using a 2Wire DSL modem....

jazjef

ASKER

HainKurt:

My provider can't whitelist a name for their firewall.... so DynDNS is out.

jazjef

ASKER

dbidba:
This source is written by Microsoft----it appears to have been written by the same team that designed the Vista OS. Can you translate this a bit more. I understandt some of it, but it appears that there is a registry hack involved for SQL Server 2005 Express.

jazjef

ASKER

Thanks folks. Both are good/relevant solutions, but I ended up having my provider add a 'range' of IP addresses and that has solved the issue. After some research, I can verify that both will work.