Access sql server database that is behind a firewal

Hello Experts
I have an intranet site that is hosted locally using IIS7.5 on a windows 7 machine. This machine also has a Microsoft SQL server express. Four or five computers on the local network access the data in SQL Server Express.
 We are currently in the process of building a word press site that will be hosted on the internet. We need the ability to Access/update some of the data on the word press site with the local data on in SQL Server Express. We do not want to place the SQL database on the web for security reasons.
What are your suggestions for having the word press site communicate with the local SQL Server data?

Drawing1.jpg
wilbur88Asked:
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.

x-menIT super heroCommented:
configure portforward on the firewall to the IP:port of the SQL Server.
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
Gustav BrockCIOCommented:
The default port is, as you know, 1433.

The easy solution is to create a port forwarding in the router behind the firewall form some arbitrary high port number, say 11433, to this port on the server running the SQL Server.

This has worked for us and our clients for years with zero issues. As a side bonus, it doesn't change anything for the local access to the SQL Server.

/gustav
0
Enclave TechnologiesCommented:
Agree with the comments above, however, as you are running SQL Express it's likely that you are using a Named Instance. In which case you will need to ensure that you either configure your instance to use a static port and configure port forwarding for that port OR configure port forwarding for UDP port 1434 (The port for the SQL Server Browser).
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

MlandaTCommented:
Agree with comments above, in addition, since the IP address of the WordPress site server is known (and perhaps fixed?), also limit the firewall rule to allow access to the SQL Server IP:port ONLY from the WordPress site server. That will prevent connections coming in from anywhere on the internet and just allow traffic from your website.
1
wilbur88Author Commented:
Thanks for the ideas experts-
0
Gustav BrockCIOCommented:
You are welcome!

/gustav
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 2008

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.