• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

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.....
0
jazjef
Asked:
jazjef
  • 4
2 Solutions
 
dbidbaCommented:
Yes. Setting a static port is easily done.

http://support.microsoft.com/kb/823938
0
 
HainKurtSr. System AnalystCommented:
use dynamic dns, for example I am using dyndns.org
set your router so you will always have a name like HainKurt.dyndns.org, and they can add this to their list (I hope they accept name instead of ip) so, in case of your ip changes, your dns name does not change and you should be ok...
0
 
jazjefAuthor Commented:
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....
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
jazjefAuthor Commented:
HainKurt:

My provider can't whitelist a name for their firewall.... so DynDNS is out.
0
 
jazjefAuthor Commented:
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.
0
 
jazjefAuthor Commented:
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.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now