sqlserver 2005 connection problem
-
I have a sqlserver 2005 on a private LAN...the server has a private IP...the network is connected to the internet throw a (TMG) firewall which has a real IP.....I have a computer outside my LAN and has a real IP...this computer has a C# program and need to connect to the SQLserver to read data from it...how can i make this computer to connect to the SQLserver since it has a real IP but the SQLserver has a private IP on another network?
-
I have a sqlserver 2005 on a private LAN...the server has a private IP...the network is connected to the internet throw a (TMG) firewall which has a real IP.....I have a computer outside my LAN and has a real IP...this computer has a C# program and need to connect to the SQLserver to read data from it...how can i make this computer to connect to the SQLserver since it has a real IP but the SQLserver has a private IP on another network?
- Enable the TCP/IP protocol (see configuration).
- Open port 1433 on your firewall.
- Setup port forwarding on your router.
..and start praying; a SQL Server directly connected to the internet is a bad idea. Expect quite some people poking the server to check its security. The "best" way to expose your database would be by using webservices :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]