we have a static ip that comes to our switch and all servers are able to connect to internet.
one of the servers is for sqlserver 2008 .
i published our website to internet but i must use our local sqlserver because other local applications are connecting to it.
but 2 problems:
1. i don't know how to specify the ip to connection string (using EF4 SQL first)
2. the solution contains many projects and 1 project is for data access and EF4 but i published the asp.net project. is it a problem? if yes how can i have data access project (it's a class library) in internet?