This is probably a very basic question, but I'm not sure how to go about doing this. If I have a SQL server on our LAN and our Web server (running Microsoft Web Server OS) in my DMZ, and I want my Web server in the DMZ to be able to connect to the SQL server on the LAN, how do I go about doing that? Do I use an ODBC connection? I can't use SQL client tools because the Web Server OS will not allow me to install it. Any help would be great. Thanks in advance.
Ryan
Do you have it hooked up in your web.config file?
<connectionStrings>
<add name="LocalSqlServer" connectionString="Data Source=(local);Initial Catalog=DBNAME;Persist Security Info=True;User ID=XXX;Password=XXX;" providerName="System.Data.SqlClient"/
</connectionStrings>
Let me know.
|||Well, I can run the .asp script from the SQL server itself. So the web config should be good. Thanks for the quick reply.
|||The short answer is you can use anything you want, but you need to tell your firewall sitting between the DMZ and LAN to allow that type of traffic through the firewall.
A typical firewall rule would be to allow connections from your web server IP to your SQL Server IP over port X.
|||I will look at the firewall. What is the "preferred" method to access the DB?
No comments:
Post a Comment