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

[@RajuSNair]

Small or Big, you can support me through SUPER THANKS

[@rollenlopez1154]

Clear, straightforward and direct. Great job

[@RajuSNair]

Always 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 ☺

[@happylittlemonk]

The best lesson I have watched. Many thanks

[@RajuSNair]

:)

[@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

[@tuscake5272]

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

[@fwd2941]

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

[@RajuSNair]

Always welcome....

[@mohammadal-ramadhan6647]

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

[@RajuSNair]

You are most 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

[@macbagie]

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

[@RajuSNair]

Welcome 🙏 🤗

[@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

[@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

[@upertvillarin1999]

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

[@RajuSNair]

Always welcome

[@BeIndianmemes]

Very helpfull sir.

[@nitingandevikar4547]

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

[@RajuSNair]

You're welcome!

[@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.....

[@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.....

[@mohammedtawhid679]

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

[@RajuSNair]

Always 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 .....

[@vinitasinha6183]

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

[@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... :)

[@bernardjacob3118]

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

[@phumthur5183]

Thank you so much, This is the best lesson

[@RajuSNair]

Always welcome

[@devdharma3050]

Thank you so much for the neat explanation.

[@RajuSNair]

+Dharmaraj M - always welcome.....

[@amazdanny]

Wow. So incredibly helpful. Thank you!

[@RajuSNair]

Always welcome

[@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!

[@ThasneemJambi]

Best lesson... Respect! Thank You Teacher

[@RajuSNair]

...always welcome......

[@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.

[@funkyminus]

I've spending like 3 hours to figure it out how to do this until I found your video. Thank you guy. You saved my ass.

[@RajuSNair]

:)

[@arturoescalonarubio]

Great, easy and effecrive tutorial ! Thank you

[@RajuSNair]

You are welcome!

[@Mirec274]

Thank you for this video, greatly explained!

[@RajuSNair]

You're very welcome!

[@erhanbayrak2851]

thanks you for this video. love from turkey.

[@RajuSNair]

Always welcome ....

[@TheBalathegreat]

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

[@RajuSNair]

welcome...

[@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.

[@stonedVayne]

you dont know me but i Love you

[@RajuSNair]

Always welcome

[@unboxsimplified]

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

[@RajuSNair]

Thanks....

[@transistor69]

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

[@RajuSNair]

+Gian Luca Galazzo - :)

[@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....

[@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 .. ..

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

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

[@RajuSNair]

Always welcome....

[@roo0oony2009]

You are amazing. Thank you

[@RajuSNair]

Always welcome ☺

[@sherifalhinti2367]

thank you dearly this was very helpful

[@RajuSNair]

Always welcome ☺

[@calvinmunisi346]

Thanks alot.. this video helped me out alot

[@PradeepSingh-yo7ye]

Thank you so much sir 👌

[@RajuSNair]

Always welcome....

[@chilakalavenkatainduja305]

Thankyou sir it helped...

[@abbasthegreat5]

Lots of love for you sir g You made my day.

[@RajuSNair]

+E-Learning Portal - this really encourages me to do more videos.......happy to hear from you....

[@abbeydudeuk]

you are simply the best.

[@RajuSNair]

Thank you...

[@RajuSNair]

Here we explain how to Connect To SQL Server Database Over A Network using Management Studio from one system to another. We can generate Connection String also.

[@RakeshSharma-oj9pd]

it works good thank you very much

[@RajuSNair]

Always welcome...

[@mariusghita3861]

thank you man! it works on the same network

[@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

[@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

[@Cosmy18tm]

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

[@dadwonkulah9119]

Nice, this safe me. Thanks man!

[@RajuSNair]

Most 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...

[@shaikh2020]

excellent, thanks bro

[@RajuSNair]

Always Welcome

[@Raptor-jv7fi]

Thank you so much!!! IT WORKED!!!

[@RajuSNair]

always welcome...we will definitely make more videos like this..

[@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

[@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

[@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.

[@zeeshanqureshi9252]

love you Sir.. made my day!!!..

[@RajuSNair]

+Zeeshan Qureshi - always welcome.....love to hear from you.....will host more videos like this....

[@zeeshanqureshi9252]

@@RajuSNair Thanks for Considering it Sir.

[@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.

[@swahabali1]

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

[@roman.venica]

Nice! This worked for me!

[@RajuSNair]

Hey Roman.... welcome here... I had done this video after there is a requirement on my project to share windows application. Hope this was useful for you.

[@bienguintoiii]

Thanks for this video

[@RajuSNair]

Always Welcome

[@johanBe75]

Whow you make me connect remotely to mine database. TOTAL LIKE!

[@RajuSNair]

+Johan Bech - good to see that your issue is resolved.....:)

[@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?

[@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

[@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

[@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

[@fab99fab]

Thanks for the video...

[@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.

[@softwaresailor4324]

thanks a lot my dear

[@RajuSNair]

You are most welcome

[@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

[@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.

[@jagdeepkumarsah3501]

Good evening Love u making my day. Dear sir i want one sql server same database to open anothe pc . Plz make viedo or help me by reply

[@RajuSNair]

+jagdeep kumar sah - bro....same is what we have given in this video...manage or access one database from another PC over a network..... Means there will be only one SQL server . we can access this SQL server from other machines.....

[@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.

[@lararawf6100]

God bless you

[@RajuSNair]

Always 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

[@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

[@pakistanzindabad]

Thank you for this

[@RajuSNair]

+shahidss - always...welcome.......

[@iusamaaziz]

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.

[@iusamaaziz]

Thanks for your quick reply sir.

[@jagdeepkumarsah3501]

Dear sir Wethere we require to install sql software for all the systems or only one system...

[@RajuSNair]

+jagdeep kumar sah - bro. If you want only to access the main system by using your program...then we have to install only in one main system.... If you wants to use and manipulate SQL data..for example wants to retrieve data using SQL query in ssms...then on both system we need SQL server installed.....

[@manasswain9915]

Both pc sql server install or user pc ssms install. Pls reply

[@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.

[@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.

[@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 ?

[@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?

[@sarunshyam]

Really helpful

[@khaledessam9567]

thank you teacher

[@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.

[@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.

[@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.

[@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....

[@JJJJ-ob6ro]

Man you thing works!!!!

[@RajuSNair]

:)

[@simondurak6423]

Thanks man!

[@RajuSNair]

+Šimon Durák - always welcome......

[@wearemce2010]

how can i know ip address pc1 ? how to check it

[@Guerilla1337]

Thank you man

[@RajuSNair]

Always Welcome.

[@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

[@yasinarafat4837]

Awesome program