HomeЛюди и блогиRelated VideosMore From: Admin Technomark

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

281 ratings | 55635 views
Buy Redmi 6 Pro (Gold, 32GB) - https://amzn.to/2Ntpkv4 Redmi Y2 (Gold, 3GB RAM, 32GB Storage) - https://amzn.to/2BXkNie Redmi 6 Pro (Black, 32GB) - https://amzn.to/2NofTwN Redmi 6 Pro (Gold, 64GB) - https://amzn.to/2BXMJmm Redmi Y2 (Black, 32GB) - https://amzn.to/2NqoHlV OnePlus 6 (Mirror Black, 6GB RAM, 64GB Storage) - https://amzn.to/2NrqtDb Redmi Y2 (Dark Grey, 3GB RAM, 32GB Storage) - https://amzn.to/2BXwvcS Redmi 6 Pro (Black, 64GB) - https://amzn.to/2OauUHV Connect To SQL Server Database Over A Network, connect to sql server database via LAN, Enable Network Access in SQL Server Database, Enable Remote Connection In SQL Express, Enable Remote Connection Over Network, Connect To SQL Server Database, Configure SQL Server To Allow Network Connection, Connect To SQL Server Database Over A Network Using Management Studio, Sharing a Database on a Local Area Network, SQL Server Database, SQL Server Allow Remote Connections to SQL Server Express, Allow Remote Connections to SQL Express, Allow Remote Connections to SQL, Allow Remote Connections To MSSQL, Remote Connections To SQL Express Verbinden mit SQL Server-Datenbank über Netzwerk - Aktivieren Sie den Netzwerkzugriff in SQL Server Conectarse a la base de datos de SQL Server a través de la red: habilitar el acceso a la red en SQL Server Connessione al database SQL Server tramite rete: abilitare l'accesso alla rete in SQL Server Se connecter à la base de données SQL Server sur le réseau - Activer l'accès au réseau dans SQL Server Подключение к базе данных SQL Server через сеть - включение сетевого доступа в SQL Server Podklyucheniye k baze dannykh SQL Server cherez set' - vklyucheniye setevogo dostupa v SQL Server 通过网络连接到SQL Server数据库 - 在SQL Server中启用网络访问 Tōngguò wǎngluò liánjiē dào SQL Server shùjùkù - zài SQL Server zhōng qǐyòng wǎngluò fǎngwèn ネットワーク経由でSQL Serverデータベースに接続する - SQL Serverでネットワークアクセスを有効にする Nettowāku keiyu de SQL sābā dētabēsu ni setsuzoku suru - SQL sābā de nettowākuakusesu o yūkōnisuru Conectar-se ao banco de dados do SQL Server pela rede - habilitar o acesso à rede no SQL Server Anslut till SQL Server Database över nätverk - Aktivera nätverksåtkomst i SQL Server
Html code for embedding videos on your blog
Text Comments (138)
Logitizer (5 days ago)
One of the best guide created! Really liked your way. Keep promoting good things in this world.
Admin Technomark (5 days ago)
+Logitizer - thanks bro....definitely will post videos .....
Baby's Day Out (11 days ago)
thank you brother.. May God richly blessed you.. God bless your endeavor.. =)
Admin Technomark (11 days ago)
+Baby's Day Out - always welcome.....happy that it really helped......will make more videos like this....
jagdeep kumar sah (14 days ago)
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
Admin Technomark (13 days ago)
+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.....
Zeeshan Qureshi (17 days ago)
love you Sir.. made my day!!!.. <3
Zeeshan Qureshi (14 days ago)
+Admin Technomark Thanks for Considering it Sir. <3 <3
Admin Technomark (15 days ago)
+Zeeshan Qureshi - always welcome.....love to hear from you.....will host more videos like this....
Šimon Durák (22 days ago)
Thanks man!
Admin Technomark (22 days ago)
+Šimon Durák - always welcome......
Rukhsar Ahmad (1 month ago)
I want to know , it will effect if we restart first computer or second ?
Rukhsar Ahmad (1 month ago)
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
Admin Technomark (1 month ago)
+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....?....
Rukhsar Ahmad (1 month ago)
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.
Admin Technomark (1 month ago)
+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... ...
shahidss (1 month ago)
Thank you for this
Admin Technomark (1 month ago)
+shahidss - always...welcome.......
Guru Angadi (1 month ago)
Thank you sir, its really excellent information.
Admin Technomark (1 month ago)
+Guru Angadi - always welcome....
E-Learning Portal (2 months ago)
Lots of love for you sir g You made my day.
Admin Technomark (2 months ago)
+E-Learning Portal - this really encourages me to do more videos.......happy to hear from you....
Donald Race (2 months ago)
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
the dean (2 months ago)
i did exactly like what u say can i connect to my db from login app in android now ???? and how ??
the dean (2 months ago)
Ok cool So i don't need put my database in hosting website to access it ...just do the configuration in ms sql .... I want to link android app an vb.net project with on sql database ...when user login from android it must show in vb.net Sorry I know my questions are silly and thanks for your time and your great tutorials❤
Admin Technomark (2 months ago)
In this video....we have explained how to connect to sql server which is on another network from your system.... This can be done different platform also..... if you are ok to connect to a sql server from android then you can do it over a network also.... Just change the connection string and update sql configuration as shown in this video.......
Admin Technomark (2 months ago)
hay
Arunshyam Selvaraj (3 months ago)
Really helpful
Solomon Amo-Boateng (3 months ago)
thanks much appreciated
Admin Technomark (3 months ago)
+Solomon Amo-Boateng - always welcome....
Homer Paulo Ramos (5 months ago)
My sql server network configuration is empty
Admin Technomark (5 months ago)
+Homer Paulo Ramos - yes...go ahead with that...tell me if you are facing any problem there.....
Homer Paulo Ramos (5 months ago)
Can I use the Server Network Configuration (32bit) it is not empty, it has TCP/Ip
Admin Technomark (5 months ago)
+Homer Paulo Ramos - did you instaleed sql server then which ver u r using... Try to add another instance by installing sql server again. ........
Ryu Boado (6 months ago)
Thank you! Helped a lot! I also loved each your "Ya" throughout the entire video 😁
Admin Technomark (6 months ago)
+Ryu Boado - always welcome......we like improvement and will definitely refine more our videos.....
watsup hayy (7 months ago)
Thank you so much very helpful
watsup hayy (7 months ago)
Wow nice info
Admin Technomark (7 months ago)
+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 .....................
watsup hayy (7 months ago)
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
Admin Technomark (7 months ago)
+watsup hayy - always welcome..... if you face any update on this please add your valuable comments here regarding this topic... .............
Farooq Ahmad (7 months ago)
This is the best Video, to explain this method step by step
Admin Technomark (7 months ago)
+Farooq Ahmad - Happy to hear that it really helped... :)
Pieter Smith (7 months ago)
Thanx a billion. Just what I needed.
Admin Technomark (7 months ago)
+Pieter Smith - always welcome .. ..
D Chord Studios (8 months ago)
Thank you for this great video <3
Admin Technomark (8 months ago)
+D-Chord Studios - its nice that my effort was not waste..... ....
Gian Luca Galazzo (8 months ago)
I really apreciated this video thanks a lot for sharing your knoweladge
Admin Technomark (8 months ago)
+Gian Luca Galazzo - :)
maheesha madhubashini (8 months ago)
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?
maheesha madhubashini (8 months ago)
Thank you sir.
Admin Technomark (8 months ago)
More than me..the best teacher in WCF will be Pragim ( kudvenkat ). Follow this link for WCF tutorials. https://www.youtube.com/watch?v=QmfPmqMk9Xs&list=PL6n9fhu94yhVxEyaRMaMN_-qnDdNVGsL1
maheesha madhubashini (8 months ago)
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.
Admin Technomark (8 months ago)
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. ...........
Aiqin Pineda (8 months ago)
i dont now the password, I did the same thing but it it gets error
Admin Technomark (8 months ago)
+Aiqin Pineda - :)
Aiqin Pineda (8 months ago)
thank you, thank you soo much, you're a life saver! its working now
Admin Technomark (8 months ago)
create another user with a new password and just modify your connection string..
Abdul Sami (8 months ago)
Hello sir , my question is it neccesary that both the pcs are on same network ??
Abdul Sami (8 months ago)
Okay thanks alot Let it me to try I have sqlmanagement studio 2014 Vs studio 2015 Windows 10 Hope so same procedure do work
Admin Technomark (8 months ago)
+Abdul Sami - anywhere on internet can be configured like this. I have did in both internet and intranet environment.
Not Bad (9 months ago)
I have many question can you please give me your email so I can contact you??
Admin Technomark (9 months ago)
You are seeing us because of youtube.... so please make all communications through this platform... It will allow others also to see the details.... .....................
Azeem Raza (10 months ago)
HELLO I HAVE TO CONNECT SQL SERVER OVER INTERNET, TOPOLOGY IS THAT SQL SERVER ACCESS THROUGH PUBLIC IP FOR SQL SERVER USERS. PLEAS SHARE ME AND GUIDE ME SOLUTION.
Azeem Raza (9 months ago)
Now try to connect in client machine to the Client server itself using IP and port in management studio.? where we define path of server in client machine?
Azeem Raza (10 months ago)
i have understand at client end, pleas understand me steps what i have to do at server end?
Azeem Raza (10 months ago)
thanks
Admin Technomark (10 months ago)
in SQL server, enable SQL server Authentication mode and add a username and password. Now do a restart SQL server. Now open SQL Configuration manager. Select you sql instance. Enable TCP . Add a port under IP All section and press apply. Now again do a SQL server restart. You can see this much of steps from the beginning of the video. Just follow as it in the video. :) .....
Azeem Raza (10 months ago)
Now just configure SQL server and Configuration manager as in this video.? pleas explain little bit.
Thasneem Jambi (10 months ago)
Best lesson... Respect! Thank You Teacher <3
Admin Technomark (10 months ago)
...always welcome......
Antonio de Sousa (11 months ago)
Good video, thanks... but, it would be nice to see how you connect to a sql server instance outside the network via the internet...
Admin Technomark (11 months ago)
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. .......................
khaled essam (1 year ago)
But the connection string in the system !! How to be
khaled essam (1 year ago)
Thank you very much
khaled essam (1 year ago)
OK Thank you teacher I am a student from northern Sudan Merwe city
Admin Technomark (1 year ago)
On second machine, you only needs to install SQL Server Management Studio only. On First machine, you can install sql server. Even express edition is enough.
khaled essam (1 year ago)
Ok do i need to install sql server in client machine or install the interfaces only
Admin Technomark (1 year ago)
Connection string.... in the datasource section, just give the IP with Port as you use on SSMS. Better, you use Visual studio to map the Server and get the Constring that it generate. For example.... <add name="XXX" connectionString="metadata=res://*/DBNAme.csdl|res://*/DBNAme.ssdl|res://*/DBNAme.msl;provider=System.Data.SqlClient;provider connection string='data source=&quot;192.168.111.45, 1433&quot;;initial catalog=DBNAme;user id=username; password=PASSWORD;MultipleActiveResultSets=True;App=EntityFramework'" providerName="System.Data.EntityClient" />
khaled essam (1 year ago)
thank you teacher
Raptor 911 (1 year ago)
Thank you so much!!! IT WORKED!!!
Admin Technomark (1 year ago)
always welcome...we will definitely make more videos like this..
Bala Krishnan (1 year ago)
Thanks a lot sir... Very Useful for me...
Admin Technomark (1 year ago)
welcome...
Roman Venica (1 year ago)
Nice! This worked for me!
Admin Technomark (1 year ago)
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.
amarender Reddydodle (1 year ago)
Hi Friend this video is very help full, do we need to configure these steps in both primary and secondary machines...?
Admin Technomark (1 year ago)
Hope you are very clear
Admin Technomark (1 year ago)
how to get ip address of base machine..? open cmd in base machine and type ipconfig. you will get ip address
Admin Technomark (1 year ago)
try to open cmd as administrator
Admin Technomark (1 year ago)
cmd means command prompt window.
Admin Technomark (1 year ago)
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.
Marius Ghita (1 year ago)
thank you man! it works on the same network
Guerilla1337 (1 year ago)
Thank you man
Admin Technomark (1 year ago)
Always Welcome.
Tej Rijal (1 year ago)
i unable to connect on different network , its working on same network using pc , plz help
Tej Rijal (1 year ago)
sir ,Guide Me 1. if i go through IP connection what kind of security i need to provide, suggest me some best methods(hint plz) 2. which option would be better from below (a). Provide separate User login for each remote PC or (b) .Provide just one User login for all remote PC compare in terms of speed
Admin Technomark (1 year ago)
Hey Tej... Its all about how much security that you can provide for the database. In connecting using IP address, how much security that you can provide? If you are not confident, go with first option. Second...How much optimized your third party is and are they always good..these are some home work that should be done. In case any minor issue..you can put a test case of whether its because of third party.
Tej Rijal (1 year ago)
thanks sir, finally i found the solution by port forwarding in router and able connect in Public IP also, i have another question , plz suggest me which option would be better for 1.hosting localdb over the internet using third party cloud 2.connect normally using ip address which one is better???? Plz reply
Admin Technomark (1 year ago)
Hey Tej...welcome here. 1. Try to ping from both systems for ensuring connection Status. 2. If you are able to ping from both systems, then try to connect using MS management studio as shown in this video. Please tell me your status now. Have you able to ping at least.
Elandré van der Walt (1 year ago)
Short and very helpful. Thank you!
Admin Technomark (1 year ago)
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.
Dinh Nhan (1 year ago)
thanks :D
Admin Technomark (1 year ago)
Hope your problem get resolved. :)
Allen Santison (1 year ago)
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.
Admin Technomark (1 year ago)
:)
Little Monk (1 year ago)
The best lesson I have watched. Many thanks
Admin Technomark (1 year ago)
:)
Josh JJ (1 year ago)
Man you thing works!!!!
Admin Technomark (1 year ago)
:)
Ayoub Ben (1 year ago)
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.
Admin Technomark (1 year ago)
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.
Ayoub Ben (1 year ago)
yes it's set to 20, I got Error Number : 4060, State: 1 Class: 11 (Login Failed for User DESKTOP-F1G...\Nadine)
Admin Technomark (1 year ago)
Hi, Ayoub Try to increase maximum number of concurrent user on SQl server properties Connection tab section.
deepaksky (1 year ago)
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.
Admin Technomark (1 year ago)
:) ..... I can understand...but Microsoft products VS 2015 is not free. But we can evaluate for 30 days any version like express to ultimate.
deepaksky (1 year ago)
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.
Admin Technomark (1 year ago)
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.
abbeydudeuk (2 years ago)
While trying the above steps I got error. Can i send you the step by step screen shot please
Admin Technomark (2 years ago)
On Second machine do following. 1. Configure SQL Express To Allow Remote Connection. 2. Enable SQL Server Authentication mode. 3. Your Login / User should be enabled for db_owner, db_reader, db_writer. 4. Enable TCP for the SQL Instance on SQL Server Configuration Manager. 5. On IPALL section assign a port number. Not for dynamic port. 6. Next do a SQL Server restart. 7. Allow firewall to allow above assigned port (Create New Inbound Rule). 8. Your Computer should be allowed to access from network. That's all, this much of step will definitely Make this happen. For generating connection string I prefer use entity framework connection string.
Admin Technomark (2 years ago)
of course, you can send me on [email protected]
abbeydudeuk (2 years ago)
you are simply the best.
Admin Technomark (2 years ago)
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.
Admin Technomark (2 years ago)
Thank you...

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.