LAN PC cannot go on Internet

Hi Experts,

I have a Win 7 PC that hosts SQL Server.  As it hosts SQL, I have assigned this PC the static IP of 192.168.10.202

The static IP was actually reserved on the router, which worked fine. However, another person replaced the router with the Cisco Meraki MX60 router, and I believe that he set the range of 192.168.10.1 to 192.168.10.199.  Where I was asked to set the static IP on the PC side through the IPv4 settings.

The problematic PC is seen within the LAN, and clients can get to the SQL server, but it cannot go on the internet.  Can this be because the range goes up to .199 and the PC is at .202? More importantly, how would I go about fixing this?

If I need to fix this through the router, where should I look?

Thank you
APD TorontoSoftware DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

nader alkahtaniConsultantCommented:
You should assign static IP in that range to your pc,  then tell him to exclude  your IP from dynamic pool from dhcp server

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
nader alkahtaniConsultantCommented:
Ping default gateway then if you success
Set default gateway in your machine and another IP settings parameters
Set proxy settings in Internet Explorer program
APD TorontoSoftware DeveloperAuthor Commented:
Should I change the IP Range on the router?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Are other computers in the same subnet able to reach the Internet?
The problem is probably not the individual IP address on the machine using 202 (unless you have an IP address conflict).

As Nader indicates, confirm that you can ping the router's internal address (by convention, it would be set to 192.168.10.1... but from your description, it is possible that address has been set aside for a dhcp scope.  (And, in that case, if workstation with dynamically assigned IP addresses are working... then check the default gateway received on one of those machines and confirm that it is the same default gateway configured on the 192.168.10.202 machine.)

Unless you have a proxy server in your environment, do not configure proxy setting in IE.
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
> Should I change the IP Range on the router?

I assume you are asking about a DHCP Scope?
On that assumption, the answer is : Depends.
  Assuming you want to continue to use the address as statically assigned. Then no.
  If you want to dynamically assign the 202 address, but enter a reservation for that address, based on the MAC address... then yes.
APD TorontoSoftware DeveloperAuthor Commented:
In subnet 192.168.10.0/24      

What does /24 mean
APD TorontoSoftware DeveloperAuthor Commented:
Yes, I can ping my router
nader alkahtaniConsultantCommented:
What is default gateway on the pc?    
Issue the following commands then post them here
Ipconfig /all
Pathping Google.com
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
> In subnet 192.168.10.0/24      
> What does /24 mean

It means 24 bits, so in this case, it means the subnet includes the addresses 192.168.10.[0-255].  (The subnet mask would be 255.255.255.0.)

Each of the four numbers in the dotted decimal notation use eight bits, and eight bits can represent an integer number up to 255.  A subnet using /24 uses the first three octets to represent the network portion of the address, and eight bits to represent host addresses.
nader alkahtaniConsultantCommented:
Thank you,  I  am glad for helping you
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
Windows 7

From novice to tech pro — start learning today.