Thank you very much! I couldnt do it for 6 months! And 20 minutes video helped me! It is the best tutorial I've ever seen. Very simple language, very good explaining. Mr. Kranthi many thanks!!!
Hello Everyone, I added another new course called “ SQL Server 2012 : Performance Tuning in Action with 100 million + rows”. It is going to be started very soon. For complete course description and other details, please contact me at kranthi.sqlserver@gmail.com. Technical Highlights: • Analyze performance bottlenecks • Analyze the SQL query Performance • Design an effective index strategy • Database Engine Tuning Advisor • Analyze Dynamic Management Views (DMVs) • Analyze Statistics and Fragmentation levels • Diagnose and avoid blocking and deadlocks • Analyze execution plans • Develop efficient queries and stored procedures • Analyze and Design the effective query to INSERT a large volume of data ( 100 Million + rows) • Analyze and Design the query to UPDATE the large volume of data ( 100 Million + rows) • Cursor Cost Analysis vs SET based Analysis • Limitations on MERGE statement • How to manage and deal with Enterprise Production server issues Thanks, Kranthi Microsoft Certified Professional Kranthi.sqlserver@gmail.com
+Kranthi Kumar due to the fact that the public IP changes every time i connect, it becomes difficult for me to connect to a computer that is on a remote location without knowing its current IP. i want a type of connectivity that can happen anytime without having to contact the remote user to give me their public IP
Thank you thank you very much Mr.kranthi. no words to say many thanks it's very helpful.i tried this for 2 days before seeing this video now you solved my problem Thank you very much
Thank you a lot! Kranthi, You opened what it was a black box for me. This will save me some money when using my own box while creating prototypes apps. God bless you.
If you assign static ports to each intance then you don't need the sql server browser. You can connect specifying ip and port. Then port forwarding does the job.
i like this tutorial.... how about if the ip public is dynamic, means changes from the internet provider ? can the mssql connect using host name not by ip ( i tried using free ddns service) ?
Hey....Great Tutorial !!!.. I Followed All Steps and got Success in Connecting From Local IP Address only....But I Failed To Connect From Public IP.... I've TP-Link Router so i would be so grateful if you will Give me the steps for port forwarding ........Service Port and Internal Port...etc!!!
Hello Kranthi! Umm, I was able to add the SQL Browser Service, but the SQL Server itself isn't visible in my Allowed Programs. Can you tell me where it's location is?
Hi, I created a database using SQL on my server, and then created a program that connects to that database and can make changes. if I install that program on multiple computers, i want it to be able to make changes to the database so other computers can see it. Also when I was adding sqlbrowser, the sql server wasn't there. If you could help me out with this, I'll appreciate it, thank you.
Hey Kranthi! Its great You are giving so much information - but I have the same problem as Goswami :(. I'm using Tenda W541R router - and here aren't "Port Forwarding", but what i read on the internet - it is Virtual Server on my router. I entered the same ports as You are, but I can't connect. Can You help me please, here or if it is possible to speak via Skype or e-mails - it will be great. I really want to start that server! Thanks !!!
This is really helpful.. however can you connect to the SSRS through the internet also? I've tried everything but if I come in through the IP address, I can not log in to the SS Reports as rather than logging as domain, it is logging as the IP address.
You are awesome!!! Great tutorial....one thing that got ensure you use the Default Port 1433 or change it in the Default Port in Client Protocols, Thanks again!!!!
why should i have to install sql server browser service when i am using default instance with default port 1433 ?? beacuse sql server browser listen at 1434 port no for udp connections?
Hi Kranthi Kumar im a total newbie here on sql. i want to know how you create Protocols for COREQA? can you post another tutes on how to add protocols under SQL Server Network Configuration
can some help me i do all steps one by one and i still got on Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server
Hi Kranthi, can you tell me please, how should I indicate Server for ODBC connection? I try to connect MS Access to the SQL Server. For (local) server it works perfect, but I don't know how to set for remote connection.
hello.. In Server network Configuration ,i don't have it ,how i can to create them . or what edition of sql express 2012 i download for this propocols sql coreqA and coreDev installed . I work on Winserver2012r OS and sqlexpres 2012
Hi, this is a very helpful video. Many thanks to you! I was able to connect my other PC to my server by using my public IP address. however when I tried connecting from a different location using my main location's public IP, it doesn't work. Need advice. Thanks.
Sir I face some problem with router configuration. I use DLINK DIR-600M router. Please guide me how to configure port forwarding in this router. Here I find out a option Port Triggering. But some how I can't configure it properly .
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?
Hi, I have followed your steps, I have netgear Router and done with port forwarding, I am able to connect to SQL server with local IP, but not with Public IP, getting error as a network related or instance specific error
Please I have a question. If I develop and application an I hard my IP address into the sql connection string. Question 1: if my IP address change, my connection will fail. Question 2 how can I resolve this dynamic IP address from ISP
Thanks Kranthi Kumar ji for this informative video.. I followed every step as narrated by u but unfortunately i m not able to make remote connection for SQL server 2014 express edition. I get error message showing error 26... Can u help me please... Regards.. Shekhar
I don't have any other services, only SQL server. I have done the same but I can not connect through the internet, it works fine with the local network. FYI, I am using NetGear Router.
Thank you very much! I couldnt do it for 6 months! And 20 minutes video helped me! It is the best tutorial I've ever seen. Very simple language, very good explaining. Mr. Kranthi many thanks!!!
Hello Everyone,
I added another new course called “ SQL Server 2012 : Performance Tuning in Action with 100 million + rows”.
It is going to be started very soon. For complete course description and other details, please contact me at kranthi.sqlserver@gmail.com.
Technical Highlights:
• Analyze performance bottlenecks
• Analyze the SQL query Performance
• Design an effective index strategy
• Database Engine Tuning Advisor
• Analyze Dynamic Management Views (DMVs)
• Analyze Statistics and Fragmentation levels
• Diagnose and avoid blocking and deadlocks
• Analyze execution plans
• Develop efficient queries and stored procedures
• Analyze and Design the effective query to INSERT a large volume of data ( 100 Million + rows)
• Analyze and Design the query to UPDATE the large volume of data ( 100 Million + rows)
• Cursor Cost Analysis vs SET based Analysis
• Limitations on MERGE statement
• How to manage and deal with Enterprise Production server issues
Thanks,
Kranthi
Microsoft Certified Professional
Kranthi.sqlserver@gmail.com
Super...! U rock.
+Kranthi Kumar due to the fact that the public IP changes every time i connect, it becomes difficult for me to connect to a computer that is on a remote location without knowing its current IP. i want a type of connectivity that can happen anytime without having to contact the remote user to give me their public IP
Static public may help you. OR just check www.noip.com/
Thanks for you video. It has helped me three years later than you did it. You explain very well.
Thank you thank you very much Mr.kranthi. no words to say many thanks it's very helpful.i tried this for 2 days before seeing this video now you solved my problem Thank you very much
Many many thanks for this tremendous tutorial...it helped me figure out my problem to connect....you are Boss
11:55 you put all the ports open, you can also turn off your firewall.
I think you have then the same result.
The best Tutorial, Thanks Kranthi Kumar Sb.
Awesome job. You rescured me from 6hrs troubleshooting
Thank you a lot! Kranthi,
You opened what it was a black box for me. This will save me some money when using my own box while creating prototypes apps. God bless you.
Hi it was a very good example i finally got how to connect sqlserver online Thank You !
That's exactly what i wanted and searching for over the weeks. Thank you very much
I never seen any tutorial as good as this!
Thanks you so much!!!!!
Really good walk through. Thank you so much, had it all working within 15 minutes. SQL Server Express on a Windows 7 machine. again, much appreciated.
Great video. I have learnt so much from it.thank you.
Very well done. I got a lot of good information and some good explanation of the internal workings for connecting to a SQL Server instance.
Very nice tutorial.... tnx a lot
Great tutorial! Right on the spot and valid many years ahead!
hello sir, your video is very helpful to all of us
i tried to open a connection using c# grid view but it is not connect can u please send me an sqlserver driver
Simply Excellent, thank you ji
hello you are great.. thanks for tutorial.. keep it up.. I am a newbie and i learned something new to me.. :)
thanks for sharing helpful video, pls make more videos
Thanks!!! This is the best tutorial.
Thank you!! It helps me in a hard time in here!!
Very good explanation.. thank you very much...
I really appreciate your this particular video. Very helpful thanks.
Great Video. Now I can connect through the internet.
i perform all the steps but i can't connect can you please help me thank you in advance
Thanks for sharing this very useful information.
Great video. Still relevant. Helped me out a lot today. Perfect. Thanks, Kranthi!
Well done Kranthi,
Very good tutorial...
If you assign static ports to each intance then you don't need the sql server browser. You can connect specifying ip and port. Then port forwarding does the job.
Thank you so much! Hope all good things for you!
Thanks for your video, it really usefull for me.
Thanks a lot, Kranthi!!!
in my sql server configuration manager i don't have that option Protocols for MSSQLServer at 5:20... how to find out which port SQL Server is using ?
Yes. You can connect C# application but your SQL server address should be your Public IP address.
i like this tutorial....
how about if the ip public is dynamic, means changes from the internet provider ?
can the mssql connect using host name not by ip ( i tried using free ddns service) ?
should you connect to the server pc using ethernet? cause i tried with portable wi-fi i am not getting connected. Please advise
Nice Tutorial thanks was usefull
Connected remotely via VPN even! Big thanks!
Your router should have PORT FORWARDING option on left side.
very helpfull thank you so much sir
GOOD, informative
Yes. you should have to open 1433 to connect your sql server through NET.
Great job dude! Well done! well detailed explanation! Thank you
Hey....Great Tutorial !!!.. I Followed All Steps and got Success in Connecting From Local IP Address only....But I Failed To Connect From Public IP.... I've TP-Link Router so i would be so grateful if you will Give me the steps for port forwarding ........Service Port and Internal Port...etc!!!
Hello Kranthi!
Umm, I was able to add the SQL Browser Service, but the SQL Server itself isn't visible in my Allowed Programs. Can you tell me where it's location is?
thanks sir your video very was very helpful
Hi, I created a database using SQL on my server, and then created a program that connects to that database and can make changes. if I install that program on multiple computers, i want it to be able to make changes to the database so other computers can see it. Also when I was adding sqlbrowser, the sql server wasn't there. If you could help me out with this, I'll appreciate it, thank you.
Thank you so much for your presentation
Hey Kranthi! Its great You are giving so much information - but I have the same problem as Goswami :(. I'm using Tenda W541R router - and here aren't "Port Forwarding", but what i read on the internet - it is Virtual Server on my router. I entered the same ports as You are, but I can't connect. Can You help me please, here or if it is possible to speak via Skype or e-mails - it will be great. I really want to start that server! Thanks !!!
This is really helpful.. however can you connect to the SSRS through the internet also? I've tried everything but if I come in through the IP address, I can not log in to the SS Reports as rather than logging as domain, it is logging as the IP address.
Helpfull in 2021 ! Thanks
Hi! This is great! But I have a question. What should I do if I want to connect to the SQL Server from another computer connected to another network?
You are awesome!!! Great tutorial....one thing that got ensure you use the Default Port 1433 or change it in the Default Port in Client Protocols,
Thanks again!!!!
But is it necessary to expose RDP? Let said I only interested to pull some data from the tables from public Internet
why should i have to install sql server browser service when i am using default instance with default port 1433 ?? beacuse sql server browser listen at 1434 port no for udp connections?
Hi Kranthi Kumar im a total newbie here on sql. i want to know how you create Protocols for COREQA? can you post another tutes on how to add protocols under SQL Server Network Configuration
something else, If I use that application in another house, I have to open this port, the port 1433 and the other. or this is only to the Server.
Excellent video. Thank you!
Please upload your notes to the site.So , that we can work the same examples you used in the video's for practise.
thanks!!! I connect sql server but want connect into DNS not ip adresse how to do that ???
Thank you so much !! It helped me a Lot
Saved my life, thanks!
Thanks for your support, rely appreciated.
Is it possible to do this with 2 computers running SQL Express??? I tried your way but no luck. Thanks
can some help me i do all steps one by one and i still got on Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server
Very helpful. Thank you.
Hi Kranthi, can you tell me please, how should I indicate Server for ODBC connection? I try to connect MS Access to the SQL Server. For (local) server it works perfect, but I don't know how to set for remote connection.
Same issue I am also facing while connecting Ms access with different system where SQL has installed
if i have the sql server stand alone installation installed can i install a New R Server to get the the SQL Server configuration manager
well define, well explained Thumbs up for Kranthi. i have one question in mind. Are you familiar in MLM programming?
hello.. In Server network Configuration ,i don't have it ,how i can to create them .
or what edition of sql express 2012 i download for this propocols sql coreqA and coreDev installed . I work on Winserver2012r OS and sqlexpres 2012
how do i get the folder SQL Server 2008 R2 ? I have SSMS and SQL Server 2016 installed but dont have that folder.
Thanks.. Good Job..
Hi, this is a very helpful video. Many thanks to you! I was able to connect my other PC to my server by using my public IP address. however when I tried connecting from a different location using my main location's public IP, it doesn't work. Need advice. Thanks.
Sir I face some problem with router configuration. I use DLINK DIR-600M router. Please guide me how to configure port forwarding in this router.
Here I find out a option Port Triggering. But some how I can't configure it properly .
excellent!!! it help me thanks
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?
Thank you so much for this video.. :)
Hi, I have followed your steps, I have netgear Router and done with port forwarding, I am able to connect to SQL server with local IP, but not with Public IP, getting error as a network related or instance specific error
Hi Kranthi, Great Video, would it be possible for you to assist me online ?
thanks it was very helpfull
Many thanks Sir!
sir if we have created a web page and we have server to is there any need to have web host and domain .
Helped me alot .Thanks!
Hey, this was great. Really helpful! I subscribed!
what happens when an ISP static ip is down.....then how to use the sql server from client pc?
Hi! Thanks! Very good!
Simply genius!!
I there a way to connect from different Networks?
Please I have a question. If I develop and application an I hard my IP address into the sql connection string.
Question 1: if my IP address change, my connection will fail.
Question 2 how can I resolve this dynamic IP address from ISP
Thanks Kranthi Kumar ji for this informative video.. I followed every step as narrated by u but unfortunately i m not able to make remote connection for SQL server 2014 express edition. I get error message showing error 26... Can u help me please... Regards.. Shekhar
Yes I Know That...but HOW???? and Which Port Number should I Have To Forward???
how to manage this in dynamic ip address bcz our public is is not static
Thanks a lot for your help
I don't have any other services, only SQL server. I have done the same but I can not connect through the internet, it works fine with the local network. FYI, I am using NetGear Router.
Hi,
I need to change my data location to my local netwrok cloud drive ,how should i do it
i cant start sql server browser. its start mode is set to Other. when i right click the option to start is greyed out. please help
thanks for the video. much appreciated.
How can I connect to MS SQL Server with an IP Address without Instance name ? My instance name show (LOCAL)