[ RESOLVE ] A network-related or instance-specific error while establishing a connection SQL Server

[Music] hi everyone welcome back to the channel this is the next video in the additional skill RPA developer series and the topic which we have chosen is databases prior to this video we have already covered a lot of videos where we are looking at how do you install the SQL Server we have seen the basics and we have also seen how you can create retrieve update and delete the data while many of you were going through this playlist I have got a couple of emails where I found that some people are facing issues when you are actually connecting to the SQL Server management studio for the first time and that is a very common problem when you are working with ssms so this video I am going to show you what exactly that error is and how can you overcome that error without reinstalling the SQL Server right so you don't actually have to reinstall the SQL Server right so let's see first actually what is that error right so I'll go to my start button and I'll try to open the SQL Server management Studio which is ssms I'll just open this right in case you don't have ssms you can always watch the first video in the playlist and that would guide you that how do you install the ssms okay we'll wait for the SQL Server management Studio to open okay now we have this window which says connect to servers and I'm trying to connect to my This Server which is I have been always correcting right this is hosted on my system only and if I simply say connect now here you might notice that the SQL Server is taking more time than expected to connect and this is the place where most of you might be facing some issue where you are getting the error which I will also get and let's then work on the resolution as well okay so we'll just wait for the message to pop up and here it is right it says that I am not able to connect to this server which is this laptop this is my laptop Cur and 4 h72 SQL Express right so this is what we have configured in the first video and now we see that it says that a network related issue has occurred right now many of you what you are doing here is now you are installing the SQL and then reinstalling it and it is working for you right now in this video I am going to show you that how can you work it without actually reinstalling it right so I have got this error so this is the error I just hit okay and it simply says that I am not able to establish the connection okay I'll hit OK and now you simply have to go to the start menu and here you have to search for SQL and you would see something which is called SQL Server 2019 configuration manager right depending on the version of SQL Server you have installed you would have something which is called configuration manager installed on the machine right so I'll go to the configuration manager by double clicking on it and here this will open the SQL Server configuration manager now you would notice here that your SQL Server SQL Express is stopped right so this is actually the service which is responsible for connecting to that instance of the database and which is stopped that is why you are getting that error in this connection wizard right now to fix this you simply have to go here right click on this and you have an option which says start so I say start okay and you would get this pop-up which says starting the service please be patient here let it complete and your state should be running here right previously it was stopped now if you notice here it is now running now it is running here you can just go back to your ssms again and let's try to connect it now by hitting this connect button and you would notice that now I am able to connect to my database and I can see all the database related thing which I was doing right so that is it guys in case you are facing any issues Network related connection just first check your SQL Server configuration manager see the service is running or is stopped or paused right so if it is stop or pause simply come here right click on it and say start and that should actually run your SQL Server management Studio as usual okay so that is it all for this video I would like to wrap this video here in case if you face any more difficulty you can just drop in email and I would like to put it in the troubleshooting video like this right with this I would like to wrap this video here thank you for watching if you like this video please do subscribe to the channel and happy automation [Music] foreign [Music]

Channel: Tutorials by Mukesh Kala

Views: 14,181

Keywords: sql, sql server, sql server 2019, install sql server, sql server management studio, microsoft sql server, install, sql server tutorial, basics of sql for beginners, create table in sql, insert data in sql, where condition in sql, sql queri, sql queries interview questions and answers, sql queries, sql queries tutorial, primary key, primary key and foreign key in sql, sql tutorial, primary key bro code

Id: wYtVs1FPg0g

Length: 5min 2sec (302 seconds)

Published: Tue Jun 13 2023