• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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