Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sql server

Author  Topic 

dontulasrini
Starting Member

7 Posts

Posted - 2014-03-27 : 04:30:58
Is it possible to connect sql server with two different systems with internet Router forwarding just give me the steps if it posible
Thanks in advance


Regards
Srinivas

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-03-27 : 04:32:37
what 2 different systems are you referring to ?

You mean you have 2 SQL Server and you want to connect it together ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

dontulasrini
Starting Member

7 Posts

Posted - 2014-03-27 : 23:29:58
no only one database but i have to connect with internet
With out VPN
Go to Top of Page

dontulasrini
Starting Member

7 Posts

Posted - 2014-03-27 : 23:32:01
Thank u khtan
i want to connect one database just like lan
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-03-28 : 00:12:22
if you are referring to accessing your SQL Server from the internet, for security purposes, you should access it via VPN.

If you want to use port forwarding on the router, SQL Server uses default port of 1433. You will need to configure your router to do port forwarding to that port.


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

dontulasrini
Starting Member

7 Posts

Posted - 2014-03-28 : 00:29:20
i not using vpn
i changed port 1433
how to configure the router for port forwarding
i have two sql server instances and iam using sql server 2000, 20008 R2

Thanks And regards
Srinivas

quote:
Originally posted by khtan

if you are referring to accessing your SQL Server from the internet, for security purposes, you should access it via VPN.

If you want to use port forwarding on the router, SQL Server uses default port of 1433. You will need to configure your router to do port forwarding to that port.


KH
[spoiler]Time is always against us[/spoiler]



Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-03-28 : 03:30:52
quote:
how to configure the router for port forwarding

How to do it is specific to the make/brand of router. I can't really advice you on this. In general you need to configure port forwarding.

quote:
i have two sql server instances and iam using sql server 2000, 20008 R2

No a issue. Each SQL Server must and will be listening on the different port no.

If you are not familiar with configuring the router, i suggest you to refer to your network administrator or post in another site/forum since this is not really related to SQL Server but router configuration


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -