web site built on sql server

pts.
Tags:
SQL Server
hello we had a person develop our website using sql server. we want to transfer that to an in house server and host our own website. the webserver is in our dmz zone off of our firewall. the sql server is on the same machine. we can not connect to the sql server to update data from our internal network? what am i missing?????

Answer Wiki

Thanks. We'll let you know when a new response is added.

The SQL server ports are being blocked by your firewall or router. You need to make sure you block SQL server ports to the internet and open them back thru to the internal network. There should be 2 sets of routing rules on the firewall, 1 for outbound ports to the internet, another for inbound back to the internal network. Be careful not to open SQL server ports to the internet!

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Schuit
    I opened up all the ports to the dmz from the lan and still can not get connected.
    0 pointsBadges:
    report
  • BeerMaker
    Verify that the port traffic is coming thru if you can. My guess is that its still not getting thru. Check DHCP and WINS entries to make sure the machines can find each other. Use PING to test this. Make suer you are using TCP IP as the network protocol on the client side and not named pipes. What is the error? (cant find server is probably what youre getting). Are you using a SQL server login or NT authentication? If using NT, you need to make sure the trusts between the domains are setup correctly and that you allow the protocols used to do this. Its probably easier to test with a SQL server login for now. FYI look at microsoft KB article 832017 for info on the ports you need open. And only open what you need, dont start by opening everything. There are only a handful of ports to open. Good Luck
    0 pointsBadges:
    report
  • DavidLen
    what worked for me in iffy connections: Create an alias on the client machine using cliconfg Create an OBBC entry using the alias, and account/pw/security used in the program. 'test connection' on the ODBC entry. David L.
    0 pointsBadges:
    report
  • ArrghOff2Pillage
    I believe the user who cited the authentication may be on the correct track, however, opening those ports through to the DMZ would bother me. If you verify that is the problem, look at seting up an IPSEC tunnle between the SQL and the authenication server. Have done similar when placing our sharepoint front end in the DMZ and hosting the SQL on the inside.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following