connecting sql server over the internet
-
Hi all,
i'm new to sql server 2008 and i would like help with connecting two pc's over the internet
i've installed sql server 2008 (express) and sql server management studio on two pcs i have..
i have one connected to the internet via my home connection and the other via wifi hotspot from my htc
what do i need to do on each pc to get access from one pc to another?
thank for reading
peter - confused.com;-)
-
peterjb44 (10/26/2012)
Hi all,i'm new to sql server 2008 and i would like help with connecting two pc's over the internet
i've installed sql server 2008 (express) and sql server management studio on two pcs i have..
i have one connected to the internet via my home connection and the other via wifi hotspot from my htc
what do i need to do on each pc to get access from one pc to another?
thank for reading
peter - confused.com;-)
I can't really understand what you want to do. Could you please elaborate your question?
-
Hi Ignacio A. Salom Rangel,
what i'm wanting to do is to have a remote pc connecting to my database on another pc via the internet.
i believe i need to setup this using sql server configuration manager, but i'm not sure what i need to do on each pc to make it work
best regards
peter
-
You are going to need to ensure that you know what ports SQL is listening on and ensure that the firewalls of your end pc, DSL/cable router and any ISPs involved are not blocking those ports. You will also need to know the IP address your DSL/Cable modem is pulling, as that is the IP you will have to specify from your management pc. In your DSL/Cable router you will need to ensure that port forwarding is setup so that any traffic for the SQL ports is forwarded to the pc hosting SQL.
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply