Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a LAN which I connect two PCs through an ADSL Router.

I want to disable the internet on the PC carrying the SQL Server, and of course want to still be able to connect to SQL Server from the other PC.

My Configuration:

  1. To block the internet from the server, I set its gateway to nothing.
  2. To enable access, I added the ports (TCP 1433, UDP 1434) to the firewall exceptions list on the server.
  3. I am connecting to the server from my client using SSMS's normal connect.

There are some blogs on the internet which say I have to 4. forward the same two ports to my server IP on my router settings, Is this last step necessary? because after applying the above 3 steps, I already can connect from my client.

Or the port forwarding step is meant only for VPN configuration (which I don't need I guess)?

share|improve this question
    
Without knowing which router you have, thus not having someone be able to step you through the screens, this is as simple as NOT giving your SQL server box a NATed address on the router. That being said, how do you ever propose to update this box? –  GregD Oct 6 '11 at 14:08
    
@GregD Did you hear me asking for screens or snapshots? my question is specific to the 4th step. –  Kenan F. Deen Oct 6 '11 at 14:30

1 Answer 1

No, you don't need to set up port forwarding on the router to connect to the SQL Server from the same LAN. You would only set up port forwarding on the router if you wanted to connect to SQL Server from the internet.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.