how to connect sql server from internet
-
i have 3com router and i have Puplic IP address Nat is Enabled and i configer it like 81.10.29.106:Defule sqlserver port how to configer sql clint to creat connection Between sql server and sql clint and thnx:confused:
Ahmed El-Badry
-
i have 3com router and i have Puplic IP address Nat is Enabled and i configer it like 81.10.29.106:Defule sqlserver port how to configer sql clint to creat connection Between sql server and sql clint and thnx:confused:
Ahmed El-Badry
The Server (or Data Source) component of the connection string should contain the IP address and instance name if applicable and Port number e.g. 81.10.29.106/MyInstance:1433 If you are running the default instance then just the IP and Port. NOTE: You must also configure SQL Server to accept TCP/IP connection. And you must ensure that all firewalls between the client and server will allow the traffic through. As exposing a SQL Server directly to the internet is a dangerous thing to do it is not normal practice. Some ISPs may automatically block the ports SQL Server uses.
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
-
i have 3com router and i have Puplic IP address Nat is Enabled and i configer it like 81.10.29.106:Defule sqlserver port how to configer sql clint to creat connection Between sql server and sql clint and thnx:confused:
Ahmed El-Badry
Enter the IP Address where u Write the Server name. and give the some information .