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
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.
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 !!!!!
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.
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.
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.
@@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
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....
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????
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
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.
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.....
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.
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.
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.
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?
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
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?
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.
@@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
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.
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??
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
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?
+ 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.
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
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
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.
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?
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.
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.
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
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.
if you wants to connect from outside your system then sql server authentication will be the choice. Assign these certain WA users with some username and password on SQL Server Authentication and by using that they can connect from network to your system.
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....
@@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 ?
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)
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.
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.
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
+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 .....................
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?
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. ...........
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..??
I was trying to attach database but some issue : TITLE: Microsoft SQL Server Management Studio Cannot show requested dialog.ADDITIONAL INFORMATION:Parameter name: nColIndex Actual value was -1. (Microsoft.SqlServer.GridControl)
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.
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.
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.
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.
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.
+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.....
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....
Small or Big, you can support me through SUPER THANKS
Clear, straightforward and direct. Great job
Always welcome ☺️
you are the simplest ... the most direct Programmer i've ever seen in my life ... thank you some Much
Always welcome ☺
5 years and people still needing you. Thanks a lot!
Always welcome ☺
Thank you for your server name idea. Successfully connected my SQL Database and my .net Windows App over the internet.
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
You Are Always Welcome
Very helpfull sir.
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
Always welcome
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.
Always welcome
This is like my PP. Short, but very detailed, thank you.
Welcome 🙏 🤗
Short and to the point thanks. Its rare to be seen thee days
Always welcome....
The best lesson I have watched. Many thanks
:)
You must be heaven sent. It works! Thank you, brother...
Always welcome
A straightforward lesson and clear teaching. Thank you so much sir
You are most welcome
many thanks ... very helpful and working video ...
Always welcome
Ô punaise ! Saleté de windaube qui disable le sa userid ainsi que la double authentification !
Merci admin Technomark !
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 !!!!!
Always welcome.....
Many many thanks for explaining the complex steps in a simple and systematic way which has helped me to resolve the issue quickly.
Always Welcome
Thanks Admin !! Absolutely useful help, works even today !!!
You're welcome!
This is the best Video, to explain this method step by step
+Farooq Ahmad - Happy to hear that it really helped... :)
very nice lesson sir , it helped me a lot...solved my sql server connection issue over network
Always welcome ☺
Lov you ❤
Great work done bro..
I have spent 2 days on doing this but failed.. you did it 👍
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.
Thank you so much, This is the best lesson
Always welcome
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.
You're very welcome!
One of the best guide created! Really liked your way. Keep promoting good things in this world.
+Logitizer - thanks bro....definitely will post videos .....
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.
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.
@@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
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....
Not working
Wow. So incredibly helpful. Thank you!
Always welcome
As a db_owner you do not need extra reader and writer because db_owner contains those priviledges as well.
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????
If you can connect your own SQL db with network ID then you can connect from any other machine...
Thank you! Helped a lot! I also loved each your "Ya" throughout the entire video 😁
+Ryu Boado - always welcome......we like improvement and will definitely refine more our videos.....
thank you dearly this was very helpful
Always welcome ☺
you dont know me but i Love you
Always welcome
Thank you so much for the neat explanation.
+Dharmaraj M - always welcome.....
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
thanks you for this video. love from turkey.
Always welcome ....
Best lesson... Respect!
Thank You Teacher
...always welcome......
Thanks a lot sir... Very Useful for me...
welcome...
Great, easy and effecrive tutorial ! Thank you
You are welcome!
Great.. Clean Tutorial.. work like a charm :)
Thanks....
Thank you for this video, greatly explained!
You're very welcome!
thank you brother.. May God richly blessed you.. God bless your endeavor.. =)
+Baby's Day Out - always welcome.....happy that it really helped......will make more videos like this....
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.
U got answer
Thanks for the video. The configs that you have explained were done on the server or client machine?
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.....
@@RajuSNairThanks very much for a detailed explanation.
I really apreciated this video thanks a lot for sharing your knoweladge
+Gian Luca Galazzo - :)
Thankyou sir it helped...
Excellent - thank you - which EXACT version of microsoft SQL server did you use please ?
this works in all. don't worry. Follow these steps one by one as in the video.
Short and very helpful. Thank you!
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.
You are amazing. Thank you
Always welcome ☺
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?
Thank you sir, its really excellent information.
+Guru Angadi - always welcome....
Thank you very much, thank you very much, thank you very much, thank you very much
Always welcome....
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.
:)
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.
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.
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?
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
yes sure..you can go ahead
Thank you so much sir 👌
Always welcome....
Does this work only if computers are connected in the same network or any network outside the organization?
Both intranet and internet are possible. Fir internet go for a dedicated ip address
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?
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.
@@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
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.
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??
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
Lots of love for you sir g
You made my day.
+E-Learning Portal - this really encourages me to do more videos.......happy to hear from you....
this is amazing :) can you please guide me how to connect from other network please
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?
+ 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.
Thanx a billion. Just what I needed.
+Pieter Smith - always welcome ..
..
how can i know ip address pc1 ? how to check it
it works good
thank you very much
Always welcome...
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 .
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
Thanks alot.. this video helped me out alot
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
so you are confused between password... Don't worry....
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.
excellent, thanks bro
Always Welcome
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?
check with firewall settings of server machine and allow connection from your child machine
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?
no...any network it works... even it works on internet also.
Just port forward and configure firewall as described on here
Nice, this safe me. Thanks man!
Most welcome ☺️
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 ??
Thank for explanation. Can we connect two sql-servers over the internet by following the same procedure?
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.
Thanks for your quick reply sir.
you are simply the best.
Thank you...
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.
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.
Absolutely both PCs should be on network either internet or Intranet...
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
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.
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
hello what if i want to share more than one database to another vps? like 5 database.
what if I wanted to add just certain users from windows authentication and give permissions , how can I do this ?
if you wants to connect from outside your system then sql server authentication will be the choice. Assign these certain WA users with some username and password on SQL Server Authentication and by using that they can connect from network to your system.
@@RajuSNair but doesn't that means that I have to change the connection string in the app each time depending on the username ?
i am not able to connect over wifi from wnd machine both pcs are on same network conencting through wifi router please help me
Now I can connect to sql server from another PC (without having on it sql server ) using this method ?
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....
@@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 ?
thank you man! it works on the same network
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)
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.
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.
Yes definitely. It's better to take a dedicated ip address for connecting across internet.
@@RajuSNair Thank you so much. I will try to learn this application.
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.
Thank you so much very helpful
+watsup hayy - always welcome.....
if you face any update on this please add your valuable comments here regarding this topic...
.............
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
+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
.....................
Wow nice info
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?
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.
...........
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.
More than me..the best teacher in WCF will be Pragim ( kudvenkat ).
Follow this link for WCF tutorials.
ruclips.net/video/QmfPmqMk9Xs/видео.html
Thank you sir.
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..??
Same question
can i connect to sql installed on home edition following this process'
Thanks for this video
Always Welcome
Does this method work on an external network, or must the devices be on the same network!!
it works on external also. just need dedicated ip for this to achieve.
@@RajuSNair thanks alot
I was trying to attach database but some issue :
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.ADDITIONAL INFORMATION:Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)
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.
Hi, Ayoub
Try to increase maximum number of concurrent user on SQl server properties Connection tab section.
yes it's set to 20, I got Error Number : 4060, State: 1 Class: 11 (Login Failed for User DESKTOP-F1G...\Nadine)
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.
Is this for LAN only or also Cloud Based?
thanks a lot my dear
You are most welcome
Thanks for the video...
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.
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.
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.
:) ..... I can understand...but Microsoft products VS 2015 is not free. But we can evaluate for 30 days any version like express to ultimate.
Dear sir
Wethere we require to install sql software for all the systems or only one system...
+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.....
Both pc sql server install or user pc ssms install.
Pls reply
Sir can you please help me . I have done all these.
The software is opening but no access to database can you please help me please
only fromlocal network? can i access it from internet ?
Not only on intranet, it works on internet also we can definitely make a try
some of myfriend told me to use static ip for remote access your Database. is it rite?
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....
@@RajuSNair Like how can i connect using Server name remotely..