Allow remote connections to SQL Server Express : How to Video

Enable remote connection on SQL Server 2014 express. By default, when SQL Server Express is installed it generates a random port to listen on. In this video you will learn how to configure SQL Server 2014 Express to accept remote connections over TCP/IP using SQL Server Configuration Manager and how to open the port on firewall for incoming connection.

---

Closed Caption:

hello in this video tutorial you are
going to learn how to connect sequel
server access remotely
in this video tutorial we are going to
do two things first we are going to
enable sequel server to accept the
remote connection
secondly we are going to act sequel
server connection port in firewall so
without wasting any more time let us see
how we are going to do this now we are
on the windows server 2012 machine first
thing to do is to check the IP address
of this server press windows + R to open
run dialog box in the run dialog box
type CMD
this will open the command prompt window
in the command prompt window type
ipconfig and then press Enter
this is sure the IP address of your
server as you can see over here on the
run dialog box type CMD 10 type IP
conflict which is displaying the IP
address of the server the IP address of
the server is 192 . 168 . one .
26 now press the Windows but an end go
to start menu from the start menu click
on sequel server configuration manager
once the sequel server configuration
manager is open click on the sequel
server services to check how many
instances of sequel server you have
installed as you can see over here we
have installed one instance of sequel
server that is sequel server express
edition
now click on the arrow sign to expand
the sequel server network configuration
then they are going to click on protocol
for sequel express if you don't know i
should tell you the sequel express is an
instance name of our sequel server which
we have installed now click on protocol
for sequel express then from the light
side window you will see three options
select the last option that is tcp/ip
right click and then click on enable
this will show you our morning
any changes will be saved however they
will not take effect until the service
is stopped and started click ok now go
to sequel server services and from the
right side window select the sequencer
instance which you want to restart then
right click on the instance and click on
restart as you can see right now it is
stopping the sequel server and
restarting it once the sequel server is
a stud go back to sequel server network
configuration protocol for sequel
express and then double-click on tcp/ip
here you can see there are two types are
available protocol and IP addresses so
from the IP addresses tab go to the last
options available let's move down
okay here in the IP all section you will
see two options
tcp dynamic ports and the port number is
49 159 the dynamic ports can change
automatically so we are going to use a
static port for static but we are going
to select the second option that is TCP
ports so on the tcp port option we are
going to type the port number which is
for 9 170 after this go back to tcp
dynamic ports and the move the port
number
ok then click on apply click on OK
once again click on ok now go to sequel
server services and restart the sequel
server instance for which you have
configured the port number
ok
now let us minimise the sequel server
configuration manager next thing what we
have to do is we have to configure
Windows Firewall in Windows Firewall we
are going to open the port which we have
configured in secret server
configuration manager for incoming
connection so open the folder and click
on computer from the computer click on
View computer and then go to open
control panel from the right side click
on category small icons
then select windows firewall on the
Windows Firewall from the left side
click on advanced settings from the
advanced settings click on inbound rules
here from the right side action pane
window click on new rule from the new
environmental visit click on the second
radio button and then click on next
here we have selected specific local
ports we are going to enter the port
number which we have configured in
sequel server configuration manager
which is for 9 170
let's copy this part click on next
then once again let's click on next
click on next
just give the name the same port number
is 49 170
i am also going to type SQL so that it
will be easier to recognize then click
on finish over here you can see the port
which we have added now let's close the
firewall
ok so this was our main server on which
the sequel server database engine is
installed this server name is server
- now let's go to our another server
from which we are going to connect this
sequel server database engine
so just hold on for a second let me move
to another server
oh ok now this is summer run now first
thing to do is to check the connectivity
between both of the machine
so go to run and type CMD then click on
OK or hit enter on the command prompt
window
typing and the IP address of the remote
computer
as you can see we are able to ping that
means
the communication between the two
systems is establish now let's close the
command prompt window then press windows
button and go to start from the start
menu select sequel server management
studio in our scenario we are using
secret summer 2014 on the sequencer of
management studio i'm going to type the
IP address of the remote computer then ,
and attend the port number of the remote
sequel server which we have configured
which will look like this
we have selected the sequel
authentication the log in this essay and
the password is very similar but i'm not
going to tell you
so let me type in the password and then
click on connect so as you can see via
successfully able to connect to the
remote sequel server using another
system now we can virtually do anything
whatever we like from this system as we
are physically sitting on that remote
computer so it completes our this video
tutorial don't forget to watch our next
video tutorial which will be very
informative for you
hello friends
thank you for watching our this video
tutorial if you like this video give it
a thumbs up subscribe to receive an
email updates whenever we post a new
video share it with your technical I
depends if you're having any technical
problem on have any suggestions post
your comment here or catch me on google+
facebook pewter and skype
this video tutorial is presented by
sergeant I'm about my ID COC . com
and you're watching this video on
youtube channel video guys
yeah
yeah