G'day guys, In this video I will show you how to connect to an SQL server over in internet via SQL Server Studio Management and VB.NET / codinwithandrew
Пікірлер: 111
@Hero1Alfa4 жыл бұрын
thank you , you are the only one who really aware about real remote connection to db all other spoke about local internet connection .
@danielahmadiadib32284 жыл бұрын
the explanation was great, i wish every one would explain programming just as good as you. Good Job.
@foreigner2thisworld4 жыл бұрын
Thanks Andrew for taking the time and effort to create such informative videos!
@vladanulardzic58595 жыл бұрын
Perfect video ! Really perfect video ! Including testing all the way ! Keep on.
@JohanSandq4 жыл бұрын
Fantastic video. Covers all you need from start to end. Many people recommend using VPN for DB connections, maybe in next video you could elaborate on security issues and how you would avoid port sniffers from finding your database
@charlesledford21514 жыл бұрын
This is a great, to the point, video. Subbed for sure.
@myblackstar Жыл бұрын
Bruh after watching your video I was able to connect to VM SQLExpress with no Problem super easy to follow your instructions. Thank you :)
@boat2020com3 жыл бұрын
That is great, easy and understandable way of teaching. Thank you so much.
@ANdR3WISCOOL3 жыл бұрын
Thank you for your kind words 😊
@pw.703 жыл бұрын
Brilliant! Thanks for this - great explanation.
@josueosorio4256 Жыл бұрын
Gracias, ya días he andado buscando esto y por fin lo encontré. Lo intentaré hacer.
@zakariachriti51564 жыл бұрын
i subscribed becuz you are actually amazing , i really really hope you dont put an end to these tutorials and all these info you have , Thanks alot.
@ianvisser7899 Жыл бұрын
Ngl, probs the best tutorial on it out there. Sure it's simple stuff, open ports, set firewall, enable connection to port on sql server. But that's usually where people stop, whereas you atleast went ahead and showed dummy code for testing the connection, which quite frankly, everyone should be doing to begin with, else you write up a ton of code and never even validated that you're connected.
@abraofrancisco71986 жыл бұрын
Hi Andrew On how to connect without port forwarding can I use just the Hostname in case the ip changes or doesn't not change in free version?
@brianducharme34184 жыл бұрын
Excellent Tutorial - thank you
@LPadillaCR4 жыл бұрын
Simply superb!
@diginetcomputer33905 жыл бұрын
thanx it actually works the same way
@mousaqadry42766 жыл бұрын
one billion like .... i am sure that you are a big expert
@bradhoyer84464 жыл бұрын
Amazing video!!!!!!!!!! I’m trying to connect software to the database
@darryck993 жыл бұрын
You’re amazing!
@bernardcastillo440311 ай бұрын
It's very helpful ❤❤❤ thanks a lot
@user-tf3zo5kj1k5 жыл бұрын
thank's so much!!!
@jaservtechmotovlog4 жыл бұрын
awesome, thanks bro
@MrYemenBoy2 жыл бұрын
Very helpful video.. How about if the isp ip change.. Is there away to get around.??
@afzalhossainbd4 жыл бұрын
Hi, I have done exactly the same as you have described, I can access the local network, not a problem, but I can not access the internet. What is my IP is always changing after some time.
@gax186 жыл бұрын
Can you tell me the problem when i put my ip address in the server name it will connect but when i tried to enter the public ip address it gives network or instance error i really dont know can you help me out?
@alyagoot946 жыл бұрын
thank you very much you'r really awesome , i just make my own db my pc home and connect from work db , thanks man
@ANdR3WISCOOL6 жыл бұрын
+Kankon thank you :)
@tracysu17785 жыл бұрын
How to link sql database @ work pc from home?
@khld19762 жыл бұрын
Some people say that this kind of connection string with the user ID and password can be unsafe and susceptible to hacking. Is this true or is the connection string encrypted in such a way that it cannot be intercepted over the internet?
@tristaniexceed22607 жыл бұрын
hey Andrew. your tutorials are very easy to understand. if I may ask, how can you make a data from a database appear in a text. and change it if you changed the primary key. for example. there's a text box where you input your ID Id =1 username = Hello password = world and when I change the Id in the text box the username and password changes according to the row in the database.thank you I am also using visual studios visual basic 2015 and SQL. sorry for bad English
@ANdR3WISCOOL7 жыл бұрын
you could write a query, something like username = from person in mytable Where id = 1 Select(person.username) and so on.
@tristaniexceed22607 жыл бұрын
Thank you for replying. hope you could upload more tutorials bro. :) godbless!!!
@max-kw5lf Жыл бұрын
love u mate
@rexregalado61766 жыл бұрын
thanks bro..
@bradhoyer84464 жыл бұрын
How do I connect the software to my sql server? It keeps saying check network connections but there are all good!
@egysoft1004 жыл бұрын
Perfect, Thanks ..........
@Keracher943 жыл бұрын
Your video is very good; works well from my computer. But I cannot get this to work from other computers! Also why do you not cover appconfig?
@lhrintl873610 ай бұрын
Thanks Andrew.
@blurptv23526 жыл бұрын
sir i use to connect sql database via ODBC. Can you make a tutorial in odbc that can be connected in the internet or can be access?
@yerkoantonioalvarez Жыл бұрын
and how it done when the public ip changes dynamicly?
@snowiethetoolguy2 жыл бұрын
Tidy job... thanks
@keremislim6 жыл бұрын
Awesome Thank you.
@ANdR3WISCOOL6 жыл бұрын
Problem yok abi
@aashishagarwal66495 жыл бұрын
I tried using 1433 for named instance but it's not working... Plz suggest
@rohanbimalraj30204 жыл бұрын
How do you connect it in Windows form app using c#
@chjayakrishnajk4 жыл бұрын
bro I have quick heal total security I how can I add packet value
@logentheranmaratthandavar79783 жыл бұрын
Bro you are such a boooooommmmmm!!!!!!.... I Subscribed you.
@ANdR3WISCOOL3 жыл бұрын
Thanks man 😊
@techz76755 жыл бұрын
Cool video
@Issus943 жыл бұрын
if another PC wants to make a query from your created database, does your pc have be on all the time?
@ANdR3WISCOOL3 жыл бұрын
Yes, the server must remain on
@Aidan.173 жыл бұрын
Default port 1433 should only be used for default instance named instances are dynamic. Sorry had to mention this because used to see lots of IT guys using named instances trying to force 1433 and it causes a few probs.
@jimmynongololikidev.33617 жыл бұрын
Merci pour cet tutoriel cest vraiment secourant
@profipix6 жыл бұрын
I did exactly as in the video. No antivirus to worry about. Running windows 10. When I port check, port 1433 works but not 1434. When I use the public IP "xx.xxx.xxx.xxx/SQLSERVER", I get the error that the network path is not found. I also tried just using the public IP without the server path. So, port 1433 works good, 1434 is not open, though already port forwarded. Not sure what to make of this.
@Easyali14 жыл бұрын
does it require Static IP....
@amigostv34033 жыл бұрын
sir, can u give me the download link of that SQL Server plsss. or what SQLSERVER version is that?
@ilaBaroIT5 жыл бұрын
well I was search this for months
@raedeid83092 жыл бұрын
great
@liamtwine22673 жыл бұрын
its asking me to connect to a server? but obv i dont have one yet
@saarkcomputers8555 Жыл бұрын
Sir We are using Quick Heal and there is no Option of Add Pocket Rule, We followed all instructions as you shown, But its not working on Windows 11
@mukilana5556 жыл бұрын
How To Use Instance Name Connection And Use Another PORT ID change Option
@HardcoreEDM10 ай бұрын
First of all, port forwarding only work if you are out of LAN, if you in an area where your ISP formed a large LAN, you won't able to make that work, especially those live in apartment/flat/condominium. So you have to change your internet plan, get Static IP address or ask for a single line beside sharing within the resident area.
@mukilana5556 жыл бұрын
1433 in SQLEXPRESS instance ID , I want NAMED INSTANCE Port ID
@ademajames72504 жыл бұрын
Thanks
@JanezKrnc-San6 жыл бұрын
Hello! My IPAll on TCP/IP properties is set to a different port than default 1433. Its on 50123 (all others are on 1433). I've added inbound/outbound exception in firewall for both 1433 and 50123, as well as adding SQL server and sql browser application exceptions. Connecting to server doesn't work (tried xx.xxx.xx.xxx also xx.xxx.xx.xxx,1433 also xx.xxx.xx.xxx,50123 Nothing works. What else do you suggest i change/try (possibly regarding my 50123 port) ? I've spent many hours and all the tutorials/troubleshooters about it say the same things and i've done all that. Connecting to it locally (xxx.xxx.x.x,50123) works. Gosh please help. P.S.: Remote connection is allowed, TCP/IP enabled everywhere (as well as named pipes).
@ANdR3WISCOOL6 жыл бұрын
is your port forwarding working?
@JanezKrnc-San6 жыл бұрын
Oh man. I was waiting for a guy at the firm to do the port forwarding while i wrote this comment. tbh, wasn't convinced that that would straight solve the issue in itself, but it DID! Kind of embarrased I didn't wait until a thing you specifically said in the video would get done before writing a comment. Anyways thank you so much! You saved me alot of frustration :) Other pages i've looked didn't mention port forwarding much at all.
@JanezKrnc-San6 жыл бұрын
After port forwarding was set for both 1433 and 50123 ports, I could connect via internet by specifying server name as: ",50123" in case someone else has an issue with different port than default.
@abdulsms6 жыл бұрын
How to run vb.net program through vpn
@qual14812 жыл бұрын
When i create the database on my desktop machine at home, then say i go to college with my laptop, would i be able to access the database even if my home machine is turned off?
@ANdR3WISCOOL2 жыл бұрын
Hey there, no sorry, the machine would need to be turned on in order to access the database
@qual14812 жыл бұрын
@@ANdR3WISCOOL Okay thank you for the reply
@ANdR3WISCOOL2 жыл бұрын
@@qual1481 no worries, good luck at college 😊
@nesvlogs74655 жыл бұрын
However, when i reset router, my IP address in web 'what is my ip change'. How to repair it?
@ANdR3WISCOOL5 жыл бұрын
Cảnh Phim Hay you will need a static IP address, if not, check out my video on doing it without port forwarding
@evermovie4614 жыл бұрын
@@ANdR3WISCOOL where is the video
@amoscookie13369 ай бұрын
Then the only option is😢 is to expode the who SQL DB to internet. Is there a better way of doing things
@manthangohel92373 жыл бұрын
Let's say I made a Windows form in VB.Net and connected it to the SQL Server over the internet in my machine... If I share the project with my friend who hasn't done the whole process of making the SQL Server work over the internet.... Then will he be able to access the database over the internet or he will be required to enable the SQL Server too?
@ianvisser7899 Жыл бұрын
The app is just a front end. So your friend will be able to connect to the same server as you.
@tracysu17785 жыл бұрын
How to connect sql database working network from home network? Plz
@manojdebnath32423 жыл бұрын
👍👍👍👍
@surtole75845 жыл бұрын
MY password becomes something different and i dont know what it is!
@sarlemonvannasing7056 жыл бұрын
Dear sir, it means via internet not local network right...!
@mujabdillah26186 жыл бұрын
hello sir. I followed all your steps but still i cannot access my mssql throught internet. can you please help me? i already shutdown my firewall becase it is one to my suspect but still cannot access it.
@ANdR3WISCOOL6 жыл бұрын
your ISP might not allow portforwarding, I will make a video in the near future on what to do if you cant port forward.
@mujabdillah26186 жыл бұрын
now is the future. please sir :)
@ANdR3WISCOOL6 жыл бұрын
hahahahha good one lol, the next video I make will be for you.
@ANdR3WISCOOL6 жыл бұрын
here is a video on how you can connect to your sql server over the internet without portforwarding kzbin.info/www/bejne/imbOp4qwhcdsgdE
@incredibleG0074 жыл бұрын
There is no need to set up Outbound new rule! Inbound is good enough!
@cliffordfrancisco86876 жыл бұрын
I followed all the instructions but I still can't connect to the SQL Server... Why Sir? Can you tell me what is the reasons behind it?
@ANdR3WISCOOL6 жыл бұрын
your isp might have blocked your ports, here is a video on how you can connect to your sql server over the internet without portforwarding kzbin.info/www/bejne/imbOp4qwhcdsgdE
@ktan188796 жыл бұрын
I have no problem with every single part except for the last one where there is an instance specific error
@chatchaiphongvicha96754 жыл бұрын
ขอแปะครับ
@gmteo35736 жыл бұрын
is this safe from the hackers?
@ANdR3WISCOOL6 жыл бұрын
Make sure your password is decent and that you don’t have your connection string in plain text
@charli38410 ай бұрын
I did all the steps but I can't connect via the internet
@jeetchheda89166 жыл бұрын
no matter what I do in India port forwarding is not working in any router please help me
@ANdR3WISCOOL6 жыл бұрын
jeet chheda see my video on accessing an sql server over the internet without port forwarding
@jeetchheda89166 жыл бұрын
Coding With Andrew Thanks actually just before u replied i was able to navigate there😅😂 thanks alot btw.
@jeetchheda89166 жыл бұрын
Coding With Andrew Hey Guess what.. I found another Method that could help the same way.. But it has a drawback, It Forwards ip only till the time the program is running.. and As soon as u start it again.. the adress changes.. The method was to use ngrok.exe
@ANdR3WISCOOL6 жыл бұрын
Here is a video on how you can connect to your sql server over the internet without port forwarding kzbin.info/www/bejne/imbOp4qwhcdsgdE
@mryan55222 жыл бұрын
its so risky, ive tried to open port and boom. I got thousands of virus incoming.
@elwaddaly5 жыл бұрын
I want to download this video >>> Why don't you let me do this ... please I need this video
@romansnellies4 жыл бұрын
www.sskzbin.info/www/bejne/oJi6gI2Ka9-Uack
@momloc78052 жыл бұрын
you Test on same machine.
@nesvlogs74655 жыл бұрын
In your video, Your ID address is 101.160.5.181. Whene You reset your router, this id address is going to change
@ANdR3WISCOOL5 жыл бұрын
Cảnh Phim Hay correct, you have three options, create an application “like I did” to tell you your up address, use a static IP address or use hamachi