Eventually i find solution to this problem:
that's first we need to configure client location Router settings. then open sql server tcp port( 1433 ) or Udp port (1434 ) in that location.
First thing:
client location Router settings:
Start->run->type cmd then press Enter
then dos prompt will open.
1) Now you can see dos prompt then type ipconfig - press Enter
Now your system ip,subnet and gateway information will display on your command prompt.
take your gate way ip ( for example : 192.168.1.1)
2) goto your system browser
type your gateway ip in browser address bar
Now your system will ask router username and password.
then enter your correct user name and password. then ur router home page will open in your browser.
Now you can see exactly 6 or 7 links, in that link click management link then sub links will list out lik LAN,WAN,NAT and so on.
now click NAT link then give your System ip and Sql server port then click save& apply...
this information for Bsnl router only
then check in command prompt with below command:
telnet client <> public ip <> 1433
if this command give blank black screen its connected with remote system if not otherwise
My connection string format:
<connectionStrings>
<add name="dbconnection" connectionString="Data Source=tcp: remote location ip (public ip address),1433;Initial Catalog=Education;uid=sa;pwd=123" providerName="System.Data.SqlClient"/>
</connectionStrings>
that's it!!!
regards
sarva