Connect To SQL Server Database Over Network - Enable Network Access in SQL Server - Remote Access

Allow remote connections to SQL Server Express
In this video, we have explained about following thing
Connect To SQL Server Database Over Network - Enable Network Access in SQL Server
Complete steps is described in this video regarding How To Connect To SQL Server Database Over Network - Enable Network Access in SQL Server
If you got any clarification on this, please write it on Comment section.
We will definitely update you back.

[@RajuSNair]

Small or Big, you can support me through SUPER THANKS

[@rollenlopez1154]

Clear, straightforward and direct. Great job

[@RajuSNair]

Always welcome ☺️

[@BeIndianmemes]

Very helpfull sir.

[@tuscake5272]

Thank you for your server name idea. Successfully connected my SQL Database and my .net Windows App over the internet.

[@saurabhparmar8577]

Hello sir, I was stuck on site from 2 days and finding solution for connecting 6 pc's database. I almost tried everything but didn't get any solution. Then my Ex girlfriend sent me your video link and after following your steps my problem solved. And my happiness is does not fit in the sky. Thank you soooo much for your valuable video.

[@RajuSNair]

Always welcome

[@macbagie]

This is like my PP. Short, but very detailed, thank you.

[@RajuSNair]

Welcome 🙏 🤗

[@nicolasarbio820]

5 years and people still needing you. Thanks a lot!

[@RajuSNair]

Always welcome ☺

[@esamzenhom]

you are the simplest ... the most direct Programmer i've ever seen in my life ... thank you some Much

[@RajuSNair]

Always welcome ☺

[@BaySideTV]

I was having issues remembering how I did this last. Found your lesson and was successfully in connecting db server to network clients. Many Thanks!! Don

[@RajuSNair]

Always welcome

[@jhestt]

OMG I'M LITERALLY ABOUT TO CRY BECAUSE I'VE BEEN WORKING IN FOR ALMOST A WHOLE DAY UNTIL I FOUND THIS. THIS REALLY HELPS! THIS WORKS! T_T

[@RajuSNair]

You Are Always Welcome

[@happylittlemonk]

The best lesson I have watched. Many thanks

[@RajuSNair]

:)

[@upertvillarin1999]

You must be heaven sent. It works! Thank you, brother...

[@RajuSNair]

Always welcome

[@mohammadal-ramadhan6647]

A straightforward lesson and clear teaching. Thank you so much sir

[@RajuSNair]

You are most welcome

[@fwd2941]

Short and to the point thanks. Its rare to be seen thee days

[@RajuSNair]

Always welcome....

[@mohammedtawhid679]

many thanks ... very helpful and working video ...

[@RajuSNair]

Always welcome

[@sharanu5458]

Hello sir I have an doubt?? I created windows application by using visual studio and ms SQL server If I insert data to SQL server through my visual studio application my question is - this data will be show in another pc if I install my visual studio application????

[@RajuSNair]

If you can connect your own SQL db with network ID then you can connect from any other machine...

[@sunilfussey]

Many many thanks for explaining the complex steps in a simple and systematic way which has helped me to resolve the issue quickly.

[@RajuSNair]

Always Welcome

[@dmm10000]

Excellent - thank you - which EXACT version of microsoft SQL server did you use please ?

[@RajuSNair]

this works in all. don't worry. Follow these steps one by one as in the video.

[@EbrahimAlkadim]

BIG THANKS! you helped me i searched all over the internet and non of them worked with ,( i just need to add "space" then my port number) thank you !!!!!

[@RajuSNair]

Always welcome.....

[@hersimadobe1439]

Thank you the simple explanation. I have an inventory SQL based database installed in my windows 2016 server and we want to access it remotely for all the users thru the internet. Do I follow the same procedure? Many thanks

[@RajuSNair]

yes sure..you can go ahead

[@AaricAaiden]

Is this necessary to install sql server to all client machines ? isn't there any way to access the server and enter data in database from another machine on which the sql server is not installed over local area network. I have created c# application and in connection string i have used the server name and Integrated Security as true because the sql server is connected through windows authentication on admin machine. The application is working fine in admin machine but when i install application on client machine which is connected over a LAN and hasn't installed the sql server i get the error the server wasn't found. Please let me know how it's done.

[@RajuSNair]

SQL Server is required only on one machine from where the client machines needs the db details. Just configure the parent machine with firewall port opened. Simply access the parent machine from any other machine.

[@AaricAaiden]

@@RajuSNair after enabling tcp/ip port do i need to add this port in connection string along with the server name? and will it work with windows authentication or i must create a user with login and password on admin sql server? Thanks

[@RajuSNair]

Bro...it's SQL server authentication.... Yes there should be IP or name with port comma separated as shown in this video... When you use simply program to connect you cannot trace the correct error... But when you try to connect using SQL management studio you can trace db connecting or tables are displayed where u r getting error , you can track the situation....

[@manasswain9915]

Not working

[@MohammadAli-iu3oi]

I can see in both of your machine has SQL Server, is it ? If yes, so is it necessary when we are using any application with SQL Server based database but it is client machine not server. OR we can use our database directly from our client machine without installing SQL server through our connection?

[@RajuSNair]

+ Mohammad Ali - we need sql server only on one machine that will be connected through network. The parent machine should be configured properly to allow in and out connection as said in video regarding Firewall config. In this video I have used Management studio to connect to Parent machine. You can even your app itself.

[@ainzue5295]

thank you for the video and it does help a lot. But I dont get the last part. so we do all the stuff on the first PC right? And on first PC we use window authentication at the SQL server management. Then when we want to connect them using the sql server authentication, we do that on second PC? So the IP address that we have to use is IP adress of the first PC? Sorry for the bad english.

[@RajuSNair]

On Parent PC, you have to setup the SQL Server Authentication with Firewall Configuration. After doing Port forward on Parent PC, Use IP and Port to Connect to Parent PC from other Child PC.

[@ainzue5295]

ohh thank you so much. Actually we have successfully done the configuration on the other day. But today when we tried again it doesnt work even we have change the IP because we configure at the different place. why that happened and how to fix?

[@upload58404]

good job , well if I use wire instate of connation both computer to same router will this way work or not ? I want to use wire .

[@RajuSNair]

Yes it would work. All you have get the proper Ip of each computer and try to ping from one another. It's all about making a clear path between computers

[@MakeItHappenWithVBA]

Good day! Just like to ask sir if this method works for example i am here in the philippines and my client is from another country? Thank you so much.

[@RajuSNair]

Yes definitely. It's better to take a dedicated ip address for connecting across internet.

[@MakeItHappenWithVBA]

@@RajuSNair Thank you so much. I will try to learn this application.

[@nitingandevikar4547]

Thanks Admin !! Absolutely useful help, works even today !!!

[@RajuSNair]

You're welcome!

[@novandosantosa3621]

Does this work only if computers are connected in the same network or any network outside the organization?

[@RajuSNair]

Both intranet and internet are possible. Fir internet go for a dedicated ip address

[@bernardjacob3118]

Ô punaise ! Saleté de windaube qui disable le sa userid ainsi que la double authentification ! Merci admin Technomark !

[@ahv5457]

Thanks for the video. The configs that you have explained were done on the server or client machine?

[@RajuSNair]

1. first you have to enable the sql authentication on sql server. 2. Then add user mapping for this user for that database. 3. Configure SQL Configuration Manager for port 1433. 4. Configure your firewall to allow any traffic through 1433 port. 5. Definitely restart SQL server after these steps. 6. Then first try to ping first machine from second. 7. And then try using your app or SQL management studio of second machine to connect to first machine. From Base Computer, you can do these steps and you can definitely access from connected machines. From connected machines..try to ping base machine...If yes..try to connect using MS management studio. If yes...then continue with code.....

[@ahv5457]

@@RajuSNairThanks very much for a detailed explanation.

[@vinitasinha6183]

very nice lesson sir , it helped me a lot...solved my sql server connection issue over network

[@RajuSNair]

Always welcome ☺

[@phumthur5183]

Thank you so much, This is the best lesson

[@RajuSNair]

Always welcome

[@FarooqAhmad-id4sx]

This is the best Video, to explain this method step by step

[@RajuSNair]

+Farooq Ahmad - Happy to hear that it really helped... :)

[@chilakalavenkatainduja305]

Thankyou sir it helped...

[@Ali-gb2fu]

Great! what if we installed xampp not a SQL server studio on another computer and access that SQL database using PHP how we can connect?

[@davie732]

Thankyou so much for this. Followed your video and it worked well. Thanks. Ive added this to my book marks when i need to use it again.

[@RajuSNair]

You're very welcome!

[@ryuaustria]

Thank you! Helped a lot! I also loved each your "Ya" throughout the entire video 😁

[@RajuSNair]

+Ryu Boado - always welcome......we like improvement and will definitely refine more our videos.....

[@robvincenttizon2181]

Hello. Does that mean you have to connect your 2nd PC to the network in order for your 1st PC to access its database? Newbie here.

[@RajuSNair]

Absolutely both PCs should be on network either internet or Intranet...

[@robvincenttizon2181]

What if I buit a c# app with sql server database on one PC then i want other users in my network to install and use it? I have used the appropriate connection string to allow other PCs to fetch data from my local database. What i want to know now is, if I disconnect my desktop/laptop to the network after they have installed and use my app for the first time, will they still use the app properly? Can they still fetch data from the database? Your help is much appreciated

[@RajuSNair]

in the above contest, just make sure the database system should be up and configure that system for incoming connections as I explained on video. Then from any other system on network connected to the database system will be able to connect to the database.

[@roo0oony2009]

You are amazing. Thank you

[@RajuSNair]

Always welcome ☺

[@usamaaziz4349]

Thank for explanation. Can we connect two sql-servers over the internet by following the same procedure?

[@RajuSNair]

Yes over the internet try to keep static ip for connection between two and configure sql server and firewall as in the video. I have done many projects over internet also.

[@usamaaziz4349]

Thanks for your quick reply sir.

[@sherifalhinti2367]

thank you dearly this was very helpful

[@RajuSNair]

Always welcome ☺

[@motoreels4116]

Does this method work on an external network, or must the devices be on the same network!!

[@RajuSNair]

it works on external also. just need dedicated ip for this to achieve.

[@motoreels4116]

@@RajuSNair thanks alot

[@narveersingh348]

Hi, thanks for the video. I can't see any protocols in the SQL Server Network Configuration tab. Searched for the issue online, but no luck there. Can you please provide your help on this? Thanks.

[@swahabali1]

this is amazing :) can you please guide me how to connect from other network please

[@muhammadaamir566]

thanks alot sir....Sir how i will make a centralize database server in SQL 2008 R2? I want to install database only one PC and install my exe .net app on my other user PC's?

[@RajuSNair]

just install sql server on parent pc and then configure that pc for accepting connection on that network. If you wants to access that parent pc from internet, then go for a dedicated ip. Just remember on parent pc, you have configure sql server authentication and then sql Server Configuration manager and then port forward by configuring firewall. All steps are described on this video. Do like that. After doing above steps, just try to connect the server within that parent pc by using Management Studio if you can. Check the IP and port with proper comma. Give SQL Server Authentication Mode instead of Windows Authentication Mode. Make sure that it would connect successfully from Management studio. Then on Client PC, place same Connection String with Username and Password. It will definitely work.

[@muhammadaamir566]

@@RajuSNair actually sir i want to install exe setup of .net desktop app... I don't want to install sql server on each user pc...i just wanna install sql server on one pc and connect all my user PC's with that one single sql server pc

[@RajuSNair]

yes only on parent pc just install sql server. You need only one installation. that is on the main parent machine. that is why sql server authentication is made for this purpose.

[@muhammadaamir566]

I am really thankful to you sir....you are amazing....you channel is perfect.........send me your kind email.....can I access parent sql server from out side of my LAN network??does it possible??

[@manasswain9915]

Hi. Pls help me Same problem. Main pc .exe run bur user pc error. Don't access the data base from main pc. Db install pc is running good but client pc same connection that error. I install sql server 2008 r2

[@shaikh2020]

excellent, thanks bro

[@RajuSNair]

Always Welcome

[@amazdanny]

Wow. So incredibly helpful. Thank you!

[@RajuSNair]

Always welcome

[@zerosandones7547]

Is it possible to do a .sdf database in my application, and then when I network it to another computer, I can access that database, and if (for example) I deleted a data on my computer, when I view my application to another computer that data will also be deleted.

[@sharanu5458]

U got answer

[@عصامهلال-د5ق]

Thank you very much, thank you very much, thank you very much, thank you very much

[@RajuSNair]

Always welcome....

[@otymo4904]

Is this for LAN only or also Cloud Based?

[@devdharma3050]

Thank you so much for the neat explanation.

[@RajuSNair]

+Dharmaraj M - always welcome.....

[@erhanbayrak2851]

thanks you for this video. love from turkey.

[@RajuSNair]

Always welcome ....

[@zabihbutt3451]

Thank you it was really helpful for me Love from Pakistan ❤♥

[@TheBalathegreat]

Thanks a lot sir... Very Useful for me...

[@RajuSNair]

welcome...

[@logitizer7843]

One of the best guide created! Really liked your way. Keep promoting good things in this world.

[@RajuSNair]

+Logitizer - thanks bro....definitely will post videos .....

[@deepaksky]

Brother thanks for very nice turtorial. i want to install vistual studio and sql server for learning. can you advise which one should i install first? and there are so many versions like visual studio 2015 and sql server 2012 etc. which one is best which one is good for learning? Please brother reply i would be really greatful to you.

[@RajuSNair]

Both are independent. Install VS or SQL server doesn't matter. Ultimate edition of VS have Sql server inbuilt. But it is good to have a separate SQL server and Management Studio installation. VS 2015 is with latest update and coding friendly made. That would be better, if you have good system configuration. SQL server 2012+ express edition needs to be installed for development purpose. So VS 2015 ultimate. SQL server 2012 express edition, SQL server Management Studio are enough for programming.

[@deepaksky]

thank you for kind reply thats indeed very helpful. i found free edition of sql server 2012 express edition. is there any free one available for VS2015 for learners? license fee would be very costly :( your videos are really helpful and absolute to the point. Keep up great work. I have subscribed to your channel. best wishes.

[@RajuSNair]

:) ..... I can understand...but Microsoft products VS 2015 is not free. But we can evaluate for 30 days any version like express to ultimate.

[@bienguintoiii]

Thanks for this video

[@RajuSNair]

Always Welcome

[@salih3145]

Would this work if both computers weren't sharing the same wifi network?

[@RajuSNair]

For internet connection, get a dedicated ip to connect each machines

[@manzanazo1]

Hello, can you help me. I have 2 network and 3 sql server's, I have sql2 link to sql1 and sql3 link to sql2. How can I see since sql3 to sql1 ??

[@rahulsata2236]

from this, i don't get any help. I have done all thing that you did. just have doubt that my server name is - IPAdressofcomputer where database exists: PORT which we specified in rule.

[@kaleem887]

Lov you ❤ Great work done bro.. I have spent 2 days on doing this but failed.. you did it 👍

[@rahulsata2236]

hello brother, Can you help me? I have done all these things in ssms, as well as sqlconfiguration manager, also added a new rule in firewall. If possible , give me your skype ID. Thank you brother.

[@Toturials]

hi dear, thanks for the video.but it did not work for me, i Setup everything on my PC as you have shown , then i try to connect to database from my Laptop that is also connected with the same wifi Router via Wifi.I get error (Error 4064, Login failed for admin user)

[@RajuSNair]

here....first try to connect from the same pc where sql server is installed with management studio on the same machine with correct SQL Authentication ip, and port. If that is success, you can copy to any other machine that is on the network.

[@Mirec274]

Thank you for this video, greatly explained!

[@RajuSNair]

You're very welcome!

[@arturoescalonarubio]

Great, easy and effecrive tutorial ! Thank you

[@RajuSNair]

You are welcome!

[@karthikkeyan4460]

Hi.. First of all, this was a awesome video and thanks for creating this. I have a question though. Is it possible to use this technique to connect 2 computers available in 2 different networks (let's say 1 computer is on airtel and an another one is on Jio) but both are available over internet..??

[@kajalchauhan2450]

Same question

[@dadwonkulah9119]

Nice, this safe me. Thanks man!

[@RajuSNair]

Most welcome ☺️

[@PradeepSingh-yo7ye]

Thank you so much sir 👌

[@RajuSNair]

Always welcome....

[@abdallahbelcaid3002]

Now I can connect to sql server from another PC (without having on it sql server ) using this method ?

[@RajuSNair]

Yes bro definitely you can connect. Only the patent system to where you are connecting need SQL server. For example if you are running an àap from client machine that access parent SQL. This method works....

[@abdallahbelcaid3002]

@@RajuSNair I have installed a vba (data entry )application connected to a DB sql server and I want a person to have acess to this data base in a local network on his pc is it possible without having any soft ?

[@RakeshSharma-oj9pd]

it works good thank you very much

[@RajuSNair]

Always welcome...

[@ThasneemJambi]

Best lesson... Respect! Thank You Teacher

[@RajuSNair]

...always welcome......

[@stonedVayne]

you dont know me but i Love you

[@RajuSNair]

Always welcome

[@joaoatanasio3047]

this should be done in both pc?

[@RajuSNair]

bro just configure as in the video on parent system where the db is present then access from the network. It will work.

[@elandrevanderwalt]

Short and very helpful. Thank you!

[@RajuSNair]

Hi Elandre, When I faced this issue first time, there was no video regarding this topic. It took some real effort for this video, but at the end, i was able to produce. happy to hear from you.

[@transistor69]

I really apreciated this video thanks a lot for sharing your knoweladge

[@RajuSNair]

+Gian Luca Galazzo - :)

[@AngadiGuru]

Thank you sir, its really excellent information.

[@RajuSNair]

+Guru Angadi - always welcome....

[@pietersmith9745]

Thanx a billion. Just what I needed.

[@RajuSNair]

+Pieter Smith - always welcome .. ..

[@TheZahid2008]

Sir I need your help. I use VB 6.0 and want to make connection Sql-Server 2005. Please help and want to distribute over LAN so that my application can run smoothly on LAN without any problem. Thanks in advance.

[@RajuSNair]

Over LAN also same configuration as shown in this video is enough. Just modify connection string on your app as shown here and use Management Studio to try the connection settings.

[@unboxsimplified]

Great.. Clean Tutorial.. work like a charm :)

[@RajuSNair]

Thanks....

[@yasinarafat4837]

Awesome program

[@salmancp6505]

Sir while giving permission db datareade and db data writer its showing message add member failed for databaserole. How to clear this? Please help sir

[@relaxdaddy1219]

thank you brother.. May God richly blessed you.. God bless your endeavor.. =)

[@RajuSNair]

+Baby's Day Out - always welcome.....happy that it really helped......will make more videos like this....

[@rukhsarahmad3224]

I want to know , it will effect if we restart first computer or second ?

[@RajuSNair]

+Rukhsar Ahmad - this method that I have shown depends only IP that is configured... So nothing will change this setup as long as IP is correct.... I have been using this method for many of my clients..... Yes sometimes I may not be able to connect...because of IP change....then I do following method... 1. Either I would change current IP written on the config of my project with the new IP... Else...instead of IP, I use server name to connect... Means...instead of 192.168.1.1, 1433... I use.. ServerName, 1433... ...

[@rukhsarahmad3224]

many many thank you for your valuable reply, it working fine i have check it. but i have another small issue with it, that my connection string not working in second computer with asp.net mvc i am using Web API. 1. in Computer one working v good. (from which i access database) 2. but in Computer 2 not while i am connected with database from second computer.

[@RajuSNair]

+Rukhsar Ahmad - so basically you have three computer... 1 server where you installed the SQL server and forwarded the IP... 2 a computer from where you was successfully connected to server. 3 second computer from which you are not able to connect to server.... If that is the case..are you able to ping from second computer to server....?....

[@rukhsarahmad3224]

Yes ,it working fine now, it was my fault, that i just change the IP to name in all Computer where i accessing the server and now working very well, thanks

[@Cosmy18tm]

As a db_owner you do not need extra reader and writer because db_owner contains those priviledges as well.

[@fab99fab]

Thanks for the video...

[@therawbot]

Hi, Thank you very much for this tutorial. I have a small question, I am able to connect remotely to LocalDB .mdf database (located on PC1) from PC2, but if that .mdf database is used by PC1, PC2 can't open it. How to resolve this problem please.

[@RajuSNair]

Hi, Ayoub Try to increase maximum number of concurrent user on SQl server properties Connection tab section.

[@therawbot]

yes it's set to 20, I got Error Number : 4060, State: 1 Class: 11 (Login Failed for User DESKTOP-F1G...\Nadine)

[@RajuSNair]

Hi, Ayub.. 1. first you have to enable the sql authentication on sql server. 2. Then add user mapping for this user for that database. 3. Configure SQL Configuration Manager for port 1433. 4. Configure your firewall to allow any traffic through 1433 port. 5. Definitely restart SQL server after these steps. 6. Then first try to ping first machine from second. 7. And then try using your app or SQL management studio of second machine to connect to first machine.

[@youcodesolution]

some of myfriend told me to use static ip for remote access your Database. is it rite?

[@RajuSNair]

By using static ip does not always needed. Even you can connect using Server Name also. But yes static IP gives you a hassle free atmosphere else if in any way ip changes you have to forward that new ip also....

[@youcodesolution]

@@RajuSNair Like how can i connect using Server name remotely..

[@nmt128]

In the login step at your remote machine (5:16-5:30), what's the password? I made a note of all the passwords from when I installed sql but they are all incorrect. And in your instructions, I also don't see you set a password of the same length as the password you use to log in

[@maheeshamadhubashini4449]

In my website, the database is ms sql and I used yii framework. For connect the yii with ms sql, I used the apache in xampp. Now I want to host the website. How can I do it?

[@RajuSNair]

The best way is that make the database part in WCF. Then host this WCF project in one of your server. WCF produce more security over internet threats and SQL injection. After that Call this WCF service from your any application whether php or ASP since WCF is platform independent. ...........

[@maheeshamadhubashini4449]

Thank you sir for your quick responce, Do you have any tutorials or videos how to do this because I'm not familiar with that.

[@RajuSNair]

More than me..the best teacher in WCF will be Pragim ( kudvenkat ). Follow this link for WCF tutorials. kzbin.info/www/bejne/h57JgaCngtBsjtU

[@maheeshamadhubashini4449]

Thank you sir.

[@amarenderreddydodle1486]

Hi Friend this video is very help full, do we need to configure these steps in both primary and secondary machines...?

[@RajuSNair]

Hey Amarender.....From Base Computer, you can do these steps and you can definitely access from connected machines. From connected machines..try to ping base machine...If yes..try to connect using MS management studio. If yes...then continue with code.....

[@amarenderreddydodle1486]

Could you please tell me how to ping from connected machine to base machine...

[@RajuSNair]

how to ping..? 1. Get your base machine ip address. 2. open cmd from connected machine. 3. type" ping ip address " from connected machine. If you get response...you can proceed. 4. Else there is having network issues between two.

[@RajuSNair]

cmd means command prompt window.

[@RajuSNair]

try to open cmd as administrator

[@slashd]

This worked for me!

[@RajuSNair]

Glad it worked....there is nothing more to be done.... Because I am using it for a few years.... as per the contest is same.

[@calvinmunisi346]

Thanks alot.. this video helped me out alot

[@BFCM2024]

Thank you so much very helpful

[@RajuSNair]

+watsup hayy - always welcome..... if you face any update on this please add your valuable comments here regarding this topic... .............

[@BFCM2024]

Im using SQL sever 2014 it works for me, but there is lil bit hard part, on how to show sqlsever configuration manager. To show it in sql 2014 you need to open run command (ctrl+R) then type SQLSeverManager12.msc

[@RajuSNair]

+watsup hayy - ....thanks for your update.... 1. On windows 10, Control Panel→Administrative Tools→Computer Management under Services and application , sqlsever configuration manager can be found. 2. To open SQL Server Configuration Manager, in the Search, under Apps, type: SQLServerManager14.msc for [SQL Server 2017] or SQLServerManager13.msc for [SQL Server 2016] or SQLServerManager12.msc for [SQL Server 2014] or SQLServerManager11.msc for [SQL Server 2012] or SQLServerManager10.msc for [SQL Server 2008], and then press .....................

[@BFCM2024]

Wow nice info

[@softwaresailor4324]

thanks a lot my dear

[@RajuSNair]

You are most welcome

[@cyberacademy3109]

I have tried this type of connectivity. connection established but server machine halted and no display. It appears when i tried to access through client machine. I did not understand why?

[@RajuSNair]

check with firewall settings of server machine and allow connection from your child machine

[@RajThenew]

Awesome Information, Thanks Mate !! I was just wondering, if we can somehow connect to a LAN SQL Server through my Cloud Hosted PHP Code. Any Expert Comments will be highly appreciated. *Assumption* - I have Full control on my Cloud server as well as my LAN SQL Server Database.

[@fwd2941]

This works when the two pcs are connected with the same network. But if I try to connect pcs using different networks they are not connected?

[@RajuSNair]

no...any network it works... even it works on internet also. Just port forward and configure firewall as described on here

[@mariusghita3861]

thank you man! it works on the same network

[@IbrahimaDiallo-tt3nd]

Number one

[@antoniodesousa1731]

Good video, thanks... but, it would be nice to see how you connect to a sql server instance outside the network via the internet...

[@RajuSNair]

Hey...welcome here.... If you are trying outside the network, all you need to do is make your one port public. Note the IP also. Now follow the steps on this video for the second machine. Means...Sql server authentication, Sql Configuration Modification, Firewall config... Now use the ip and port for connecting outside any network. .......................

[@dhritimanbharadwaj9133]

@@RajuSNair where?

[@chetanakakade7494]

@@RajuSNair Can you please make a video on how to connect to SQL Server outside the network via the internet? That will be very helpful! Thanks

[@Shpatak]

on creating admin account, you entered a short password. When loging in from another PC, you wrote much longer password,why? It seems like on me there is a problem while connecting

[@RajuSNair]

so you are confused between password... Don't worry....

[@kishores2149]

Can I use this remote database configuration on mobile apps