How To Connect SQL Server with Internet

This Video is to show How to connect SQL Server through Internet:

Steps:

Find out IP Address for SQL Server machine

Make to Static IP Address

Find Port Address for SQL Server

For Default it's 1433

For Name Instances it varies so make it Static Port Number

Install and Enable SQL Server Browser

Open a Firewall Settings for SQL Server and SQL Server Browser

Enable the Port Forwarding on you Router with SQL server ports

---

Closed Caption:

welcome to sequence or online seminar
this video I'm going to show you how to
connect a sequel server to internet
before we have we can connect to
internet so we have to find out some
steps to fix an easy way to connect the
sequel server for the internet first
step we have to find out
IP address for the sequencer mission
what does it mean it means we have to
find out the IP address in a system
where we install the sequel server
see now I install my sequel server here
so now I'm i want to find out my IP
address
it's gone here and go to the combine
prompt and then I become free
here I can see the details of my IP
address on my current local system so
this is the IP address for 192 . 168 .
1.10 that means this is the IP address
for current machine and the default
gateway which means that my router which
is using that IP address and passing the
signal to all my missions throw the
router so one line to do fine 168 fine
1.1
so this is the router IP address
then after what I have to do how to make
it
IP address as a static what does it
means that means when I report my
machine are when i reboot my sprouter
the IPL just keep changing because based
on the load and everything
so what I have to do I want how to fix
my IP address for the sequencer mission
that means when i reached mean means
because when i restart my router are
ready to start my system the system
automatically use the same me I same IP
address which I'll given in the system
settings
so how can i do that here we have to go
control panel and the networking and the
status
here is the local area con connection
and then properties then I before and
you you have to do the particular IP
address for the machine
so which means when you mention the name
here what number here that means this is
the static IP address and this is the
gateway when I see the here when I see
when I get the results
ok when we get the results from the IP
confi we have too much the same results
in this setting
so here I . this means whatever the IP
address you can do here and the subnet
mask which means with the value which is
provided by you were an Internet service
provider
so based on that you have to give match
the values 255 here and then default
gateway that I i mentioned to you
already
which is it is coming from the crowd so
192.168 . 1.1
so this is the important thing dns
server addresses so before and alternate
dns server product numbers which is
provided by the internet service
provider
let's see for example for our comcast so
you can go and search by preferred dns
and alternate dns server for comcast
so they do some numbers then you have to
enter the number in this property
settings so once you click ok then
automatically DC the mission will be
used the same static IP address all the
time
so what what happened when we go out to
see the signal then router will
automatically send the same IP address
to this machine
ok then after that
ok after that what we have to do is we
have to find all four are just for the
sequel server see whether we see the
default port number for sequel series 1
for 3 t that is default but keep in mind
when you install the different kind of
neighborhood instances after the default
the default port number is for integrity
but name instance port number will be
changed
alternatively by dynamically what
happened when you restart the sequel
server services particular that instance
that instead of keep changing the port
number
so when I see here sequel server 2008r2
then configuration tools that sequel
server configuration manager
see here we have a different kind of
sequel server or services
I install my this is the default
instance and i installed up other two
named instances when is called deal and
called key when we come into here
the sequence of our network
configuration we have a you can see the
port numbers here for the default when I
see the default port number what
happened here is for integrity
keep in mind this is the port number for
all the sequins or whatever the number
you put here
that is the port number for sequel
server so the default one is 14
30 but at the same time when you want to
cut the sequence of for the internet
you should have to enable the protocol
tcp IP which is past which is connected
through the internet
so here i install another two instances
Corky and called them by default without
any changing the sequel server will be
used different dynamic port numbers for
example what does it mean if using the
6500 for here
so the sequels are when we restart the
same instance the sequence will change
the port number by dynamically holy
generated because this based on this
particular operating system the system
the sequence will be looking at the
operating system and particular all the
port numbers
ok this part number is using for this
source
this port numbers using for these tools
ok then what are the available port much
so getting in sequence are used
available part number
so in that scenario is really very tough
to a kind of the sequence road through
the internet because the port number one
supporter of a change it's very hard to
connect it then how can we fix it we
have to make it static port number so
that means once you enter the number
whatever the number here i enter the 65
geology of for that means there is used
this sequel server static port number
the sequencer or this instance always
use the same port number
so here are the same thing I use the
other part number for the deal is fight
- 108
so we fixed all the static IP address
and we fix the sequence of a static port
number for the different instances but
the sequence ever before these stances
automatically use one for TT
okay what are the next step then sequel
server browser the sequencer roser is
one of the important thing to connect to
the internet through the internet
ok so now i already installed the sequel
server browser when i install the sequel
server installation
and then I want to show you the services
see here i already instant the sequence
or browser for same for all the instance
and same mission
so once i enable the sequel server
browser should run automatically along
with the sequel server services
so these are the simple steps we can do
it by the GBA but now this actual
pictures coming right now
how can we are open the firewall
settings because the firewall is the key
important thing for your the internet
from the outside
when I want that any user coming from
the outside the firewall will be blood
if you
so we have to be enable the firewall
settings for the sequel server to all of
the particular users
ok let's go here I can search in the
firewall
so here I such the firewall so one of
the options we have to enable first
let's go to the other a program for the
windows firewalls
so here this is the key thing which is
blocking our allowing of your system
well outside users so the system we have
to set up to all of the outside users
now I already entered here the sequels
are how can I have to do it let's go on
here when you open this that
automatically that boxes will compare
so when you check the box sequel server
and in that even you all of the homework
home network and public network so the
sequence or that means that operating
system
open the pole for allowing this equals
our users from the outside of the
internet so this is the sequel server
default but keep in mind we only the
sequels are only available in this so we
have to add a sequence of your browser
how can we add let's go here
change settings
hello another program open the browser
and then let's go to the sea
let's go to the c drive program files
and then sequel server work
so once going here at the sequel server
so you can see you can automatically
search here sequel server sequel browser
so that means you see the sequel server
browser
so once you click it so that once you
add this one so when you click add it
so automatically it will be adhered so
once you add it here you have two unable
to allow the private and public network
so this is the sequel sorry
automatically did but you had to add a
sequel server browser service . exe file
so when you go there followed another
program and just added from this where
you install the sequel server
ok now let's click on the ok so then we
enable the firewall settings to allow
the sequencer users from the outside to
the internet so once i enable the
firewall settings then we have to add
sequel server browser and sequel server
for our port numbers
let's go on here again another firewall
settings
let's go your windows advanced firewall
settings you have it in bond rule so
click new inbound rule
select port and all the port numbers
I prefer all part numbers and so get
just all the connections don't mind
whatever all the provider don't mind do
the name
whatever it is sequel server something
like that so I already given here that's
why I'm not adding that i can show you
see here i added the sequel server so
when you see the protocol i already
added all enable quartz should be
connected from this computer
ok up to this point it's real good
because we install the sequel server and
we enable the firewall settings and
really we install a sequel server
browser and we change the static port
number as well as static IP address for
the mission now
first of all I want to check that ok now
everybody can connector instance to the
name but I want to check their ok my IP
address is connecting on or because so
what is the system IP address for this
this is the system IP address which we
given the static 192.168 . 1.0
ok now i'm going to do see what happened
this is the mission name and this is the
instance called here
now i want to change this to this IP
address
what their appeared is here 192 . okay i
have already here
ok 192 . 168 . 10
then call me back
see here we connected
ok the from the system from locally we
connected the sequel server through the
IP address
now we have to connect the same IP
address whatever through the internet
from the outside user how before we go
to that everybody should have to check
the public IP address for your provider
like every home or every office once you
connect the internet at least from the
provider
everybody has should have a public IP
address
so let's how can i find the public eye
traitors what is my IP . come to see the
website which is given for the public IP
address so public IP address means that
any outside user can connect and throw
the internet on any machine from this
system
so here this is the my public IP address
so now i have to connect the public idea
that so before we cut the public IP
address because any outside user cannot
directly to the system because ok i use
the public IP address but we have a
middle layer is router so we have to
enable the router settings because the
router is the middle layer from the
outside user and from the internet and
the mission
ok now any outside provider any other
providers are like linked sees our net
gave so any provider we have to enable
the port forwarding option so port
forwarding option on your router with
the sequel reports
what exactly means is let's see or
minuses links is service
so now how can i connect the link source
because that's what I told you
default gateway which is the router IP
address 192.168 . 1.1
so once I entered this the router will
allow me to change the cities because
that is that IP address
we can change so this is my IP address
so if you go in anywhere in the netgear
or any application that should be an
option called port forwarding port
forwarding means so for example outside
user the he is using the public idea
just like layers as you know let's think
like this is my IP address
so once the person is using this IP
address so that other what happened
ok it's a sequel server for example we
are connecting the ideas for this sequel
several soak a sequel server is using
the your public IP address so when the
sequels are attracting the IP address
automatically be given a port number
right
1433 1433 is a default port number so we
have to be extra port and to report the
same number and the I to IP address so
okay the pot use that connected my
public IP address on the sequel server
and what happened we given the name
ok this mission have instance what is
called instance the court here with this
idea is ok anybody can connect the
public IP address
/ cookie when the user given this name
the routers watch out there should act
okay we got another one instance that is
ok 1433 port number and directly the
router will come to the mission where we
installed the sequel server because when
the router was sent a lot of information
to the different kind of missions so
different kind of mission each mission
has a different local poor IP address so
we have to be fixed that but the IP
address and particular port number on
the sequel server not only sequencer Oh
any kind of you enable the ftp website
so if you enable any is configuration
whatever it is you have to enable the
port forwarding give the port number and
use the IP address so we have to give in
we given the IP address for the default
at the same time i mentioned to you the
sequence of our neighbor instances
so we have a different kind of name
instances so we given the different kind
of port numbers
so now at the same time I'm allowing
their posts here different kind of port
numbers for the different instances to
connect the same machine and we given
them sequel server browser
keep in mind sequel server browser as a
default port number 1 for 3 4
so even you should have to follow the
same port number 144
ok now enable and I see the settings so
once you see the settings you have to
reboot the router settings
ok now now when it connected desi here
I got ever log in failure because
windows authentication is not used for
the internet because i'm using the
public IP address so windows
authentication will not order to use so
always whenever the user come from the
outside
he has to use a sequel server
authentication
ok now I let's connected just with the
local first because i want to show you
the the user
I already created here ok so here I
already created the users
now let's I'm going to connect the same
mission to the public IP address with
the diff with the users sequels are
users of collects use
see now i connect the sequel's road
through the public IP address
if you have any domain name this is
point out to the public IP address so
you can connect it here
so before we go just rip it again very
quick steps first we have to find out
the IP address for the sequel server
machine make it as a fixed IP address
and then after that
find out the port number for the sequel
server the default everybody knows but
it varies on a different kind of sequel
server instances then you have to enable
the sequel's or firewall settings and
along with that you have to install the
sequence of our browser
so once you've done that you have to be
verified with your public IP address and
you have to change the you or you have
to change your port forwarding option on
the router so then after that you can
kind of do the your public ideas
thank you for watching this video please
subscribe more videos on sequel server
online training channel on a YouTube or
follow my black sequel server online dot
blog spot.com