1
I have two computers on my LAN. One with IIS and a public IP, the other with SQL Server and a LAN IP. How I can access to the SQL server through the IIS server from a computer connected to the internet?
How to connect to a SQL server through a public IIS server
Answers
2
If the goal is to do remote administration, then my first suggestion would be to setup a VPN. You would then connect via VPN to your local network and use Remote Desktop to connect to the SQL Server. If a VPN isn't in the cards, then RDP'ing directly to SQL would be the next solution although not as preferable as a VPN.
EDIT If the IIS machine has a single NIC with only a public IP, then there is no safe means of having it access a machine on a private network as they are on different networks. If however, the IIS machine is in a DMZ on the same LAN as the SQL Server, then a port in the firewall between the DMZ and the LAN must be opened. Typically, this is TCP port 1433.
Thomas
Posted 2010-03-18T23:11:26.340
Reputation: 291
i need to connect to sql server from internet to data acces. but it must be trough iis pc, not directly to sql server – None – 2010-03-18T23:24:20.080
0
If you're trying to view data, you're probably interested in Reporting Services, a feature built into SQL Server that leverages IIS. You can build custom reports that present data in a number of ways.
This video was the first easily-understood explanation I found of what Reporting Services is and what it can do.
If you really do need to query the database directly, then your best bet is to set up either a VPN or Terminal Services. You could even make SQL Server Management Studio available via RemoteApp.
Stephen Jennings
Posted 2010-03-18T23:11:26.340
Reputation: 21 788
0
How I can access to the SQL server through the IIS server from a computer connected to the internet?
I'm assuming you are trying to access the SQL Server through the IIS Service, not the IIS Service.
You can install Routing and Remote Access on the IIS Server and configure NAT. Then you can forward inbound connections on TCP 1433 (you are using MSSQL?) to the computer running SQL Server.
If you want to access SQL Server through the IIS Service... well... you are doing it wrong.
ta.speot.is
Posted 2010-03-18T23:11:26.340
Reputation: 13 727
1You should never have open access to a database from the internet, it's just too much of a security risk. What do you need it for? Remote administration? – None – 2010-03-18T23:15:18.347
I'm interested why you've specified IIS as a necessity. What is the larger goal you are trying to accomplish? Maybe there is an easier way than what you've asked for help with. – Stephen Jennings – 2010-03-19T04:34:12.260
Really this should be on serverfault. – ta.speot.is – 2010-03-19T06:38:20.977