Do I need to set a static IP for my Sql Server if my router already is assigned one?

Hi

I am trying to setup SQL Server for the first time and I'm not sure if I'm doing it correctly.
Our ISP has assigned us a static IP and I have assigned it to the router. I then have the SQL Server connected to the router having a dynamic IP.

I would like for people to be able to access the SQL Server from home but I'm not sure if the Server is suppose to have a static IP as well or dynamic? Do I need to request another static IP from my ISP?

Thank You.
techin4Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AegilCommented:
I assume that your SQL server is on a local IP. I would personally set it on a static ip on your local network and then have the SQL ports forwarded from your router to your sql server so that you can connect to the sql server from home.


So set SQL server to static 192.168.x.x or whatever your range is

set your router to forward 74.x.x.x:1433 --> 192.168.x.x :1433

and then you should be able to connect remotely to your sql server as long as its listening on that ip. you can test it internally by connecting to the 192.168.x address. Then test from outside. But due to the firewall you would need to test from externally.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
techin4Author Commented:
Thanks for your reply.

If I assign the SQL Server a local static IP do I need to turn off DHCP on my router?
0
AegilCommented:
No, you dont need to turn the dhcp  off. Just set the ip address higher in the range. e.g if your range is 192.168.1.1-254 just set it to 192.168.1.250 or something high, usually the routers assign ips in order so that will make sure its not assigned out by dhcp.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

techin4Author Commented:
I see...I'm starting to understand now.
One last question.

If I dont assign the SQL Server a static IP but have the DHCP Server (Router)assign it a dynamic one will I still be able to access it from home? (I'm going to use static but I'm just curious)
0
AegilCommented:
Yep, you could use a dynamic ip. its just its better if you use the static so you dont get home and someone has rebooted the router and the server  has got a different ip or had an ip conflict or something.  Its just better practice I think. However you could do it both ways.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
servers normally all should have a static ip, as firewall rules work basically based on IP addresses and not on host names.
0
techin4Author Commented:
Thanks much for your guys help. I now have a better understanding of how things should work.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

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.