Allow remote connections to SQL Server Express : How to Video

Sdílet
Vložit
  • čas přidán 19. 08. 2024
  • 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.
    For any support contact:
    Skype: Sachin.Samy
    WhatsApp: +91-8527117770
    Email: sachin@itcoh.com
  • Věda a technologie

Komentáře • 417

  • @interforp.a.6883
    @interforp.a.6883 Před 6 lety +4

    Wow. Super useful. No unnecessary extraneous information. Delivered concisely yet completely. I wish all CZcamsrs made their videos like this.

  • @Blu3ligh7
    @Blu3ligh7 Před 4 lety

    I had been trying an external connection for 3 days, I saw any number of videos, and none gave me a solution, and your video gave me the solution. Thanks a lot.

  • @Jakab95
    @Jakab95 Před 5 měsíci +1

    My man, you are the one that presented it correctly. Thank you very much.

    • @SachinSamy
      @SachinSamy  Před 5 měsíci

      You are welcome thanks for watching the video

  • @Piskomilka
    @Piskomilka Před 8 lety

    Huge thanks!! Whole day I tried connect on my server from public, and only you said me why I couldn't... public IP WITH port... Love you!!

  • @MsReisebuero
    @MsReisebuero Před 4 lety

    You have the answers to some SQL-questions and you always give me the impression, that everything is just a small item. And in the end my SQL-problems are solved! This is simply brilliant done, thank you!

  • @PrakashPraaku
    @PrakashPraaku Před 10 měsíci +1

    It works for me in 2023 , thank a lot bro 🙏🙏

  • @hakimeltawerghi9632
    @hakimeltawerghi9632 Před 3 lety +1

    10 out of 10 for this video. Works for SQL Server 2019 too. Thank you. Exactly what I wanted!
    i am tired from another pebole for this article , so thaaaaaaaaaaaaaaaaaaaaaaaak u man

  • @adrien3330
    @adrien3330 Před rokem +1

    Thank You very much, you really help me to set up my first SQL server, wish you well for your future videos!

  • @birbal5
    @birbal5 Před 4 lety +3

    Don't forget, it is CRITICAL the the SQL Browser Service is running, or no matter how you configure it, you won't be able to connect remotely! Also, the default port usually used for SQL is 1433, or 1434 for named instances. Hope this helps!

  • @rofhiwanetshiya396
    @rofhiwanetshiya396 Před 6 lety

    yeh after a number of days trying to find a way ...........this tutorial helped me......it works

  • @ipassti5076
    @ipassti5076 Před 6 lety

    I was for three days searching for a solution, and i found here. Thanks...

  • @Epicjoy5036
    @Epicjoy5036 Před 2 lety

    Very relevant after several years, you saved me.

  • @emonhossain4353
    @emonhossain4353 Před rokem

    Thank You so much... I tried last 4 hrs and finally successful

  • @fabiolsmineiro
    @fabiolsmineiro Před 5 lety

    Hi, i am programming an interface in Java using NETBEANS IDE, TOMCAT WEB SERVER AND MSSQLSERVER and it worked perfectly, thank you! Actually, this is the second video tutorial that i use and the other one is great as well.

  • @almsys
    @almsys Před 7 lety

    Awesome. I had tried using UDP 1434 method and it would not work. Your way worked perfectly. THANK YOU.

    • @SachinSamy
      @SachinSamy  Před 7 lety

      You are most welcome and thank you for watching the video don't forget to like share and subscribe also if you like you can make a donation to support us www.itzoz.com/p/donation.html

  • @ashishbhad1002
    @ashishbhad1002 Před 4 lety +1

    I spent almost day on it and finally end of the I got this video, which made my day

  • @ajaysinghrajpoot1880
    @ajaysinghrajpoot1880 Před 7 lety

    Thanks sir,you are help me .i am troble 3 days, now one help me but youer vedio are healping me,ones again thank you so much...

    • @SachinSamy
      @SachinSamy  Před 7 lety

      You are most welcome and thank you for watching the video don't forget to share like and subscribe

  • @anaghawaje9216
    @anaghawaje9216 Před 6 měsíci +1

    Hi Sachin,
    This video solved my issue. Thank you very much for such a great solution :)

  • @anitascullion1724
    @anitascullion1724 Před 4 lety +1

    10 out of 10 for this video. Works for SQL Server 2019 too. Thank you. Exactly what I wanted!

  • @dominikriedel7390
    @dominikriedel7390 Před 5 lety +4

    I LOVE YOU! ♥ Your vid brought me on the right path with my SQL-related problem. ♥

  • @ashwinnair2011
    @ashwinnair2011 Před 5 lety

    Nice! That bit about the dynamic port is what kept giving me trouble.

  • @patrickreher2649
    @patrickreher2649 Před 7 lety

    Thank you so much, I tried loads of other troubleshooting and after hours of getting the same error message this video finally helped me.

    • @SachinSamy
      @SachinSamy  Před 7 lety

      You are welcome and thank you for watching the video dont forget to subscribe to our CZcams channel

  • @anubhajoshi1407
    @anubhajoshi1407 Před 3 lety +1

    Oh Gosh!! You saved me! Thank you so much for this video. This really helped

  • @link_solutions
    @link_solutions Před 4 lety

    This will very helpful to my project... And finally its done.
    Thank You So much.

  • @peterhoge4734
    @peterhoge4734 Před 6 lety +1

    Thank you so much. I have been working on this for a while...

  • @sivakumar174
    @sivakumar174 Před 3 lety +1

    Thanks a bunch. I really appreciate for your wonderful tutorial.

  • @nikeboyprox6328
    @nikeboyprox6328 Před 5 lety

    This is very useful. You have explained the steps very clearly.. Good Job!!

  • @DungNguyen-qy3yz
    @DungNguyen-qy3yz Před 3 lety

    Thank you, years later still saving lives. haha

  • @rodrigossoaress
    @rodrigossoaress Před 6 lety

    well done, worked perfectly with Windows 10 em SQLExpress 2017

  • @ideletefile397
    @ideletefile397 Před 2 lety

    followed every step and it worked! Fantastic video!

  • @jameswarui3412
    @jameswarui3412 Před 4 lety +2

    Dude you've saved my day. Thank you so so much for this.

  • @jeanfrancoislebrize2833
    @jeanfrancoislebrize2833 Před 5 lety +1

    Thanks! You made my day. Southern France.

  • @skeeterburke
    @skeeterburke Před 6 lety

    you are amazing. I think I will set up a connection with my mom's computer, a few miles away

  • @toumalmojumder9487
    @toumalmojumder9487 Před 8 lety

    though, it looks very hard! but it 100% worked! thank u.... thank u so much ....! u save my life! i pray to my god , may he save u.....

    • @SachinSamy
      @SachinSamy  Před 8 lety

      +তমাল মজুমদার you're welcome

  • @zilkyid
    @zilkyid Před 2 lety

    Thank you very much, its working, the key in minute 6:29. Must use comma (,).

  • @danmarlcadiz8185
    @danmarlcadiz8185 Před 3 lety +1

    bro, you deserve more than a like and a subscribe

  • @rollenlopez1154
    @rollenlopez1154 Před 7 lety +2

    great job man!! very clear and easy to follow

  • @simplysunny8859
    @simplysunny8859 Před 7 lety

    This was excellent Bro, saw this just once and got an clear idea for DR replication.
    Simple and powerful

  • @an00pSharma
    @an00pSharma Před 7 lety

    You are awesome man.............. I was struggling with it from past 2 days..........thanks a lot Sachin........

  • @ferfelfer
    @ferfelfer Před 5 lety

    Sachim .... thanks a lot. You are a genius.

  • @1jeffr
    @1jeffr Před 7 lety +1

    Thank you for the help. Greatly appreciated.

  • @vishwasv2601
    @vishwasv2601 Před 4 lety

    It was very useful and also detailed ..... Thank you

  • @harrissubtain3351
    @harrissubtain3351 Před 6 lety

    God bless you man! you just saved me this semester!

  • @thegirlfrommoon
    @thegirlfrommoon Před 5 lety

    thanks...finally I am able to make a connection to the SQL server...

  • @MagicCodesFarsi
    @MagicCodesFarsi Před 2 lety

    thank you very much for this helpful video.

  • @BonJunCuevas
    @BonJunCuevas Před 6 lety

    This helps me a lot. Thanks for sharing this video @Sachin

  • @amitsengupta8136
    @amitsengupta8136 Před 14 dny +1

    simply super!!!!

  • @wilibrodussmitshambur1030

    Very helpful. Thanks you Sachin.

  • @khurrammeer4247
    @khurrammeer4247 Před 4 lety

    this video was really help full keep up the good work

  • @PrakashPraaku
    @PrakashPraaku Před 10 měsíci +1

    Thank you so much bro!

  • @dw-2121
    @dw-2121 Před 2 lety

    thankyou bro my savior

  • @abdouskittou8561
    @abdouskittou8561 Před rokem

    Thank you my friend. That was very interesting.

  • @campercat5342
    @campercat5342 Před 4 lety

    I wrote : instead of , you saved me hours ! thank you

  • @umairgujjar6605
    @umairgujjar6605 Před 7 lety

    I really appreciate you, you solve my problem I'm very thankful

  • @LucioFrisullo
    @LucioFrisullo Před 4 lety

    Grazie Sachim, mi è stato molto utile! Many Thank's

  • @frqwolf
    @frqwolf Před 3 lety

    This was very helpful , thank you very much

  • @mirzadaniyyaloffical3916

    wow very informative tahnks

  • @ravichris1
    @ravichris1 Před 6 lety

    thank you so much brother..your video really really helped me lot...

  • @ahmetim
    @ahmetim Před 4 lety +1

    What a great video! Thank you sir :)

  • @kcdrummaster
    @kcdrummaster Před 5 lety

    Excellent, thanks for the clear instructions.

  • @79manindar
    @79manindar Před 7 lety

    thank you so much.. you are a life saver..

  • @vinodkumark2259
    @vinodkumark2259 Před 3 lety

    Great and simple explanation

  • @sumalsebastian
    @sumalsebastian Před 2 lety

    Thanks a lot. really helped me.

  • @davidf.7
    @davidf.7 Před 5 lety

    Thanks! from Mexico. Namaste :)

  • @patricecharbonneau6654

    thanks you so much. work as well on SQL Server 2019 but I didn't had to change the port because I use the computer name as connection in SSMS

  • @9966989500
    @9966989500 Před 5 lety

    I did it , Thanks man , Its great help .. just loved it ..

  • @siraja6788
    @siraja6788 Před 6 lety

    Man , Your videos are gold. Keep it up

  • @nilaanikanagaraj5784
    @nilaanikanagaraj5784 Před 3 lety

    Thank you tons!! You saved my time.. Tq again..

  • @manjeetnandal1
    @manjeetnandal1 Před 5 lety

    Great explained.
    Many thanks!

  • @PetDevotion
    @PetDevotion Před 5 lety

    Simply Brilliant ! Thanks for Helping

  • @horacio7920
    @horacio7920 Před 3 lety

    THANK YOU MY LITTLE FRIEND

  • @SenselessTalk
    @SenselessTalk Před rokem +1

    Thank you!

  • @srinivasanjayamohan8177

    Very clear explanation tq..

  • @QueenSeaReal
    @QueenSeaReal Před 8 lety

    Thank you so much... It saved my life when I found this :)

    • @SachinSamy
      @SachinSamy  Před 8 lety

      +TheQueensheryl Your welcome support my CZcams channel by making a donation using paypal.
      www.itzoz.com/p/donation.html

  • @MdARShuvo
    @MdARShuvo Před 6 lety

    Thanks a lot....This Video is so much so helpful for me.....i enjoyed it ......

  • @personalitedesign7344
    @personalitedesign7344 Před 6 lety

    Thanks!!!!!! You just save my day.

    • @SachinSamy
      @SachinSamy  Před 6 lety

      Thanks for watching the video don't forget to like share and subscribe

  • @PraveenKumar-to3mu
    @PraveenKumar-to3mu Před 8 lety

    Nice Video.. it worked for me.

    • @SachinSamy
      @SachinSamy  Před 8 lety

      +Praveen Kumar thanks for watching

  • @johnkyle3859
    @johnkyle3859 Před 10 měsíci +1

    very helpful

  • @vishavarora1316
    @vishavarora1316 Před 4 lety

    Was very helpful!!! Thank you very much.

  • @gerardohernandez8433
    @gerardohernandez8433 Před 4 lety

    Thank you so much!!! It helps me a lot

  • @edwinsiyabonga7701
    @edwinsiyabonga7701 Před 7 lety

    It Worked Very Well with me.

    • @SachinSamy
      @SachinSamy  Před 7 lety

      That is great don't forget to subscribe to our channel

  • @irfril
    @irfril Před 6 lety

    Thanks, it is really working

  • @IgorMiquilena
    @IgorMiquilena Před 7 lety

    THank you bro! from Venezuela!

    • @SachinSamy
      @SachinSamy  Před 7 lety

      Your welcome thank you for watching the video don't forget to like share and subscribe

  • @recluse639
    @recluse639 Před 2 lety

    Thank you very much!

  • @knowledgehighschoolsactivi3434

    Thanks a lot. After tiering you give best solution what i want.

    • @SachinSamy
      @SachinSamy  Před 7 lety

      You are most welcome and thank you for watching the video if you like our channel please share like and subscribe also you can make a donation which will be greatly help us.

  • @makoyaaamagulu
    @makoyaaamagulu Před 9 lety +1

    thanks man you helped me alot.....from namibia

  • @rajyalakshmibt4480
    @rajyalakshmibt4480 Před 4 lety

    Thanks so much ! worked for me !

  • @nayanaAdassuriya
    @nayanaAdassuriya Před 8 lety

    This was really helpful for me

  • @winmusic
    @winmusic Před 8 lety

    it works, thank you very much. Greetings from Mexico :)

  • @gauravgaregrat5350
    @gauravgaregrat5350 Před 3 lety

    Bro Thanks to this video👍🙏

    • @gauravgaregrat5350
      @gauravgaregrat5350 Před 3 lety

      Really it helped me so much and beofre i was panic and you. calm me down

  • @PanusiorCh7
    @PanusiorCh7 Před 4 lety

    good worked for me thank u

  • @sethumadavans4815
    @sethumadavans4815 Před 8 lety

    It is working fine , Thank you so much!.....

    • @SachinSamy
      @SachinSamy  Před 8 lety +1

      your welcome

    • @muhammadmubeeniqbal98
      @muhammadmubeeniqbal98 Před 8 lety

      #Sachin Samy i have a problem in request time out during ping. and when connect to sql i have error 18456
      plz reply as soon as possible

  • @wanty3430
    @wanty3430 Před 5 lety

    Very thanks bro! TOP video

  • @saidxonsidiqov8732
    @saidxonsidiqov8732 Před 3 lety +1

    Perfect!!!

  • @jamesmugo1771
    @jamesmugo1771 Před rokem +1

    Great!!

  • @ashishbhad1002
    @ashishbhad1002 Před 4 lety

    Really Really Thank you bro

  • @chettoutyacine8441
    @chettoutyacine8441 Před 5 lety

    Thanks a lot for the video ...

  • @marcinwrotynski3611
    @marcinwrotynski3611 Před 6 lety

    thank you men...you are great...good job...nice :)

  • @wojczek1
    @wojczek1 Před 6 lety

    Thank you. Perfect job!!

    • @SachinSamy
      @SachinSamy  Před 6 lety

      Thank you for watching the video like and subscribe

  • @hangc10
    @hangc10 Před 7 lety

    Thanks; works like a charm.

    • @SachinSamy
      @SachinSamy  Před 7 lety

      Your welcome don't forget to subscribe